Author Topic: Is a user-selectable ORDER BY filter possible? (Read 631 times)

CiviTeacher.com · January 03, 2011, 06:41:56 pm

Is there a way to set ORDER BY clause in the user's filter interface? Is there an existing report that has this functionality? Maybe I missed it, but I couldn't find one.

I can hardcode an ORDER BY in function groupBy( ) , I get that much, but I want to have several different ORDER BY options and have the user select the one they want.

Possible? Thanks.

demeritcowboy · January 03, 2011, 08:08:11 pm

I think I looked into this once and I didn't see it either. I ended up hijacking groupBy and using the selected groupings for ordering instead, but yes there's no way to get the user to specify the primary vs secondary etc ordering. There isn't with grouping either really.

There's also this, in case you didn't already see it.
http://forum.civicrm.org/index.php/topic,15272.0.html

It's awkward, but what you might be able to do is set up the fake grouping options to be the combined ordering and use that in groupBy, e.g.

Checkbox 1: Order by date, name, city
Checkbox 2: Order by date, city, name
Checkbox 3: Order by name, city, date
etc.

CiviCRM Community Forums (archive)

News:

Author Topic: Is a user-selectable ORDER BY filter possible? (Read 631 times)

CiviTeacher.com

Is a user-selectable ORDER BY filter possible?

demeritcowboy

Re: Is a user-selectable ORDER BY filter possible?