Custom dashlet containing SQL results

Moderator: crythias

Locked
hcassidy
Znuny newbie
Posts: 12
Joined: 02 Mar 2016, 15:00
Znuny Version: OTRS5

Custom dashlet containing SQL results

Post by hcassidy »

Hello!

I am wanting to create a custom dashlet containing SQL results, is there any kind of add-on for this already available?
If not, any idea how I could create one?

Thanks
Hayley
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Custom dashlet containing SQL results

Post by reneeb »

You could have a look at the existing dashboard widgets. You need the configuration, the dashboard<xxxxx>.pm and the template. The description you provided is very vague, so it is hard to give you more hints...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
hcassidy
Znuny newbie
Posts: 12
Joined: 02 Mar 2016, 15:00
Znuny Version: OTRS5

Re: Custom dashlet containing SQL results

Post by hcassidy »

ok I'll take a look. Essentially I have a separate DB I need to query (on our PBX) so that I can list call history on a widget. Can't seem to find an example of putting arbitrary code into a new widget?
Locked