Unable to pass ValueList to Obj-Browse method
Hi ,
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.
THanks,
Brahmesh.
Pegasystems Inc.
US
What version of Pega are you in?
If you are in 7, you can just link the data coming in to the activity with a Data Page.
If you are in 6, you could recreate the SQL logic in a List View and use the Obj-List-View method in an activity step to pull in the data.
I wrote a test activity to put the obj-browse through the paces. I was able to get it to work. Are you using the "Logic" row? I just labeled my rows A, B, and C and used the logic A OR B OR C.
Pegasystems Inc.
US
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.
Capgemini
SE
Hi Petej,
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 .
Thanks,
Brahmesh.
Pegasystems Inc.
US
You do know you can call a Report Definition from an activity so there's no need for an obj-browse, right? pxRetrieveReportData activity.
Capgemini
SE
Hi Marik,
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 .