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/
