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
If your values are semicolon separated names, this becomes complicated. Searching for "Alex;" would only work as long as that name is not at the end.
Is this a one-to-many relationship? If you put the names in a separate record, your task would be simple.
Indeed, it is a one-to-many relationship, but I can't change the data structure.