Query Views Conditions with Logical AND.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM ViewsConditionsAll
SELECT * FROM ViewsConditionsAll 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.