Hi All,
I know the feature "Customer with multiple IDs (Company tickets)" which has been shared a lot and I knew the way to use this feature by 2 simple steps below:
1. Add a new column in the table customer_user by this command: ALTER TABLE customer_user ADD customer_ids VARCHAR (250)
2.Adding a UserCustomerIDs field to the Kernel/Config.pm file
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
[...]
[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
But I don't know how to complete the above steps with the OTRS Server which is running Windows Server and Microsoft SQL Server (managed by SQL Server Management Studio). And don't know how to insert the information to Config.pm file & how to run this file on Microsoft Windows OS.
Kindly help.
How to enable the "Customer with multiple IDs" on SQLSRV
Moderator: crythias
How to enable the "Customer with multiple IDs" on SQLSRV
Running the OTRS Server on Windows Server 2012 R2 Standard & Microsoft SQL Server 2012 Standard
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: How to enable the "Customer with multiple IDs" on SQLSRV
start by add column in SSMS.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: How to enable the "Customer with multiple IDs" on SQLSRV
Hi Crythias, already add the column, but how can I modify and run config.pm?crythias wrote:start by add column in SSMS.
Running the OTRS Server on Windows Server 2012 R2 Standard & Microsoft SQL Server 2012 Standard