[cisco-voip] UCCX Wallboard Query

[Anthony Holloway]

First, the SQL change is simply:

*SELECT * FROM rtcsqsummary WHERE csqname IN ('Sales', 'Support', 'etc.')*

Second, if you're familiar with the MVC design, the View may need to be
rewritten to accommodate the multiple rows returned.

As a concrete example, if I wrote the code as:

*// Get record*
*record = rows[0];*
* // Do something with the record*

I may need to change it to iterate over the record set instead:

*// Get each record in the set*
*for (record in rows) {*
*    // Do something with the record*
*}*

On Wednesday, August 20, 2014, Matthew Collins <mcollins at block.co.uk> wrote:

>  Hi All,
>
>
>
> I’ve got a wallboard running but its only reporting on a specific queue
> per website, I can change the CSQ its reports on by changing name of the
> CSQ in the below line of code.
>
>
>
> Const SQL_Command = "select * from rtcsqssummary where csqname like
> 'CSQ_IT_Support’"
>
>
>
> I’m trying to change the line to report on all CSQ collectively but
> everything I try breaks it.
>
>
>
>  Thanks in advance
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/2ba96095/attachment.html>