OTRS Module and SQL Querying in it

English! place to talk about development, programming and coding
Post Reply
mabdullah
Znuny newbie
Posts: 2
Joined: 15 Apr 2013, 23:06
Znuny Version: 3.1.12
Real Name: Muhammad Abdullah
Company: Expertflow

OTRS Module and SQL Querying in it

Post by mabdullah »

Hello Everyone,
I am new to OTRS, to be frank its not very friendly.
I want to create a module and want to display some data from database.
I have created an OTRS module according the HelloWorld example given in the manual. Now i want to query in the database and display the values fetched from database on HTML page. I have included the DB module, and tried to follow the steps given in manual. But I am unable to achieve my goal.
Can someone please guide me through.
mabdullah
Znuny newbie
Posts: 2
Joined: 15 Apr 2013, 23:06
Znuny Version: 3.1.12
Real Name: Muhammad Abdullah
Company: Expertflow

Re: OTRS Module and SQL Querying in it

Post by mabdullah »

Please developer, share some wisdom here. :(
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Module and SQL Querying in it

Post by jojo »

have a look at the API description if yo wan't to query the OTRS data
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS Module and SQL Querying in it

Post by crythias »

mabdullah wrote:Now i want to query in the database and display the values fetched from database on HTML page
Sounds pretty simple for anyone who can do that generally.

And since you have asked a general question, the general answer is -- if you could do this anyway, it's not OTRS that's blocking you, and if it's OTRS that's the problem, you'd be asking a specific question about what you wanted to accomplish and asking how to do that thing rather than starting off by blaming OTRS.
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
Post Reply