Hi,
do you have an idea how I can solve this for 1800 companies? and thousands of existing tickets?
Company Tickets doesn't show tickets other users
Moderator: crythias
-
- Znuny wizard
- Posts: 554
- Joined: 25 Sep 2012, 19:04
- Znuny Version: OTRS Help Desk
- Real Name: Stefan
Company Tickets doesn't show tickets other users
OTRS 5.x - Debian 8 - apache 2.4 - MySQL 5.x
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Company Tickets doesn't show tickets other users
Use at your own risk.
Make and test backups.
Your data is your responsibility.
Here's a sample Excel cell code.
A2="BadName"
B2="GoodName"
C2=
It's not recommended to manipulate the ticket database directly.
All data changes, deletions, etc. are entirely your responsibility.
***IMPORTANT*** if you do this and BadName -> GoodName and later, GoodName is considered a BadName, this is going to cause large levels of grief.
Example:
Bad | Good
Jones | Smith (All Jones become Smith)
Smith | Johnson (now all Smith become Johnson, including Jones-> Smith)
Make and test backups.
Your data is your responsibility.
Here's a sample Excel cell code.
A2="BadName"
B2="GoodName"
C2=
Code: Select all
="UPDATE ticket set customer_id="""&B2&""" WHERE customer_id="""&A2&""";"
All data changes, deletions, etc. are entirely your responsibility.
***IMPORTANT*** if you do this and BadName -> GoodName and later, GoodName is considered a BadName, this is going to cause large levels of grief.
Example:
Bad | Good
Jones | Smith (All Jones become Smith)
Smith | Johnson (now all Smith become Johnson, including Jones-> Smith)
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