Crestron
e-control Vote SW-VOTE
54
••
Database
Installation & Reference Guide — DOC. 5822
The Queries table
Complete specifications for the
Queries
table can be found in the SW-DBM
manual, Doc. 5823. For the present purposes it is sufficient to show how to specify
queries for queue scrollers and agenda scrollers. Consider the example provided in
the supplied sample database file.
Contents of the
Queries
table in the sample database file,
demovote.mdb
.
The following tables contain all the information you need to set up queue and agenda
scrollers.
Field contents of
Queries
table records for RTS queue scrollers
Field
Contents
ID
The number in the ID field is the query number given in the Scroller
Definition window for the scroller implementing this queue.
description
The description field contains the string sent via the
QueryDescription
signal when the scroller is enabled. Typically this serial signal would feed an
indirect text field positioned above each queue and might contain phrases
such as “Request to speak,” “Request to Question,” “Conflict of interest,” etc.
table
As previously noted, naming of the referenced tables in the table field is
arbitrary. We suggest keeping the names the same as those given to the
scroller signal blocks implementing the queues.
condition
Null.
listFields
The listFields field must contain the names of at least the two fields shown
from the referenced table, Speaker and State. Other fields can be included
as well and will be filled automatically with data from the Members table if
fields with matching names are found there.
DataFields
The dataFields field must contain the field names seat, rank, and ID, as
shown. These are additional fields from the referenced table to which the
RTS Console signal block needs access.
SQL
Null
Field contents of
Queries
table records for agemda item scrollers
Field
Contents
ID
The number in the ID field is the query number given in the agenda scroller’s
Scroller Definition window.
Description
The description field contains the string sent via the
QueryDescription
signal when the scroller is enabled. Typically this serial signal would feed an
indirect text field positioned above the agenda scroller and might contain a
phrase such as “2nd Session Agenda.”
Table
As previously noted, naming of the referenced tables in the table field is
arbitrary. We suggest keeping the agenda table name the same as the name
given to the agenda scroller signal block.
