topic Filter collection based on specific value using (Data Item) in Product Forum

Filter collection based on specific value using (Data Item)

LorenzoCapocci1 — Thu, 30 Sep 2021 12:16:48 GMT

Hi Team,

Currently I am using a regular collection filtering using a loop stage but this is taking to long to go trough a list of 500 rows or more...
I was trying to use the collection filter, but, I need to use data item ( as value read as it changes for each page run,,,,) but I wasn't able to make work....

basically in document attached it is the current actions I am taking

Anything that doesn't match the value read in that moment should be just gone from collection list....

Is it possible to add Data (value read) in the Utility collection manipulation (Filter) so it allows to do this action at once, or do you have better solution to save time?
Thank you
This basically the start of the action to this loop

Re: Filter collection based on specific value using (Data Item)

NicholasHobbs — Thu, 30 Sep 2021 13:08:50 GMT

Hi Lorenzo,

I think you can just use the Filter Collection action in the Utility - Collection Manupulation VBO.
The inputs are as followed:
Collection In: [collection name]
Filter: "colname = '"&[value]&"'" (you need single quotes around the data item [value])
where colname is the column in the collection you want to filter on.

Re: Filter collection based on specific value using (Data Item)

LorenzoCapocci1 — Thu, 30 Sep 2021 13:53:22 GMT

Hi @NicholasHobbs,
Thank you for helping out, but could I ask to review the value please
This is what I have based on my collection ( added a screen shot of current view for data item current value and note...)
Column Name = EC-Level (OrdSup)
Data Item = [Value Read]

"EC-Level (OrdSup)= '"&[Value Read]&' "

I have tried to review the " but Still getting this error, can you help again, please.. thank you

Re: Filter collection based on specific value using (Data Item)

NicholasHobbs — Thu, 30 Sep 2021 13:59:27 GMT

Hi Lorenzo,

You need a double quote before the single quote at then end.

You have "EC-Level (OrdSup)= '"&[Value Read]&' "
It should be "EC-Level (OrdSup)= '"&[Value Read]&"' "

Re: Filter collection based on specific value using (Data Item)

LorenzoCapocci1 — Thu, 30 Sep 2021 14:04:20 GMT

Hi @NicholasHobbs
I just copied "EC-Level (OrdSup)= '"&[Value Read]&"' "

and seems it is not liking the bracket I have in this , but this is what I have from the file and I can't remove from the original report, or maybe is there something else I am doing wrong? thank you very much once again

Internal : Could not execute code stage because exception thrown by code stage: The expression contains undefined function call Level().

Re: Filter collection based on specific value using (Data Item)

NicholasHobbs — Thu, 30 Sep 2021 14:14:33 GMT

@LorenzoCapocci1

You will also get an error with the column name because it has a space and () in.

I think you can put square brackets around the colname to fix this.
"[EC-Level (OrdSup)]= '"&[Value Read]&"'"

I forgot about this in my previous answer.

Re: Filter collection based on specific value using (Data Item)

LorenzoCapocci1 — Thu, 30 Sep 2021 14:21:16 GMT

Thank you @NicholasHobbs it worked perfectly, thank you so much for your help and time to get this sorted so quickly, I really appreciate!