Rooms search

{% "controller": "TableBS4", "sql":" select a.nome, '/nqcontent.cfm?a_id=202958&id='||a.id as AULA_LINK, a.posti, s.nome as sede, ( decode(MICROFONO,'','','Microphone: '||MICROFONO||'
') || decode(VIDEOPROIETTORE,'','','Video projector: '||VIDEOPROIETTORE||'
') || decode(DVD_VHS,'','','Dvd/Vhs: '||DVD_VHS||'
') || decode(COMPUTER,'','','Computer: '||COMPUTER||'
') || NOTE ) AS DOTAZIONE from aule a, sedi s where a.sede = s.id and a.sede <> 'U99999' order by sede, nome", "raggruppa": "SEDE", "colonne": { "NOME": {"label":"Room", "type":"link", "href":"AULA_LINK"}, "POSTI": {"label":"Seats"}, "DOTAZIONE": {"label":"Equipment", "noescape":true} }, "lang":"en" %} {% $content %}