Search on customer_company name

Moderator: crythias

Post Reply
zhakal
Znuny newbie
Posts: 47
Joined: 30 Jul 2011, 20:06
Znuny Version: 3.0.11

Search on customer_company name

Post by zhakal »

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
OTRS 3.0.11 , RHLE 5.6 & CentOS 6
MSSQL 2008 R2 , Windows 2008 R2
crythias
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

Post by crythias »

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
zhakal
Znuny newbie
Posts: 47
Joined: 30 Jul 2011, 20:06
Znuny Version: 3.0.11

Re: Search on customer_company name

Post by zhakal »

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
crythias
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

Post by crythias »

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
Post Reply