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

Thanks. I will try to post an enhancement. . .coding it won't be me. . .been too long since I wrote real code. . .I hack code, not create it anymore. I guess I should submit one for applying genericagent to articles as well. . . ----- Original Message ----- From: Michiel Beijen To: "User questions and discussions about OTRS." Sent: Wednesday, June 09, 2010 11:53:42 PM Subject: [otrs] RegExp and sets in Ticket searches and GenericAgent??

Martin,

*blush*

Great, I was not aware of that. And apparently PostgreSQL also does it: http://www.postgresql.org/docs/current/static/functions-matching.html

Oracle apparently has a REGEXP_LIKE operator since 10g: http://www.oracle.com/technology/obe/obe10gdb/develop/regexp/regexp.htm

So the only thing is that Microsoft SQL Server and DB2 don't support it... yet.

Techfan: apparently it is possible, just not on all databases we support. So it might be feasible to offer this in OTRS when your database supports it. You can file an enhancement request at http://bugs.otrs.org and patches are always welcome :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 3:29 PM, Martin Gruner wrote:

...

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!

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