Hi Guys,
Wonder if anyone can help.
I am testing with time of day routing, and I want to be able to check yearly/monthly conditions before weekly conditions are picked up.
I can do this successfully by just inputting XML into the dialplan, and works as expected, my issue is now when extracting the detail required from a database using lua.
I for example have 3 entries below for different times of the year;
+------------+-------+------+----------------+
| dayofmonth | month | year | dayofmonthtime |
+------------+-------+------+----------------+
| 25 | 12 | 0 | 0 |
| 1 | 1 | 2016 | 540-1050 |
| 10-18 | 9 | 2015 | 600-840 |
So when creating directly using xml I get;
table.insert(xml, [[<condition mon="12" mday="25" break="on-true">]]);
table.insert(xml, [[<action application="set" data="TOD=sales" inline="true"/>]]);
table.insert(xml, [[<action application="set" data="Status=closed inline="true"/>]]);
table.insert(xml, [[</condition>]]);
table.insert(xml, [[<condition year="2016" mon="1" mday="1" break="on-true">]]);
table.insert(xml, [[<action application="set" data="TOD=sales" inline="true"/>]]);
table.insert(xml, [[<action application="set" data="Status=closed inline="true"/>]]);
table.insert(xml, [[</condition>]]);
table.insert(xml, [[<condition year="2015" mon="9" mday="10-18" break="on-true">]]);
table.insert(xml, [[<action application="set" data="TOD=sales" inline="true"/>]]);
table.insert(xml, [[<action application="set" data="Status=closed inline="true"/>]]);
table.insert(xml, [[</condition>]]);
However my issue is when my lua script extracts them, it loops through the 3 entries (each row) , so that only the 3rd entry is available for on-wards routing as it is populating the dialplan 3 seperate times.
Can someone let me know what Im doing wrong?
Im just doing a query as;
local todnew_query = string.format("select * from timeofday_new where todname='sales' and context_name='xx.xx.xx' order by priority")
assert (dbh:query(todnew_query,function(todresult)
And using the result with some if statements, I wondered if anyone had any advice on this?
Thanks
Jon