| Table Name: | query_elm |
| Table Number: | 204 |
| Group: | Info Retrieval |
| Description: | EIS object which stores property list line items for case, subcase, change request, solution and RMA queries |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| addnl_info | CHAR | varchar | 255 | ALLOW_NULL | Additional information about query | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| field_name | CHAR | varchar | 80 | Field name in object for property being used in query | ||||
| field_value | CHAR | varchar | 255 | Value to compare property against; could be entered or selected from a list | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| oper_id | LONG | int | DIRECT | Code number for type of operation; e.g., equal to, contains, starts with, is in, etc. used to query | ||||
| oper_name | CHAR | varchar | 25 | Name for type of operation used to query; e.g., 'equal to', 'contains', 'starts with', 'is in', etc | ||||
| path_name | CHAR | varchar | 255 | Stores relation path to object property used in the line item | ||||
| prompt_ind | LONG | tinyint | DIRECT | Indicates whether the query element is prompted for at run-time; i.e., 0=not prompted, 1=prompted, default=0 | ||||
| prompt_ind_st | CHAR | varchar | 20 | Translates prompt_ind |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| query_elm2filterset | MTO | filterset | filterset2query_elm | Filterset using the property | |||
| query_elm2query | MTO | query | query2query_elm | Relation to the query; appears on Query Edit forms in query property list field array | |||
| query_elm2web_filter | MTO | web_filter | web_filter2query_elm | Web_filter using the property | |||
| query_elm2xfilterset | MTO | xfilterset | xfilterset2query_elm | Filterset using the property |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| query_elm | |||