Re: [otrs] RegExp and sets in Ticket searches and GenericAgent??

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 wrote:

...

I assume that this means I am correct. . .no RegExp in genericAgent. . .

----- Original Message ----- From: TechFan To: "User questions and discussions about OTRS." 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!