sql query database dynamic field

Moderator: crythias

Post Reply
rdomingos
Znuny newbie
Posts: 2
Joined: 10 Oct 2018, 21:47
Znuny Version: 6.0.11.01

sql query database dynamic field

Post by rdomingos »

how add sql query database mariadb on dynamic field remotedb?
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: sql query database dynamic field

Post by reneeb »

You can't define the SQL query. The query is built on the information you have to provide in the field settings (table name, field name, ...) So you can't have complex SQL queries. You would have to define views in your DB and select from that view...
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
Post Reply