Hi Appian Guys,
a!queryRecordType( recordType: recordType!SellerTeam, filters: a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "includes". value: "Alex" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) )I want to get teams of including "Alex" only, could anyone give me some good advises?
Discussion posts and replies are publicly visible
a!queryRecordType( recordType: recordType!SellerTeam, filters: a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "includes", value: "Alex;" ), a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "ends with", value: "Alex" ) } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) )
That's great!! but i added two conditions for entire logic.
a!queryRecordType( recordType: recordType!SellerTeam, filters: a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "includes", value: "; Alex;" ), a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "ends with", value: "; Alex" ),
a!queryFilter(field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"operator: "=",value: "Alex"),
a!queryFilter(field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"operator: "starts with",value: "Alex; "), } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500))