Node - repParams
Description
You can control the replacement of the @repparams variable in the Set Filtering Criteria and Report Configuration section of the Report Generation screen.
Attributes
None
Sub node: repParam
Description
Each repParam sub node represents a selectable value of the first drop-down of the Filter section on the Report Generation screen. Commonly this is a column in a database table by which you want to filter.
Attributes
type | Mandatory, you can specify any type that you want, but there are some special types.(These are only effective when the input attribute of the operation sub node is select or multiselect.)
|
langName | This value will be seen in the first drop-down box of the Set Filtering Criteria and Report Configuration section in theReport Generation screen. The language settings are treated in the same way as with the repName attribute of the report node. |
Sub node: operation
Description
One operation sub node represents one selectable value in the second drop-down box in the Set Filtering Criteria and Report Configuration section on the Report Generation screen.
Attributes
operator | This is the actual SQL script what will be the replacement of the @filters variable in the WHERE SQL keyword. It has two variables called @value and @2value. The @value variable will be replaced by the selected value in the third input box of the Set Filtering Criteria and Report Configuration section of the Report Generation screen. The @2value variable is used only when the third input box allows two inputs like intervalbox. More information about this can be found in the description of the input attribute. |
langName | This value will be seen in the second drop-down box of the Set Filtering Criteria and Report Configuration section of the Report Generation screen. The language settings are treated in the same way as with the repName attribute of the report node. |
input | The input type of the third input of the Set Filtering Criteria and Report Configuration section on the Report Generation screen.
|
id | A unique identifier for each operation sub node. This is used when you save your dashboard. Use unique values and numbers only. |
useAposAroundValues | When this attribute is set to 1, then apostrophes will be used around the input values from multiple input boxes (like multitextbox). This is useful when the SQL in the operation attribute needs it. |