Question2Replies360Views×Close popoverSmitha Rajasenan (SmithaR1) Nielsen Nielsen US View ProfileSend Message SmithaR1 Member since 2016 27 posts Nielsen Posted: October 27, 2016Last activity: October 30, 2016Posted: 27 Oct 2016 22:20 EDTLast activity: 30 Oct 2016 0:14 EDT 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: 4 years agoPosted: 28 Oct 2016 8:40 EDT×Close popoverPankaj Rawal (rawap) PEGA Sr Architect, Case Management Pegasystems Inc. IN View ProfileSend Messagerawap 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: 4 years agoPosted: 30 Oct 2016 0:14 EDT×Close popoverSmitha Rajasenan (SmithaR1) Nielsen Nielsen US View ProfileSend MessageSmithaR1 Nielsen replied to rawap Thank you , I was able to make it work.