Posted: 22 May 2017 23:52 EDT Last activity: 12 Jun 2017 9:25 EDT
Looking for an alternative to using "Contains" in the condition of an Obj-Browse
Hey everyone, as you can see in the attached image, I'll give a little bit of context first.
I have 2 CaseStatus values, "Resolved-Paid" and "Resolved-Denied", as it is right now only those 2 status values can have the "Resolved" word in it, so my obj-browse condition works well only with a Contains "Resolved". The thing is that, in future requirements there COULD be more "Resolved" statuses that won't be part of my whole condition.
So my question is, is there a way to do something like the 2nd row on the image I attached?
.CaseStatus is equal "Resolved-Paid" OR "Resolved-Denied".
If I try to insert those values, I get an error so I'm wondering if there's a way to do this or if it's just not possible to do in a single "is equal" line.
This is actually another solution that I had but my question is related to your answer, is it possible to do something like that on a single line using the "Is equal" condition? Or do I mandatory need to use 2 separate conditions for that?
The default obj-browse query isn't using an "IN" so I can't do it that way :(
I was going for something similar on my value using this expression on the value field of the obj-browse condition that I posted first:
''Resolved-Paid' OR STATUS= 'Resolved-Denied')'
That actually works on SQL and it fits perfectly on the PEGA query that's used (since it already places the first "STATUS=" on the WHERE clause), but in PEGA it gives this error because I used an "=" symbol on the value so I'm not sure if it would actually be possible to do it this way...
All I can think of now is that if there's a way to escape a special character? That way I could use the "=" in the value and I'm pretty sure that it would work.