PDA

View Full Version : sort by multiple columns --


raymond
January 25th, 2011, 11:31 AM
how can we sort by multiple columns? I need to see my tickets by priority then due date... I've tried setting up filters but this is both klunky and simply doesn't work. would be nice if we could simply click a colum then maybe the ctrl or alt key and another column which would sub-sort...

thanks --

//ray

Support Team
January 25th, 2011, 11:44 AM
Thank you for posting this. When you right click the Tickets list you'll see many different sorting options that combine more than one field.
In case the sorting option you need is not there click the Filter checkbox and open to filtering window - at the bottom you'll have the option to select up to three sort fields.

Hope this helps.
Dina

raymond
January 26th, 2011, 03:42 PM
that'll do it! I tried using filters but was unsuccessful in getting them to save... seems like that is working now as well.

//ray

raymond
January 26th, 2011, 03:56 PM
why can't we sort on description? this would be so very helpful when looking for stuff.

thanks!

//ray

Support Team
January 27th, 2011, 06:09 AM
Description is a Memo database field. Memo fields can hold an [almost] unlimited amount of text, however, they are not designed for sorting as its almost impossible and very not efficient to sort by a field with an unlimited text. You can filter the list by searching for text within the Description so it should allow you to easily find the Tickets you're looking for.

Thanks,
Dina

raymond
January 27th, 2011, 12:53 PM
How about sort on the first 120 characters or something like that. We start a lot of our descriptions with a coding like "REC - Monthly..." for recurring events or "Misc." for charges that don't require a full blown dedicated ticket... would be really nice to simply order on the description (at least the first 120 characters or so). Yes, we could customize and use another field (like Category) but that requires all internal users to be diligent and never forget to fill in this field (which is another one of my questions, can we mark fields in Accounts and/or Tickets as required fields).

thanks again!

//ray

Support Team
January 27th, 2011, 01:08 PM
I'll forward this idea to our dev team. Thanks. As to your question - the answer is currently not (I think I posted it on another thread earlier today).

Thanks,
Dina