Question
Hoverstate
SV
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?
Something like:
.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.
Thanks in advance!
***Moderator Edit: Vidyaranjan | Updated Categories***
Accepted Solution
Services Australia
AU
Generated sql query for above RD is
SELECT "PC0"."PYSTATUSWORK" AS "pyStatusWork" , "PC0"."PYID" AS "pyID" , "PC0"."PZINSKEY" AS "pzInsKey" FROM DATA.pc_work "PC0" WHERE ( "PC0"."PYSTATUSWORK" IN (? , ? ) )
Hope this helps
Vamshi
Services Australia
AU
Hi Fernando
Have you tried this
-
For Obj-Browse, add two rows, A and B and enter your criteria .pyStatusWork (or CaseStatus as per your example) is equal to “Resolved-Paid” and for another row set it “Resolved-Denied”
-
In the logic field enter A OR B
Hope this helps
Hoverstate
SV
Hi!
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?
Services Australia
AU
Hi Fernand
Hi Fernando,
For the question you have we need to have the generated sql query with IN clause not equals, as follows
"SELECT "PYSTATUSWORK" AS "pyStatusWork", "PZINSKEY" as "pxInsHandle" from DATA.pc_work WHERE "PXOBJCLASS" LIKE ? AND ( ( "PYSTATUSWORK" IN (?,?) )"
I am not sure if there is a provision with OBJ-BROWSE to do that. Have you tried replaacing OBJ-BROWSE with Report definition?
Report definition has that capability, when you select pyStatusWork in Filter Conditions like
Vamshi
Accepted Solution
Services Australia
AU
Generated sql query for above RD is
SELECT "PC0"."PYSTATUSWORK" AS "pyStatusWork" , "PC0"."PYID" AS "pyID" , "PC0"."PZINSKEY" AS "pzInsKey" FROM DATA.pc_work "PC0" WHERE ( "PC0"."PYSTATUSWORK" IN (? , ? ) )
Hope this helps
Vamshi
Hoverstate
SV
Hello!
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.
Services Australia
AU
The resultant sql query generated by pega would be
SELECT "PYSTATUSWORK" AS "pyStatusWork", "PZINSKEY" as "pxInsHandle" from DATA.pc_work
WHERE "PXOBJCLASS" LIKE ? AND ( ( "PYSTATUSWORK" = ? ) OR ( "PYSTATUSWORK" = ? ) )
The resultant sql query generated by pega would be
SELECT "PYSTATUSWORK" AS "pyStatusWork", "PZINSKEY" as "pxInsHandle" from DATA.pc_work
WHERE "PXOBJCLASS" LIKE ? AND ( ( "PYSTATUSWORK" = ? ) OR ( "PYSTATUSWORK" = ? ) )
Hope this helps
Vamshi