Hello all!
I wrote a procedure in mariaDB, that reads the data from a ticket tittle, and catch a reference (with a few conditions) that will then correlate with a table that I have that has the agents mapped with the reference, I update the camps UserID, change_time (update to now()), ticket_lock_id from the table tickets, the tickets will get to the user correctly mapped but the camp Owner doesn't change to the correct one, it stays on the last owner.
Do i need to write data in the table history and state_index for it to work like using the front-end to pass a ticket from Owner to Owner, or is there something else i could do to automatically attribute tickets to other owners?
Bashizz
Trying to automatize tickets to agents
Moderator: crythias
-
- Administrator
- Posts: 4249
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Trying to automatize tickets to agents
Hi,
You bypassed the API and, therefore, the caching mechanism. You have to set the owner via the API. Whether it's the Perl API or the GenericIncterface.
- Roy
You bypassed the API and, therefore, the caching mechanism. You have to set the owner via the API. Whether it's the Perl API or the GenericIncterface.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?