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.

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.

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.

You do know you can call a Report Definition from an activity so there's no need for an obj-browse, right? pxRetrieveReportData activity.

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  .