Parameter Name	Description
BASE	Returns the value of the REFSTR property of the current object.
CURRENT_PROFILE	Returns the value of the REFSTR property of the current user profile.
CURRENT_USER	Returns the value of the REFSTR property of the current user.
CURRENT_MANDATE	Returns the current mandate of the user. The Alfabet parameter can be used for example to limit search results to objects that are assigned to the mandate the user is currently logged in with, for example: ALFABET_QUERY_500 FIND ICTObject WHERE ICTObject.MANDATEMASK CONTAINS @CURRENT_MANDATE NOTE: The parameter CURRENT_MANDATE (and the whole statement it is used in) is ignored if the user has no mandate assigned or is working as mandate master.
CURRENT_CULTURE	Returns the Microsoft® Windows® Locale identifier (LCID) of the current culture of the Alfabet user interface. Please note that the culture that is selected as default culture is always returned as 127, which means default, independent from the LCID of the culture.
TODAY	Returns the current date.
ALFA_SERVER_URL	Returns the value of the attribute Web Server of the server alias configuration of the Alfabet component processing the query. The attribute Web Server is editable in the Overview tab of the server alias configuration editor.
BASE<number>	For queries defined in the context of layered diagrams and grid reports only! If the report is configured to allow cascading queries, and more than one level of related objects us defined, BASE0 returns the value of the REFSTR property of the parent object in the directly superordinate level of the diagram. BASE1 returns the ancestor object in the level superordinate to the parent object level etc.
WIZARDBASE	For queries defined in the context of wizard configuration only! Return the value of the REFSTR property of the base object of the wizard. The base object of the wizard can be different from the base object of a wizard step. This parameter allows to refer to the base object of the wizard for example in pre-conditions of steps that have a different base object than the overall wizard.
WORKFLOW	For queries defined in the context of workflow configuration only! Returns the value of the REFSTR property of the workflow. Each workflow corresponds to an object Workflow in the Alfabet database. The parameter is useful when defining queries that refer to properties of the class Workflow, like for example the workflow owner or the workflow initiator. .
WORKFLOWBASE	For queries defined in the context of workflow configuration only! Returns the value of the REFSTR property of the base object of the workflow. The base object of the workflow can be different from the base object of a workflow step. This parameter allows to refer to the base object of the workflow for example in pre-conditions of steps that have a different base object than the overall workflow.
LAST_EXECUTION	For queries defined in the context of monitors only. Returns the date of the last execution of the monitor.

Define a configured report

Configured reports for conditions can either be based on Alfabet query language or native SQL.

configured reports can be structured in folders. You can create a folder containing your configured reports for conditions only. Right-click the root node of the explorer in the Reports tab of Alfabet Expand, select Create New Folder and change the default name of the folder.

In the Reports tab of Alfabet Expand, right-click the root node or the node of the report folder for condition reports and select Create New Report.

Click the new report in the explorer and set the relevant attributes:
- Native SQL Query: Define a native SQL query which only returns a result if a specific condition is fulfilled. You can use Alfabet query parameters to refer to the current environment of the user, like the object the user is currently working with.
  Alfabet query parameters
  You can use Alfabet query parameters in both native SQL queries and Alfabet queries to refer to the current context in the Alfabet user interface. For example, to refer to the object the user is currently working with, the user executing the report, or the current workflow being executed in WHERE clauses. During execution of the Alfabet query, the Alfabet parameter is substituted with the current return value. If no value is returned, the Alfabet query is executed without the WHERE statement.
  Write Alfabet parameters as:
  - @ParameterName
  For example:
  - WHERE APPLICATIONGROUP.BELONGSTO CONTAINS @BASE
  finds all application groups subordinate to the application group the user is currently working with on execution of a native SQL query.
  The following Alfabet parameters can be used for Alfabet queries and native SQL queries:
  Parameter Name Description
  BASE Returns the value of the REFSTR property of the current object.
  CURRENT_PROFILE Returns the value of the REFSTR property of the current user profile.
  CURRENT_USER Returns the value of the REFSTR property of the current user.
  CURRENT_MANDATE Returns the current mandate of the user. The Alfabet parameter can be used for example to limit search results to objects that are assigned to the mandate the user is currently logged in with, for example:
  ALFABET_QUERY_500
  FIND ICTObject
  WHERE ICTObject.MANDATEMASK CONTAINS @CURRENT_MANDATE
  NOTE: The parameter CURRENT_MANDATE (and the whole statement it is used in) is ignored if the user has no mandate assigned or is working as mandate master.
  CURRENT_CULTURE Returns the Microsoft® Windows® Locale identifier (LCID) of the current culture of the Alfabet user interface.
  Please note that the culture that is selected as default culture is always returned as 127, which means default, independent from the LCID of the culture.
  TODAY Returns the current date.
  ALFA_SERVER_URL Returns the value of the attribute Web Server of the server alias configuration of the Alfabet component processing the query. The attribute Web Server is editable in the Overview tab of the server alias configuration editor.
  BASE<number> For queries defined in the context of layered diagrams and grid reports only! If the report is configured to allow cascading queries, and more than one level of related objects us defined, BASE0 returns the value of the REFSTR property of the parent object in the directly superordinate level of the diagram. BASE1 returns the ancestor object in the level superordinate to the parent object level etc.
  WIZARDBASE For queries defined in the context of wizard configuration only! Return the value of the REFSTR property of the base object of the wizard. The base object of the wizard can be different from the base object of a wizard step. This parameter allows to refer to the base object of the wizard for example in pre-conditions of steps that have a different base object than the overall wizard.
  WORKFLOW For queries defined in the context of workflow configuration only! Returns the value of the REFSTR property of the workflow. Each workflow corresponds to an object Workflow in the Alfabet database. The parameter is useful when defining queries that refer to properties of the class Workflow, like for example the workflow owner or the workflow initiator. .
  WORKFLOWBASE For queries defined in the context of workflow configuration only! Returns the value of the REFSTR property of the base object of the workflow. The base object of the workflow can be different from the base object of a workflow step. This parameter allows to refer to the base object of the workflow for example in pre-conditions of steps that have a different base object than the overall workflow.
  LAST_EXECUTION For queries defined in the context of monitors only. Returns the date of the last execution of the monitor.
  The query must meet the following requirements:
  - The query must not be complex. If a complex relationship shall be tested for the visibility condition, create a database view and refer to the database view results in the query for the condition.
  - The query definition must not include Alfabet instructions.
  If issues occure due to condition queries not meeting these requirements, system administrators can see the reason for the issues in the system log as a warning message.
This setting is for the definition of a configured report executing a native SQL query. If you would like to execute an Alfabet query, set the Type attribute to Query and define the Alfabet query in the Alfabet Query attribute.

In the toolbar, click Save

The following native SQL query only returns a result if the current object is active. It can be used in conditions for configuration elements to show them either if the query returns a result or if the query does not return a result:

SELECT app.REFSTR AS 'REFSTR', app.NAME AS 'AppName', app.VERSION AS 'AppVersion'
FROM APPLICATION app
WHERE app.REFSTR = @BASE
AND app.OBJECTSTATE = 'Active'

Define a configured report

Alfabet query parameters