Michiel,

correct me if I'm wrong, but doen't mysql have this feature?
http://dev.mysql.com/doc/refman/5.0/en/regexp.html

This would, however, not solve the original request completely, only the
selecting of tickets, but not the capturing of ticket data.

Regards,
mg

Am 09.06.10 15:13, schrieb Michiel Beijen:
> Hi TechFan,
>
> That would be pretty difficult, because the GenericAgent uses searches
> in the database, so it does like SELECT * FROM TICKET WHERE .... and
> since WHERE-statements don't support Regexes, the only solution is to
> SELECT the complete database and then evaluate the regex for every
> ticket, I guess that is a bit too much.
>
> So it would be an idea if you file an enhancement request at MySQL and
> PostgreSQL to accept regex constructs in SELECT statements.... :D
>
> ((enjoy))
>
> Michiel Beijen
> R&D
>
> Follow me on Twitter: @otrsnl [https://twitter.com/otrsnl]
>
> OTRS AG
> Norsk-Data-Str. 1
> 61352 Bad Homburg
> GERMANY
>
> T: +31 (0) 6457 42418
> F: +49 (0) 9421 56818-18
> I:  http://www.otrs.com
>
> Business Location: Bad Homburg, Country Court: Bad Homburg, HRB 10751,
> VAT ID: DE256610065
> Chairman: Burchard Steinbild, Managing Board: André Mindermann
>
> GET OTRS::ITSM 2.0 NOW - including the brand new change management
> module! It´s the only ITIL® V3 compatible open-source IT Service
> Management solution certified by PinkVERIFY worldwide! -
> http://bit.ly/dv4CJF
>
>
> On Wed, Jun 9, 2010 at 1:41 PM, TechFan <[email protected]> wrote:
>   
>> I assume that this means I am correct. . .no RegExp in genericAgent. . .
>>
>> ----- Original Message -----
>> From: TechFan <[email protected]>
>> To: "User questions and discussions about OTRS." <[email protected]>
>> Sent: Friday, June 04, 2010 12:00:39 AM
>> Subject: [otrs] RegExp and sets in Ticket searches and GenericAgent??
>>     
>>> I was trying to search through tickets using a regexp in the ticket
>>> search?  It seems that I can't use regexp there or in the GenericAgent?  Is
>>> that true or am I missing something.  Ideally, I would be using a RegExp set
>>> to grab a value and set it in another field. . .is that possible?  Thanks.
>>> ---------------------------------------------------------------------
>>> OTRS mailing list: otrs - Webpage: http://otrs.org/
>>> Archive: http://lists.otrs.org/pipermail/otrs
>>> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>>>
>>> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
>>> http://www.otrs.com/en/support/enterprise-subscription/
>>>       
>> ---------------------------------------------------------------------
>> OTRS mailing list: otrs - Webpage: http://otrs.org/
>> Archive: http://lists.otrs.org/pipermail/otrs
>> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>>
>> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
>> http://www.otrs.com/en/support/enterprise-subscription/
>>
>>     
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
>
> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
> http://www.otrs.com/en/support/enterprise-subscription/

-- 
Martin Gruner
Developer

OTRS AG
Europaring 4
94315 Straubing

T: +49 (0)6172 681988 0
F: +49 (0)9421 56818 18
I:  www.otrs.com/

Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: 
DE256610065
Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann

NEU: OTRS::ITSM 2.0 - jetzt mit dem brandneuen Change Management Modul. -Die 
erste ITIL® V3 kompatible 
und nach PinkVERIFY zertifizierte Open Source IT Service Management (ITSM) 
Lösung weltweit!

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Reply via email to