Hello,
Information:
I Have a Database called Users where all the users and their info is stored.
Each solution uses information on users from that database.
I have made another database called Helpdesk with a number of tables. When I want to show users information I store the Users Id in the current table.
Problem:
When I want to sort on a field called assigned_to (containing usersid`s but showing Initials) through a method I cannot choose the relation in the “sort chooser” in fact no relation is shown with a destination out of the current database.
To enter the relation yourself doesn`t work either.
controller.sort('assigned_to_to_usersid.initials asc')
Is there a way to sort on fields not in the current server.
Thanks in advance,
With kind regards Rene.