Creating Custom Reports / Configuring Report Parameters |
<PARAMETER>
<DISPLAYNAME>Device Status</DISPLAYNAME>
<BINDNAME>status</BINDNAME>
<TYPE>MULTILIST</TYPE>
<DBLOOKUP>(select Status code,11
Status description from devicestatus )
union (select '||||', ' All Device Status'
description ) Order by
description</DBLOOKUP>
</PARAMETER>
Database lookup query that returns status descriptions from the devicestatus table.