CiviCRM Community Forums (archive)

Hi - what sort of jiggery-pokery is required to make Batch Update screen allow us to sort by the columns? This use case is for Participants - rather than from AdvSearch if that makes a difference.

Purpose being, in this example, so that the 'team name' is delivered as a searchable column for an event, as the process being undertaken through the batch update for other columns/data is best performed if we can return the results sorted by Team.

Do we need to force the column in to the Participants Search Results and then force the sort from that to be applied in Batch Update - or is there something we can apply direct to the Batch Update configuration?

alternatively might be time for us to consider doing a "search query hook" where we invoke a hook with all the relevant sql pieces (select, from, where, limit, order by, group) so a module can modify things in a more non-hackish manner

Have run up against this again - same client - trying to find a work around fact that we can't currently import the data for Participants http://issues.civicrm.org/jira/browse/CRM-4815
So I may be able to put some time in to either of the above options, ie our hack or your 'search query hook' - where would our efforts be best placed for an outcome within the next couple of weeks (the hack I presume) - and if the latter can you provide any pointers on where we start to 'force' the column sorting behaviour?