Values not getting displayed in textbox

[berryandcherry6]

Hi all,

I am trying to get  current_campaign_id  based on batch_meta_data_id  and current_start_date.But here i am not able to get anyvalues when i put this expression inside textbox.

current_campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})

even i tried on this

Concat({current_campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})

>} current_campaign_id, ', ')

but no luck

Please help me on this.

Thanks,

Supriya

[sunny_talwar]

Can you put in words your requirement?

[berryandcherry6]

Hi,

i want to get counts where final_test_status = passed and campaign_id = 102, 103, 104 and 105.    (local db id ,in server db id differs)

i have alreay used below code to get count,Its working fine and getting correct count=13,but i am loading this in script. (server db)

CurrentCampaignData:

Load

batch_meta_data_id,

campaignid as current_campaign_id

Resident CAMPAIGN

WHERE (current_start_date = Date(weekstart(Num(today()))+1)) and match(batch_meta_data_id ,'23','24');

count({$<final_test_status={'passed'},campaign_id = P(current_campaign_id)>} invitation_id)

i am getting correct count.(count = 13,server db count value)

But i want to use this logic in expresion ,so there wont be any need to create multiple table to get campaignid for every camapaign in script.

Please help me on this.

Regards,

Supriya

[sunny_talwar]

Can you check this:

Count({$<final_test_status={'passed'}, campaignid = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})>} course_completed)

[berryandcherry6]

Hi,

I checked this,its giving me 2886 as count.

If i hard code camapign_id i get 13 as answer and i changed campaignid  to  campaign_id.(i removed alternate name i.e campaignid  given to campaign_id since it was confusing)

Count({$< final_test_status={'passed'},

campaign_id ={'350','351','352','353'}>} course_completed)   =  13 <ids differers as in server db  >

350','351','352','353 ids i got is through below express

Concat(DISTINCT {<campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(today()) + 1, 'MM-DD-YYYY'))"}>})

>} campaign_id, ', ')

Regards,

Supriya