Custom search - cannot get sorting right

[cray146]

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

[Donald Lobo]

Have u implemented the contactIDs function in your custom search and ensure that the contactIDs returned there are in the order you want the mailing labels printed?

lobo

[cray146]

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