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
DynamicFieldRemoteDB Constrictions
DynamicFieldRemoteDB Constrictions
Production: OTRS 5.0.x on Centos 6 with MySQL database.
LAB: OTRS 5.0.x on Centos 7 with MySQL database.
LAB: OTRS 5.0.x on Centos 7 with MySQL database.
-
- 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
Hi,
Did you manage to do that?
Did you manage to do that?
Re: DynamicFieldRemoteDB Constrictions
No, I was not able to go on with this.alandba wrote:Hi,
Did you manage to do that?
Regards.
Production: OTRS 5.0.x on Centos 6 with MySQL database.
LAB: OTRS 5.0.x on Centos 7 with MySQL database.
LAB: OTRS 5.0.x on Centos 7 with MySQL database.
-
- OTRS expert
- Posts: 160
- Joined: 26 Nov 2014, 20:34
- OTRS Version?: 5.0.17
- Real Name: Samuel Casimiro
- Company: CD
- Contact:
Re: DynamicFieldRemoteDB Constrictions
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
3rd party packages: Yes | SSL: Yes
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
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
3rd party packages: Yes | SSL: Yes
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000