Hi all
I need some help with query on Postresql Database.
I have some tables on a DB, and I wanna to retrieve status on field in this
tables...
I explain:
ON the DB table, I have this field:
XXXX => Service Order
YYYY => the situation about Product Order
Now, when a cliente call to phone pluged on Asterisk, he follow the URA, by the
system.
So, the URA pass instruction to client. to him press the keys, informed the
Service Order,
maybe 1234.
In this case, the system will be compare the sequence order, and take the date
from system,
i.e., from machine where Asterisk is run.
Well, the system take this to field's: date and number of Service Order.
With this numbers, I want the system check this information on a PostgreSQL DB,
via some
ODBC query or whatever, and bring the status for Service Order.
I know that this can be appears some strange!
And to be add, my English is poor and horrible!
Some one can help?
Thanks for any help...
--
Gilberto Nunes
Itaja? - SC
