Query UserFields RelationshipFilterAll Filter 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 UserFieldsRelationshipFilterAll
SELECT * FROM UserFieldsRelationshipFilterAll WHERE UserFieldId = '19067693577105'

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
UserFieldId	Long	UserFields.Id	The User field id.
Field	String		The name of a ticket field.
Operator	String		A comparison operator.
Value	String		The value of a ticket field.