DynamicFieldRemoteDB Constrictions

Moderator: tto

atomic
OTRS newbie
Posts: 3
Joined: 27 Mar 2012, 18:32
OTRS Version?: 5.0.7

DynamicFieldRemoteDB Constrictions

Postby atomic » 25 Mar 2016, 12:12

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
OTRS newbie
Posts: 6
Joined: 18 Jun 2015, 15:13
OTRS Version?: 3.3.3-01
Real Name: Alan Costa de Souza
Company: Orion Consultoria
Contact:

Re: DynamicFieldRemoteDB Constrictions

Postby alandba » 07 Jun 2016, 21:11

Hi,
Did you manage to do that?

atomic
OTRS newbie
Posts: 3
Joined: 27 Mar 2012, 18:32
OTRS Version?: 5.0.7

Re: DynamicFieldRemoteDB Constrictions

Postby atomic » 02 Aug 2016, 12:32

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.

User avatar
nedmaj
OTRS wizard
Posts: 147
Joined: 26 Nov 2014, 20:34
OTRS Version?: 5.0.17
Real Name: Samuel Casimiro
Company: CD
Contact:

Re: DynamicFieldRemoteDB Constrictions

Postby nedmaj » 07 Aug 2017, 15:23

Samuel

OTRS 5.0.17
OTRS::ITSM 5.0.17
OS: CentOS 6.5
Database: Oracle 12.1
Reporting: Pentaho
DW Database: PostgreSQL
User database and auth module: LDAP (Active Directory)
Mail server: Microsoft Exchange
Sendmail module: Sendmail (Postfix)
3rd party packages: Yes
SSL: Yes
Number of agents: 450
Number of customers: 20000
Number of CIs: 30000


Return to “Patches / Modules”

Who is online

Users browsing this forum: No registered users and 2 guests