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 <martin.gru...@otrs.com> 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 <lists.sf....@ourholm.net> wrote: >> >>> I assume that this means I am correct. . .no RegExp in genericAgent. . . >>> >>> ----- Original Message ----- >>> From: TechFan <lists.sf....@ourholm.net> >>> To: "User questions and discussions about OTRS." <otrs@otrs.org> >>> 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/
