sql query database dynamic field

Moderator: crythias

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

sql query database dynamic field

Post by rdomingos » 10 Oct 2018, 23:43

how add sql query database mariadb on dynamic field remotedb?

reneeb
OTRS guru
Posts: 4678
Joined: 13 Mar 2011, 09:54
OTRS Version?: 3.3.x
Company: Perl-Services.de
Contact:

Re: sql query database dynamic field

Post by reneeb » 15 Oct 2018, 08:31

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 / OTRS development: http://perl-services.de
Free OTRS add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de

Post Reply