I want to change the query used for a Text List:
currently the query is:
(«_liveSearch» = “”) or (exportcell(«Name») contains «_liveSearch»)
I want the records retrieved to meet these criteria PLUS I want to only show records where exportcell(«Active») does not contain “Inactive”
I have no idea what the appropriate syntax would be for this, or if this is even possible.
any help would be appreciated.