Field 'title' does not exist for object 'boards' as a sort constraint
I have tried to get an ordered list of our knowledge base boards with "SELECT id, title FROM boards WHERE root_category.id='knowledgebase' order by title", but I receive the error in the subject line. If I remove "order by title" I get a list of five boards (Yay) but not in alphabetical order (Grr).
Who doesn't want to sort things by title (alphabetically) for crying out loud? Why can't I do this? This is the weirdest constraint I have ever heard of. I've been working with databases for more than 30 years and never encountered such a limitation.
Does anyone have a work-around because this is REALLY annoying!?
Thanks in advance ...
Paul
PAULEM - This is something which is currently not supported in LIQL.
Here is the documentation https://lithosphere.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=boardsHowever, this still can be achieved using freemarker sort_by method. This thread might be useful.
Sort by documentation below.
https://freemarker.apache.org/docs/ref_builtins_sequence.html#ref_builtin_sort_by