Error in Filter Collection

[sarthak_86]

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
------------------------------

[ArjunMohan_Varm]

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

This should work correctly.

[sarthak_86]

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
------------------------------

[GauravDhiman]

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.

[sarthak_86]

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

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

[lookman]

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
------------------------------

[sarthak_86]

Thanks, Jack, this will help me.

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