Hello,
I would like to display all tickets sort by customer.
I have the main table ticket and several specific tables (15, (FNC1,FNC2....)) per subject.
What is the OQL syntax to display a list of all opened ticket sort by customers in the support interface.
Should I use an UNION SELECT with the 15 tables or some other kind of request.
After testing it seems that this is not possible with JOIN.
Thanks for your answer
Thierry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Thierry,
I will suppose that the "support interface" is not the User Portal, so it's the Console (internally it's a specific portal with id="backoffice"), also that supposition has no impact on the answer.
There is currently no mean to propose a "SearchMenuNode" which would be ordered differently than any search of that given class.
Each user, can set an order on any "named" list (stored in his preferences), by the mean of the action "configure this list", but you cannot force it in the data model.
On a particular class, in your case Ticket, you can set in XML an order which will apply on all list of that class, for which the user has not overwritten the order through his preferences .
Without that definition, the friendlyname in increasing alphabetic order is used by default.
A UNION of 15 child classes will return a list of the first common parent class, so Ticket probably in your case.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I would like to display all tickets sort by customer.
I have the main table ticket and several specific tables (15, (FNC1,FNC2....)) per subject.
What is the OQL syntax to display a list of all opened ticket sort by customers in the support interface.
Should I use an UNION SELECT with the 15 tables or some other kind of request.
After testing it seems that this is not possible with JOIN.
Thanks for your answer
Thierry
Hi Thierry,
I will suppose that the "support interface" is not the User Portal, so it's the Console (internally it's a specific portal with id="backoffice"), also that supposition has no impact on the answer.
There is currently no mean to propose a "SearchMenuNode" which would be ordered differently than any search of that given class.
Each user, can set an order on any "named" list (stored in his preferences), by the mean of the action "configure this list", but you cannot force it in the data model.
On a particular class, in your case Ticket, you can set in XML an order which will apply on all list of that class, for which the user has not overwritten the order through his preferences .
Without that definition, the friendlyname in increasing alphabetic order is used by default.
A UNION of 15 child classes will return a list of the first common parent class, so Ticket probably in your case.
Hello Vincent,
Thanks a lot for your answer.