In many cases, you will want to pass a parameter value into a query rather than using a static query definition. AppBoard provides a system of variable expressions, called SHIM, that can be used for this purpose. This page reviews the concepts of using SHIM expressions and provides some examples.
1. Inserting SHIM Expressions
There are a number of input fields in AppBoard that allow the insertion of SHIM expressions. To see if a SHIM expression can be inserted, click in an edit box and check to see if the "Insert Expression" button is displayed and clickable in the footer bar.
Perform the following steps to insert a SHIM expression:
- Click in an edit box at the location where you want to insert an expression
- Select Insert Expression
- Click the tab label to select from one of the available options:
- Access Control Variable - Allows you to insert a custom variable that you have configured for the system. For more information on this option, see configuring Access Control Variables
- Basic User Info - Will insert a pre-defined SHIM expression related to the attributes of the current User. Select the variable to be inserted from the list:
- username - Apply the User's id in the selected location when data is accessed
- password - Apply the User's password in the selected location when data is accessed
- domain - Apply the User's domain in the selected location when data is accessed
- rolename - Apply the User's current role in the selected location when data is accessed
- rolepath - Apply the User's current hierarchical role path in the selected location when data is accessed
- Date - Build a date function to apply in the selected location when data is accessed
- Input Parameter - Apply a value for a named variable in the selected location when data is accessed
- Input Name - The name of the variable to be replaced in the expression
- Default Value - The initial value to use for the variable in the expression, unless/until the value is overridden by an Action or another process
- Click Apply and observe the SHIM expression that was generated and inserted in the location where you added the expression.
2. SHIM Reference
A reference guide listing many available SHIM functions is available on the SHIM reference page.