Sort a report inserted in an exact form after being grouped.

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
I have a report inserted in an exact form which is grouped by the field [index][11]. But once it is grouped, I need it sorted by the date [filed][13]. The grouping works [11], but the subsequent sort of the grouped items [13] does not. Help!

~=qdb.GetURL("bmm6tc3xp",
"API_GenResultsTable^query={'14'.EX.'"+ field["Record
ID#"]+"'}^clist=7.8.9.13.10^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=11.sortorder-A^slist=13^ts="+
new Date().getTime());~
Photo of bgstatdex

bgstatdex

  • 270 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Keith

Keith, Champion

  • 940 Points 500 badge 2x thumb
try adding 13 to your slist
slist=11.13
then add either A or D to the sortorder A-ascending D-descending
sortorder-AA
Photo of Keith

Keith, Champion

  • 940 Points 500 badge 2x thumb
and when you want more advanced grouping capabilities try this using Exact Forms Plus
https://juicedtech.quickbase.com/db/b...
just click the EF+ Grouping tab and then try the 3 buttons to see some ways to group
Photo of bgstatdex

bgstatdex

  • 270 Points 250 badge 2x thumb
Thanks.  It worked.