At the moment when you want to search on given criterias, you are able to search on CustomerID and Customer User Login, but I need to be able to search on the name field used in the Customer_company table.
It's mainly the same search criteria as on the AdminCustomerCompany search.
How to do this in a simple and clean way?
Running OTRS 3.0.10
Search on customer_company name
Moderator: crythias
Search on customer_company name
OTRS 3.0.11 , RHLE 5.6 & CentOS 6
MSSQL 2008 R2 , Windows 2008 R2
MSSQL 2008 R2 , Windows 2008 R2
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Search on customer_company name
You can't search, generally, on customer_company name because it's not part of the ticket. It's linked/referred by the CustomerID, but that's it.
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: Search on customer_company name
Is there then a simple way to find all tickets for one company without having to search by a ID number but the actual name?
OTRS 3.0.11 , RHLE 5.6 & CentOS 6
MSSQL 2008 R2 , Windows 2008 R2
MSSQL 2008 R2 , Windows 2008 R2
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Search on customer_company name
Not unless that actual name is the CustomerID. If someone wants to offer another answer, then I'm incorrect.
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