I have a question and maybe it is possible to get this information from the API. Since a few weeks we use Zammad (before we used OTRS). I created a Interface for TV with all tasks and detailed informations. It contains informations like Organization from the customer (or customer email if no organization), the title from ticket and other informations like priority and many more. This list is refresh every 15 seconds with AJAX. I can get all this informations from the API and that’s about 100 entries I got back from the API, so it tooks about 10 seconds to load.
Now I have to integrated a field from the organizations what contains locked and active (locked = customer not paid a long time) so our workers knows they don’t have to work on this tasks. And that is the problem. How can I get this information. If i used the foreach for the ticket (with getValues) and start for every ticket a new GET form the organization the site loading over 1 Minute, because it’s hundred of requests and that’s not very useful.
Is there any other possible to get the values? Maybe with a join by, so that I can request for example “ticket.organization_id = organization.id” and get the field “organization.status” from there in one request??
Sorry for my english.