You can use AVPs and use a database view (if you are using postgres. mysql < 5.0 and flatfile are not powerful enough for this) to import the data you need into the avp table then use regular expression AVP queries.

Not sure if this will fit your needs, but I can't think of a better way to do it without knowing exactly what you are trying to do.

-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of sip Sent: Wednesday, September 28, 2005 11:13 AM To: serusers@lists.iptel.org Subject: [Serusers] Arbitrary queries

Is the only way to make arbitrary queries from the DB to use an external script?

I'm having a devil of a time creating something like:

SELECT from_uri FROM acc WHERE to_uri LIKE '%username@domain%' AND sip_method='INVITE' ORDER BY TIME DESC LIMIT 1

Any ideas? Or am I stuck with external scripts?

N.

_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers