topic RE: Error in Filter Collection in Digital Exchange

Error in Filter Collection

sarthak_86 — Sat, 29 Feb 2020 12:23:00 GMT

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

RE: Error in Filter Collection

ArjunMohan_Varm — Mon, 02 Mar 2020 00:45:00 GMT

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

This should work correctly.

RE: Error in Filter Collection

sarthak_86 — Mon, 02 Mar 2020 02:54:00 GMT

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

RE: Error in Filter Collection

GauravDhiman — Mon, 02 Mar 2020 06:02:00 GMT

Hi Mate,

I am not on system right now but use of -Replace function in string should work.

Regards

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

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

This should work correctly.

RE: Error in Filter Collection

sarthak_86 — Mon, 02 Mar 2020 06:15:00 GMT

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

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

RE: Error in Filter Collection

lookman — Mon, 02 Mar 2020 20:16:00 GMT

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

RE: Error in Filter Collection

sarthak_86 — Tue, 03 Mar 2020 04:33:00 GMT

Thanks, Jack, this will help me.

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