[Serusers] Arbitrary queries

[Chris St Denis]

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