Trying to automatize tickets to agents

Moderator: crythias

Locked
Bashizz
Znuny newbie
Posts: 1
Joined: 20 Jun 2024, 16:22
Znuny Version: 6.0
Real Name: Ivo

Trying to automatize tickets to agents

Post by Bashizz »

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
root
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

Post by root »

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
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 ?
Locked