Question

2
Replies
360
Views
Close popover
Smitha Rajasenan (SmithaR1)
Nielsen

Nielsen
US
SmithaR1 Member since 2016 27 posts
Nielsen
Posted: October 27, 2016
Last activity: October 30, 2016
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
Moderation Team has archived post