ViewsConditionsAny
Query Views Conditions with Logical OR.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the connector.SELECT * FROM ViewsConditionsAny SELECT * FROM ViewsConditionsAny WHERE ViewId = '18521247306513'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
Columns
Name | Type | References | Description |
ViewId [KEY] | Long | View id. | |
Active | Boolean | Useful for determining if the view should be displayed. | |
Access | String | Only views with given access. May be personal, shared, or account | |
GroupId | Long | The group id the view belongs to. Used to query the table | |
Field | String | The name of a ticket field. | |
Operator | String | A comparison operator. | |
Value | String | The value of a ticket field. |