DynamicFieldRemoteDB Constrictions

Locked
atomic
Znuny newbie
Posts: 3
Joined: 27 Mar 2012, 18:32
Znuny Version: 5.0.7

DynamicFieldRemoteDB Constrictions

Post by atomic »

Hi all,
I'm trying to use DynamicFieldRemoteDB connected to Postgres.
I was able to use a constriction object of type Configuration, but I cannot understand how to use constrictions of type Ticket and CustomerUser.
What I'm trying to do is to only show results that has [TableColumn] like CustomerID of the user that is opening the ticket.
Tried [TableColumn]::CustomerUser::CustomerID::0
or some other combination of [TableColumn]::CustomerUser::???:0

but the constriction sent by OTRS to Postgres is always empty.

Can someone provide an example on to use Ticket or CustomerUser constrictions?

Thanks.
Regards.

Antonio
Production: OTRS 5.0.x on Centos 6 with MySQL database.
LAB: OTRS 5.0.x on Centos 7 with MySQL database.
alandba
Znuny newbie
Posts: 6
Joined: 18 Jun 2015, 15:13
Znuny Version: 3.3.3-01
Real Name: Alan Costa de Souza
Company: Orion Consultoria
Contact:

Re: DynamicFieldRemoteDB Constrictions

Post by alandba »

Hi,
Did you manage to do that?
atomic
Znuny newbie
Posts: 3
Joined: 27 Mar 2012, 18:32
Znuny Version: 5.0.7

Re: DynamicFieldRemoteDB Constrictions

Post by atomic »

alandba wrote:Hi,
Did you manage to do that?
No, I was not able to go on with this.

Regards.
Production: OTRS 5.0.x on Centos 6 with MySQL database.
LAB: OTRS 5.0.x on Centos 7 with MySQL database.
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: DynamicFieldRemoteDB Constrictions

Post by nedmaj »

Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Locked