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.
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 .