topic Re: Need help with the Filter on Collection where I need the Collection column to be on the right in Product Forum

Need help with the Filter on Collection where I need the Collection column to be on the right

Tak.Kwok — Thu, 07 Aug 2025 19:53:49 GMT

Hi:

Need help with the Filter on Collection where I need the Collection column to be on the right (Normal is for the column name to be on the left hand side). For example: Collection is call Keywords and the column needed to be search if it contains the string is named Keywords ( I needed to have it that says something like "Folder Name" Like '*keywords*'. I tried the attached screen shot but it was giving me an error msg: Could not execute code stage because exception thrown by code stage: Cannot interpret token '"' at position 28. I know you can loop through the collection to do an Instring but that will take a long time to loop through. So was hoping to use filter as it will be faster. Appreciate if anyone is able to let me know if the filter collecton will work in this case.

Re: Need help with the Filter on Collection where I need the Collection column to be on the right

SayeedBinAbdullah — Sat, 09 Aug 2025 04:01:22 GMT

Hi @Tak.Kwok

Can you also share the screenshot of collection?

Best Regards,
Sayeed Bin Abdullah

Re: Need help with the Filter on Collection where I need the Collection column to be on the right

SouravSaha — Mon, 11 Aug 2025 11:15:41 GMT

Hi @Tak.Kwok,

Could you please try the following expression in the Filter property: "[Last Folder] like '%" &[Keywords2.Keywords]& "%'"

If it doesn't work, please share the screenshots and more details as mentioned by Sayeed above.

Re: Need help with the Filter on Collection where I need the Collection column to be on the right

naveed_raza — Fri, 28 Nov 2025 14:39:02 GMT

it should be like this

if you are passing header value dynamically then
"[" & [Last Folder] & "] Like '*" & [Keywords2.Keywords] & "*'"

if your header name is stacking as Last Folder then

"[Last Folder] Like '*" & [Keywords2.Keywords] & "*'"