Question2Replies340Views SmithaR1 Member since 2016 27 posts Nielsen Posted: 3 years agoLast activity: 3 years 10 months ago Closed Solved Use "In" condition to retrieve data Hi , I have a list of User ID's stored in Code-Pega-List. These were retrieved from the Pega DB using a couple of Obj-Browse. Now I need to query another table to get all the Vendors associated with these Users. That means I need to get something like : Select * from Second_Pega_table PT where PT.USER_ID in (a list of values). How do I achieve this in Pega ? Thanks,Smitha R Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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 Question, please write a new Question. Accepted Solution Posted: 3 years agorawap PEGA replied to SmithaR1You can use report definition to achieve the same. Use equals condition in report definition's filter. Left hand side : UserID Right hand side of condition : a value list property which will have all the values OR comma separated user ids ("UserA","UserB","UserC") Both of these will result in IN clause. Let us know if you need more information Posted: 3 years agoSmithaR1 Nielsen replied to rawap Thank you , I was able to make it work.