By default the OTRS comes with the "search full text" option. This type of search will cause problems like hangs or slowness of response once the database has reach a certain number of records (millions).
It is highly recommended to make a more efficient search by ticket number (if its a ticket what you are looking for of course ).
to change the default search parameters go to:
SysConfig -> Ticket -> Frontend::Agent::Ticket::ViewSearch
Look for: Ticket::Frontend::AgentTicketSearch###Defaults###Fulltext
deactivate the checkbox and activate :
Ticket::Frontend::AgentTicketSearch###Default###TicketNumber
(you can choose any other default option this way)
Update.
This will leave the Search By Ticket Number as default, leaving the option to search in the whole DB IF needed.
This will prevent your agents for making ticket searches in the WHOLE database, thus incrementing efficiency and resources.
How to change the default search ticket parameters
Moderator: crythias
Forum rules
Dont create your support topics here! No new topics with questions allowed!
Dont create your support topics here! No new topics with questions allowed!
How to change the default search ticket parameters
OTRS V 3.0.7 Windows 2008 x64 going for 3.1.7
OTRS 3.1.12 on LINUX UBUNTU SERVER
OTRS 3.1.12 on LINUX UBUNTU SERVER
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: How to change the default search ticket parameters
Another search param to consider is:
Ticket::Frontend::AgentTicketSearch###Defaults###TicketCreateTimePoint
TicketCreateTimePointFormat=day;TicketCreateTimePointStart=Last;TicketCreateTimePoint=30;
This allows searching by default tickets created in the last 30 days. If you choose "Before" instead of "Last" it will be "older than 30 days ago". "day" can be: minute,hour,day,week,month, or year
Ticket::Frontend::AgentTicketSearch###Defaults###TicketCreateTimePoint
TicketCreateTimePointFormat=day;TicketCreateTimePointStart=Last;TicketCreateTimePoint=30;
This allows searching by default tickets created in the last 30 days. If you choose "Before" instead of "Last" it will be "older than 30 days ago". "day" can be: minute,hour,day,week,month, or year
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: How to change the default search ticket parameters
That's a great tip to improve searches even more!!crythias wrote:Another search param to consider is:
Ticket::Frontend::AgentTicketSearch###Defaults###TicketCreateTimePoint
TicketCreateTimePointFormat=day;TicketCreateTimePointStart=Last;TicketCreateTimePoint=30;
This allows searching by default tickets created in the last 30 days. If you choose "Before" instead of "Last" it will be "older than 30 days ago". "day" can be: minute,hour,day,week,month, or year
I have a question, is there a way to complete delete the FULL SEARCH field from the search ticket screen?
OTRS V 3.0.7 Windows 2008 x64 going for 3.1.7
OTRS 3.1.12 on LINUX UBUNTU SERVER
OTRS 3.1.12 on LINUX UBUNTU SERVER
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: How to change the default search ticket parameters
removeguillo wrote:is there a way to complete delete the FULL SEARCH field from the search ticket screen
Code: Select all
{
Key => 'Fulltext',
Value => 'Fulltext',
},
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: How to change the default search ticket parameters
Thanks a lot. I did it and worked like a charm.
OTRS V 3.0.7 Windows 2008 x64 going for 3.1.7
OTRS 3.1.12 on LINUX UBUNTU SERVER
OTRS 3.1.12 on LINUX UBUNTU SERVER
Re: How to change the default search ticket parameters
Hi,
Is there a way to change the criteria of the attributes from 'and' to 'OR' condition?
As in by selecting 2 attributes in the search parameter, the condition becomes 'And' and not 'OR'. Is there a way to change to an "OR" condition.
Please help
Is there a way to change the criteria of the attributes from 'and' to 'OR' condition?
As in by selecting 2 attributes in the search parameter, the condition becomes 'And' and not 'OR'. Is there a way to change to an "OR" condition.
Please help