A Question for Filtering Record Data

Question

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?

Harshit Bumb (Appyzie) · Answer

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)
)

Qiwei Ye · Answer

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) )

A Question for Filtering Record Data

Top Replies