CiviCRM Community Forums (archive)

Hi,

I created a custom search to create mailing labels. The search works fine but i cannot get the list sorted as i want. The list should be sorted to distribution code and postal code to make post-processing a bit easier.

The result fields are:

• Contact ID
• First Name
• Last Name
• Street Address
• Postal Code
• City
• Distribution Code (custom field tied to membership)

The sql statement has an order by clause to sort on distribution code and postal code (which works fine when you run it against the database). In the Custom Search result screen however, the records seem to be sorted by contact ID.

Any ideas to get the sorting right?

Thanks

Hi Lobo,

The contactIDs function is implemented, it calls the all() function with the justIds flag set.  Running the sql statement that is composed in all() with justIds set separately against the database gives me the ids in the right order. So the queries seem right.

It seems like the sorting option on the columns overrule the default sorting order i defined.  Is there an option to disable sorting through the UI (apart from taking it out the template which i tried to no avail).

Thanks