Filter Collection can filter Dynamic Text if yes how?

[PrasanthChiruku]

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

[SrikanthReddy2]

Scenario-1 
Use Like Operator

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

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






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

[VivekGoel]

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

[AMITJAGTAP1]

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

[PrasanthChiruku]

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