How to create Dashboard with manual SQL Query.

Moderator: crythias

Post Reply
Sleepwalker
Znuny newbie
Posts: 15
Joined: 05 Apr 2017, 11:43
Znuny Version: OTRS 4.0.x

How to create Dashboard with manual SQL Query.

Post by Sleepwalker »

is it possible to make a manual SQL in /opt/otrs/Kernel/Output/HTML/DashboardTicketGeneric.pm?

i want to filter ticket with same dynamic field (1 column) with multiple values (many values).

please help. i'm new to otrs.
Sleepwalker
Znuny newbie
Posts: 15
Joined: 05 Apr 2017, 11:43
Znuny Version: OTRS 4.0.x

Re: How to create Dashboard with manual SQL Query.

Post by Sleepwalker »

help me please.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: How to create Dashboard with manual SQL Query.

Post by jojo »

This would require development
"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
Sleepwalker
Znuny newbie
Posts: 15
Joined: 05 Apr 2017, 11:43
Znuny Version: OTRS 4.0.x

Re: How to create Dashboard with manual SQL Query.

Post by Sleepwalker »

jojo wrote:This would require development
can anyone help me? or tutorial to makeit work,
root
Administrator
Posts: 3960
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: How to create Dashboard with manual SQL Query.

Post by root »

Here's the developer manual: http://doc.otrs.com/doc/manual/develope ... index.html

For makeit work try a post in the developer's corner viewforum.php?f=64 or asked for payed work here: viewforum.php?f=104
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 ?
Post Reply