Differing in count values when condition from script loader is moved to front end.

[berryandcherry6]

Hi all,

I am trying to get counts of course completed value, whose campaign  starts in previous week  , final_test_status is passed and DateType = invitation.

I am getting correct value counts,when condition is put in script and passed those datas in front end.

But when i try putting all condition in front end i.e comparing last week dates to get campaign id , i get wrong count .

Please help me on this i have attached qvf file and i have to achieve this by putting condition in front end itself.

Regards,

[brijeshvma]

Hi,

Your qvf is showing internal error ..

can you share another one.. Either can you confirm what the script are you using in script editor and expression

[berryandcherry6]

Hi,

Thanks for your reply

In script

  LOAD `campaign_id` as  campaignid,

`batch_meta_data_id`,

    date(floor(start_date),'MM-DD-YYYY') as current_start_date,

    `expiration_date`;

SQL SELECT

`batch_meta_data_id`,

`campaign_id`,

`start_date`,

`expiration_date`

FROM CAMPAIGN;

CurrentCampaignData:

Load

batch_meta_data_id,

campaignid as current_campaign_id

Resident CAMPAIGN

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

and to get count i use in front end this,

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

For above i get correct value, but instead of all this scripting of condition in loader ,if i directly place condition in front end i get wrong count

Used code in front end is

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

for this i get wrong count.

[brijeshvma]

Hi,

Can u share Qvd for the same data.. and what the count are getting in Script and Expression

[berryandcherry6]

HI Brijesh ,

Please check the new attached qvf file.

i think you are loading data in script ,please dont load data over in script

[brijeshvma]

Hi Supriya

Sry, i am downloading the same.. But its give the same error..