How to write SQL queries using otrs API?

Moderator: crythias

Locked
artjoms15
Znuny advanced
Posts: 121
Joined: 30 Aug 2011, 10:48
Znuny Version: 3.3.8 && 4.0.9
Real Name: Artjoms Petrovs
Location: Latvia

How to write SQL queries using otrs API?

Post by artjoms15 »

Hello, dear OTRS Community!
Recently i've got one brainfuzzing problem - How to write sql queries properly, using OTRS API and without establishing new connections to database.
Everything I tried just leaded to errors - neither new registrated modules neither injections in some other modules causes apache to crash after restart. Hope someone can advice me :)
Ar cieņu / Kind regards,
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: How to write SQL queries using otrs API?

Post by crythias »

Pick one: Use the API or make SQL queries.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
artjoms15
Znuny advanced
Posts: 121
Joined: 30 Aug 2011, 10:48
Znuny Version: 3.3.8 && 4.0.9
Real Name: Artjoms Petrovs
Location: Latvia

Re: How to write SQL queries using otrs API?

Post by artjoms15 »

Got it ;)
Thanks, You really know how to cheer up people :D And your advice works :D
Ar cieņu / Kind regards,
----------------------------------------
Artjoms Petrovs
Sistēmu analītiķis/Programmētājs /
Systems Analyst/Programmer
Locked