Solved How to use Filter collection(Utility - collection manipulation)

khalsa96

New Member
i need to filter the column nature as Booked and Last Year,used utility -collection manipulation in the input filter AND operation doesn't work as it is text data type

"[Nature] = 'Booked' AND [Nature]= 'Last Year Transcation' "
You should use OR instead of AND. If you use AND you are querying a column that should be Booked AND Last Year Transaction AT THE SAME TIME. That won't be possible. Hope it helps :)
 
i need to filter the column nature as Booked and Last Year,used utility -collection manipulation in the input filter AND operation doesn't work as it is text data type

"[Nature] = 'Booked' AND [Nature]= 'Last Year Transcation' "
Please try without any space. "[Nature]= 'Booked' AND [Nature]= 'Last Year Transcation'"
 
Top