cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
689
Views
0
Helpful
1
Replies

Collection in CUIC

Rajbala_2010
Beginner
Beginner

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

1 Reply 1

richapar
Beginner
Beginner

Raja,

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?

Regards,

Richard Parker

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers