topic RE: Filter Collection can filter Dynamic Text if yes how? in Product Forum

Filter Collection can filter Dynamic Text if yes how?

PrasanthChiruku — Mon, 09 Dec 2019 11:02:00 GMT

Hi Team,
Scenario-1
I have a collection in that I need to filter the column name with two Statuses the key fields to filter "Po Raised' And 'Approved'
but im not able to find the best way to filter in a single Syntax.

Scenario-2
If the Approved text can extend like Approved**** how to use wildcards here.

------------------------------
Prasanth Chirukuri
RPA Developer
iOPEX Technologies
Asia/Kolkata
------------------------------

RE: Filter Collection can filter Dynamic Text if yes how?

SrikanthReddy2 — Mon, 09 Dec 2019 13:22:00 GMT

Scenario-1
Use Like Operator

"Field Name Like 'Po Raised' And Field Name Like 'Approved'"

Scenario-2
"Field Name Like 'Approved*'"

------------------------------
Developer
Mphasis
------------------------------

RE: Filter Collection can filter Dynamic Text if yes how?

vivek.kumar.goel — Tue, 10 Dec 2019 03:32:00 GMT

Scenario 1:

"[Field Name] = 'Po Raised' or [Field Name] = 'Approved'"

Scenario 2: Use Like operator

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

RE: Filter Collection can filter Dynamic Text if yes how?

AMITJAGTAP1 — Thu, 12 Dec 2019 05:58:00 GMT

Just small correction to Vivek's answer.

Scenario 1: My collection has two columns named Status1 and Status2.

"[Status1] = 'Po Raised' AND [Status2] = 'Approved'"

Scenario 2:

"[Status1] = 'Po Raised' AND [Status2] Like 'Approved*'"

------------------------------
AMIT JAGTAP
Tech Lead
TechMahindra
Indian/Christmas
------------------------------

RE: Filter Collection can filter Dynamic Text if yes how?

PrasanthChiruku — Sat, 14 Dec 2019 18:14:00 GMT

Thank you Vivek, its working fine. Your incredible person you always support every tough situation.

Thanks a lot.

------------------------------
Prasanth Chirukuri
RPA Developer
iOPEX Technologies
Asia/Kolkata
------------------------------