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.
OTRS Module and SQL Querying in it
-
- 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
Please developer, share some wisdom here. 

Re: OTRS Module and SQL Querying in it
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Sounds pretty simple for anyone who can do that generally.mabdullah wrote:Now i want to query in the database and display the values fetched from database on HTML page
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
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