RepoSetupsQueryItems, 62 (ver3.6.1)
Specific Items specified for the queries in ReportSetupQueries table.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Comparator | 3.6.1 | Number(10,0) | Indicates whether the items in a criteria are to compare via equal, not equal, greater than, less than. |
Conjunction | 3.6.1 | Number(10,0) | Indicates whether the criteria being used is to added together with an AND or an OR. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Field_Number | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Formula_And_Or_Parameters | 3.6.1 | CLOB | Formula to be used for the query in Code format. |
Formula_And_Or_Parameters_ | 3.6.1 | CLOB | Similar to Formula_and _Parameters but a space is added to ~ wherever encountered so it displays correctly. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Order_Index | 3.6.1 | Number(10,0) | The number provided to this item for referencing purposes. |
QueryID | 3.6.1 | Number(10,0) | The internal number for the parent RepoSetupsQuery with which this record is associated. Indexed. |
Table_Number | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |
Value_Type | 3.6.1 | Number(10,0) | Datatype of the Variable to be used: 1=Integer, 2=Real, 3=Text, 4=Date, 5=Boolean, 6=Time, 7= Undefined. |
Value_As_String | 3.6.1 | CLOB | Actual value to be used for comparison with the field or variable. This could be a tag also. |