| Table Name: | filterset |
| Table Number: | 425 |
| Group: | Info Retrieval |
| Description: | Object which stores the definition of a filter as defined by a user |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| id1 | LONG | int | DIRECT | ID of the form to which the filterset belongs | ||||
| id2 | CHAR | varchar | 30 | Identifies the functionality using the filterset | ||||
| is_default | CHAR | varchar | 20 | If the default filterset, set to string representing 'default', else blank | ||||
| obj_type | LONG | int | DIRECT | Object type ID base object the filterset is for; e.g., 0=case, 52=site | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| order_val | LONG | int | DIRECT | 0=Ascending , 1=descending sort criteria | ||||
| sql_statement | CHAR | text | ALLOW_NULL | SQL code created based on parameters entered by user for the filterset | ||||
| stored_prc_name | CHAR | varchar | 40 | Reserved for the name of the stored procedure for the filterset | ||||
| title | CHAR | varchar | 80 | Name of the filterset | ||||
| type | CHAR | varchar | 30 | Function that is using the filterset; e.g., CBX | ||||
| update_stamp | CLK_TIME | datetime | 46 | ALLOW_NULL | Date/time of last update to the filterset | |||
| view_type | LONG | int | DIRECT | Schema view being used for filterset; differs based on object type |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| filterset2query_elm | OTM | query_elm | query_elm2filterset | Property list items for the filterset | |||
| filterset2sort_elm | OTM | sort_elm | sort_elm2filterset | Sort criteria for the filterset | |||
| include2territory | OTOF | territory | include2filterset | Territory for which the filterset selects business organizations. Reserved; future | |||
| filterset2user | MTO | user | originator2filterset | User that originated/created filterset |
| Index Name | Fields | Flags |
|---|---|---|
| filter_name_ind | filterset2user:type:id1:id2:title | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| filter_name_ind | filterset2user, type, id1, id2, title | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| filterset | |||