| Table Name: | xfilterset |
| Table Number: | 5467 |
| Group: | Info Retrieval |
| Description: | Object which stores the definition of a filter as defined by a user |
| Flags: | CACHEOBJIDS |
| 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 filterset | Search (1) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| is_default | LONG | int | DIRECT | If the default filterset, set to value - 1 for default, 0 for not | ||||
| is_shared | LONG | tinyint | 0 | DIRECT | Indicates that filterset is shared or personal; i.e., 0=Personal, 1=Shared, default=0 | Search (1) | ||
| name | CHAR | varchar | 80 | Name of the filterset | Search (1) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| 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 |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| xfilterset2query_elm | OTM | query_elm | query_elm2xfilterset | Property list items for the filterset | |||
| xfilterset2sort_elm | OTM | sort_elm | sort_elm2xfilterset | Sort criteria for the filterset | |||
| xfilterset2user | MTO | user | originator2xfilterset | User that originated/created filter | Search (1) | ||
| xfiltersets2xfilter | MTO | xfilter | xfilter2xfilterset | xFilter Object |
| Index Name | Fields | Flags |
|---|---|---|
| I5467 | xfiltersets2xfilter:xfilterset2user:type:name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5467 | xfiltersets2xfilter, xfilterset2user, type, name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| x2u5467 | xfilterset2user, xfiltersets2xfilter | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5705 | xfilterset_user | user, xfilterset |
| xfilterset | |||