sql query database dynamic field

Moderator: crythias

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

sql query database dynamic field

Post by rdomingos »

how add sql query database mariadb on dynamic field remotedb?

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

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 / 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