Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
39
Select * from [generators history] where (
([fk generator type id] = forms![query parameter form]![list 5])
and
([status date] between
CVDate(forms![query parameter form]![start date])
and
CVDate(forms![query parameter form]![end date])));
When designing queries, we recommend using only static filtering in a first step. Note that
RAIS 3.0 currently allows only for foreign keys and date values to be used as parameter
values, i.e. numeric values and date values.
To create the report definition entry as well as parameters for record grouping, open and add
a new record in the table [Propagator – Report definitions].
Menu Item Identifier of the menu item
Query Name of the query to be loaded to retrieve the result set
Title Title to be displayed
Grouping Field grouping, semi colon separated list (i.e. 3;4;2)
Widths Field widths, semi colon separated list (i.e. 3;4;2) currently not supported
2.11.1 Examples
2.11.1.1 Query unsealed sources to associated equipment
Let us have a look at how the query for displaying the history of unsealed sources to
associated equipment was created in RAIS 3.0. The appropriate query already exists and has
been validated, so we may skip the first two steps and immediately jump to creating the menu
entry.
Our entry, called “History of unsealed Sources to associated Equipment”, is located in the
menu group node called “History”. Two entries hence are required in the table [Treeview]:
one entry – with the key L – for the menu group node (not linked to a query parameter form)
PDI ID N/A
PDI History
Key L
Image Index 1
Menu Name Query
and one entry – with the key L13 –for the menu leave (linked to a query parameter form).
PDI ID N/A
PDI History of unsealed Sources to associated Equipment
Key L13
Image Index 2
Menu Name Query