|
This entity is used to create data filters. These data filters are named queries. They are defined using conditions that are rules that outline the date required. As a general rule, the more conditions the smaller the result set is. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the identity of the template query. This is the primary key for the TmplQuery table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores a description about the query. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Shows if it is a distinct option, in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
char(255) |
|
Mandatory |
No |
|
The table list contains the string of how the tables are joined for this query. |
|
|
|