Hi!
I've noticied that when you change the CustomerCompanyID, it doesn't reflect that change in the Tickettable at the database. Those ticket remains with the old CustomerCompanyID, wich is a problem.
I've reached the point in code (..\Kernel\System\CustomerCompany\DB.pm, Line 332 : sub CustomerCompanyUpdate ) where it builds the SQL sentence to Update the CustomerCompany table (so i think).
Anyone can help me to create a block of Perl Code to update the Ticket table right after the update at CustomerCompanyTable?
Cumps,
Update TICKET when CustomerCompanyID is modified
Moderator: crythias
-
aMescAs
- Znuny newbie
- Posts: 24
- Joined: 05 Jan 2015, 13:27
- Znuny Version: 3.3.9
- Real Name: Flávio Rocha
Update TICKET when CustomerCompanyID is modified
OTRS 3.3.9 (private) on Windows Server 2012 with MySQL database.
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Update TICKET when CustomerCompanyID is modified
use Generic Agent to update ticket CustomerCompanyID
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
-
aMescAs
- Znuny newbie
- Posts: 24
- Joined: 05 Jan 2015, 13:27
- Znuny Version: 3.3.9
- Real Name: Flávio Rocha
Re: Update TICKET when CustomerCompanyID is modified
Didn't get what you meant here..crythias wrote:use Generic Agent to update ticket CustomerCompanyID
OTRS 3.3.9 (private) on Windows Server 2012 with MySQL database.
-
aMescAs
- Znuny newbie
- Posts: 24
- Joined: 05 Jan 2015, 13:27
- Znuny Version: 3.3.9
- Real Name: Flávio Rocha
Re: Update TICKET when CustomerCompanyID is modified
Hi,
after all i didn't needed to manually update the Ticket table. The system is doing OK.
The confusion was made by some users, when searching for CostumerCompanyID's that had blank spaces. The filter in OTRS doesn't support blank spaces, so... PROBLEM SOLVED!
Anyway, thank you @crythias!
Cumps
after all i didn't needed to manually update the Ticket table. The system is doing OK.
The confusion was made by some users, when searching for CostumerCompanyID's that had blank spaces. The filter in OTRS doesn't support blank spaces, so... PROBLEM SOLVED!
Anyway, thank you @crythias!
Cumps
OTRS 3.3.9 (private) on Windows Server 2012 with MySQL database.