cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Filter Collection

sarthak_86
Level 5

In filter collection, when I am using the value directly it is working correctly but when I am using the data items, it's not working, maybe because of the syntax. 

I have found the syntax from forums, but it is not working for me.

" [Item Text] like '*(MAN)*' "  - This works correctly.

I want to use the value from a data item X in place of 'MAN' and also want to use the '*' operator for matching data.
What will be the correct syntax for using it?



------------------------------
Sarthak Dhasmana
------------------------------
6 REPLIES 6

ArjunMohan_Varm
Level 2
"[Item Text] like '*" &[X]& "*'" 

This should work correctly.



Thanks a lot, It worked.

Correct me if I am wrong, whenever we have to use Data Items we have to enclose it between "& &" . 



------------------------------
Sarthak Dhasmana
------------------------------

Hi Mate,
I am not on system right now but use of -Replace function in string should work.
Regards
G


------Original Message------

"[Item Text] like '*" &[X]& "*'" 

This should work correctly.



Gaurav Dhiman RPA developer,ROM Architect Melbourne,VIC,Australia 0413 930 960

Thanks, Gaurav, "[Item Text] like '*" &[X]& "*'"  this one worked for me.

------------------------------
Sarthak Dhasmana
------------------------------

Hi Sarthak,

You may want to take a look at the advanced work queues doc as well to provide you with more information:

https://portal.blueprism.com/system/files/documents/Blue%20Prism%20-%20Advanced%20Work%20Queues%20Guide%20%286.2.1%29%28EN%29_1.pdf

jack


------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

Thanks, Jack, this will help me.

------------------------------
Sarthak Dhasmana
------------------------------