Posted: 3 Jun 2015 11:03 EDT Last activity: 24 Jun 2015 6:24 EDT
Unable to pass ValueList to Obj-Browse method
I want to give a set of values to a condition like "IN" in SQL . Example: pyStatusWork ISEQUAL ("Pending",ReSolved","Open") ,This is working in Report Definition but its not working in oj-browse . In Obj-Browse its taking first value only . can we able to implement like this ? i am expecting Query Condition from the Obj-Browse need to be SELECT * FROM PC_WORK WHERE pyStatusWortk IN ("Pending",ReSolved","Open")
pystatusWork value would be dynamic.so i can't frame the multiple conditions.
Share this page
Moderation Team has archived post,
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 6 years ago
Posted: 3 Jun 2015 19:31 EDT
Jeremy Peterson (PegaThoughts)
Lead System Architect - Pega Consulting
I left out a part, to make it dynamic (sort of), I passed in parameters for the values to sort against. While this is not the most elegant solution, there is a finite number of statuses in the system which allows this to work.
Thanks for your reply on this. Currently i'm using pega 7.1.6 version.
I just mentioned the example on pyStatusWork ,But In Obj-Browse method we need to define the condtion to check mulitple list values on column(like IN condition in SQL) ,and list of values are not finite.
we are able to achieve this by using Report definition,but need to go for new rule creation .
Yes we can use report defintion to browse the results if the requestor is authenticated , but we need to load the results in Service Requestor context which is not authenticated .
In last year we had raised a SR(SR-120196) with support team regarding this ,and they suggested us to use obj-browse/RDB-List/List View to browse the results in case of requestor is not authenticated .