Why is it that my rule: rule!esc_get_EI_data_by_date_range(todatetime(ri!st

mikek579 over 10 years ago

Why is it that my rule:
rule!esc_get_EI_data_by_date_range(todatetime(ri!start),todatetime(ri!end),topaginginfo(1,100)) returns 100 rows of data for ri!start=10/01/2014,ri!end=10/31/2014 [ri!start & ri!end are both date types],
And
my input task output rule: rule!esc_get_EI_data_by_date_range(todatetime(ac!startDate),todatetime(ac!endDate),topaginginfo(1,100)) returns nothing for ac!startDate=10/31/2014, ac!endDate=10/31/2014, [ac!startDate & ac!endDate are both date types]?
...

Discussion posts and replies are publicly visible

Parents

0 mikek579 over 10 years ago

Success! I added pagininginfo to limit my results. Then I just added a .data segment to my expression
{rule!esc_get_EI_data_by_date_range(todate(pv!startDate),todate(pv!endDate),topaginginfo(1,1555)).data}
which was not necessary in my stand-alone test, but caused the rule to return data!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mikek579 over 10 years ago

Success! I added pagininginfo to limit my results. Then I just added a .data segment to my expression
{rule!esc_get_EI_data_by_date_range(todate(pv!startDate),todate(pv!endDate),topaginginfo(1,1555)).data}
which was not necessary in my stand-alone test, but caused the rule to return data!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data