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
- 
				root
 - Administrator
 - Posts: 4281
 - 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 ?