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.
I'm having a little bit of trouble understanding what exactly you are trying to do with this collection query. Is CAMPAIGNGROUP a field you have in the Campaign table or is it in a different table? If it is in the Campaign table, what issues are you specifically having with this Collection Query?