Company Tickets doesn't show tickets other users

[steste123]

Hi,
do you have an idea how I can solve this for 1800 companies? and thousands of existing tickets?

[crythias]

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=

Code: Select all

="UPDATE ticket set customer_id="""&B2&""" WHERE customer_id="""&A2&""";"

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)