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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of sip
Sent: Wednesday, September 28, 2005 11:13 AM
To: serusers(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers