Hi Team,
Request your help for the Collections in CUIC . My requirement was to pull Campaign names based on the Campaign Group. For Ex if the Campaign Group Team1 has the Campaign S1,S2,S3, by creating the Collection name Team the User by selecting the Collection Team the respective campign should automatically populate. The below is the Collection query I have created under the Value list.
select distinct CAMPAIGNID as id , CAMPAIGNID as Value
from campaign (nolock)
where CAMPAIGNGROUP = <COLLECTIONIDENTIFIER>
Note: Don't use Values in the Collection as option as in the future the customer may add more campaign in the future. I want an auto update with the help of Wildcard or Identifier.
Thanks in Advance,
Bala,Raja