Generic agent search for multiple words in subject

Moderator: crythias

Post Reply
peo
OTRS newbie
Posts: 24
Joined: 04 Feb 2015, 14:46
OTRS Version?: 3.3.9
Real Name: Per Olsen
Company: Capana

Generic agent search for multiple words in subject

Post by peo » 12 May 2016, 10:51

Hi

How to i set the filter, so that a gerneric agent searches for multiple words in subject line?

ex.. it needs to search for "Kolding, Albertslund and Søborg"

I have tried to make the search as "*Søborg*" "*Kolding*" - but it does not work

Only if i type "*Søborg*" it works - do i realy need to make multiple generic agents?

hkais
OTRS newbie
Posts: 30
Joined: 16 Apr 2016, 08:55
OTRS Version?: 5.0.26

Re: Generic agent search for multiple words in subject

Post by hkais » 30 May 2018, 17:54

how did you solve your issue?

alexus
OTRS superhero
Posts: 274
Joined: 20 Sep 2010, 16:54
OTRS Version?: ITSM 5.0.14
Real Name: Alexey Yusov
Company: Radiant System
Location: Prague
Contact:

Re: Generic agent search for multiple words in subject

Post by alexus » 02 Jun 2018, 23:23

Hi

*Kolding*Albertslund*Søborg* works like Kolding AND Albertslund AND Søborg. If you need Kolding OR Albertslund OR Søborg you should create 3 separate jobs for every pattern.
Alexey Yusov

Production: OTRS ITSM 5.0.14 on CentOS 7 x64 Linux with MySQL 5.7
Tested: OTRS ITSM 5.0.14
Radiant System OTRS Intergrator
Stay tuned on our Facebook
Get OTRS Professional Services - Consulting, Implementation, Training, Development, Support!

hkais
OTRS newbie
Posts: 30
Joined: 16 Apr 2016, 08:55
OTRS Version?: 5.0.26

Re: Generic agent search for multiple words in subject

Post by hkais » 06 Jun 2018, 17:26

honestly?
In the year 2018 we need such a bad workaround to copy rules and to do all manually?
cannot understand it, since afaik it shall be a simple mapping to SQL syntax if allowing the conditions

Code: Select all

SQL => string
OR => e.g. |
AND => e.g. &
braces () => () -- for allowing expressions
% => * for allowing wildcards
and mostly 90-95% of all possible cases would be handled properly. Especially since that area is only accessible to power users or even admins.

sadly none in my team is able to program the outdated perl...

Post Reply