I have a table, and it contains a LOT of records. How can I find out how many ro

mikek579 over 10 years ago

I have a table, and it contains a LOT of records. How can I find out how many rows will be returned per some specification like a date range? I'd like to say "Tell me how many rows there are that are in this date range?" without returning those rows, which will cause a data limit to be breached....

Discussion posts and replies are publicly visible

0 Bishnu Panigrahi
Appian Employee
over 10 years ago

Check out Owen's response here: forum.appian.com/.../b-39807

rule!yourQueryRule(pv!dateOne,pv!dateTwo, topaginginfo(1,0)).totalCount
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikek579 over 10 years ago

Bishnu,
Many thanks for pointing that out! Worked like magic. And many thanks to Owen!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel