In reference to postNum=2240677
It would be great if we could reference the 'field:label' value from the editor list display. Currently when you add a "list" field type, any sorting is done on the numerical value - not the label value even though the label is shown.
Also it would be good if we could use leftjoin against the same table more than once, - the ability to add an alias would to the join would doit.
Possible solution would be in the editor for a list type field to another table being able to create an optional custom alias.
E.g. category - list pulldown
List Options - get options from database
Use this field for option values : num
Use this field for option labels : title (alias category_label instead of category:label)
Thanks for the suggestion. Yea, that's definitely something we'd like to do as well. It's a bit tricky because the list values are stored in a number of ways and not just as MySQL columns we can left join against. I think what I'd like to do with the next rewrite of the list view is to have a way to display and sort on joined/related fields or even custom views of data, perhaps specified as a MySQL query.
In any case, a somewhat hacky short-term solution we've used in the past is to create another text field with the label text.
Hope that helps and thanks for the suggestion!
Dave Edis - Senior Developer