Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
2
The descriptions of the main types of queries are given in the following table.
Type of query Description, Function
Allocation – Is used by the system (forms with multiple selection),
are system queries that normally don’t need to be
modified
Calculation – Queries that contain any type of mathematical
calculation (e.g. current activity of an isotope)
Consistency Check – Checks whether data entered by user meets the defined
validation rule
Display – Return records that are currently being displayed, used
further in queries
Entry Filter – Determine a recordset that should appear in a drop-
down (combo) box
Helper – Helper queries that are used when its hard to obtain the
needed data with one SQL query
Item Selection – System query that normally don’t need to be modified
Menu Selection – Reads current location of the user in the interface
Mini Display – Contains all the data to be shown in main window, later
to be filtered by “Preselection List –“ query
Preselection Filter – Used to fill drop-down boxes, contain two fields: ID
and one more
Preselection List – Reads the values chosen by the user in menus and
filters records to show
Query – One of the most relevant types for customization
(together with statistics) – displays list of items (report)
based on user choices (e.g. facilities w/o authorization)
Statistics – One of the most relevant types for customization
(together with query-type) – displays counts of items
(report) based on user choices (e.g. number of facilities
w/o authorization)
UnAllocation – Is used by the system (forms with selection and
assignment of multiple values). System query that
normally don’t need to be modified
The general approach for advanced customization is:
• Design, test and validate custom objects (forms, queries etc.) in an unlocked RAIS 3.0
front-end:
Testing and validation is most efficiently done directly in an unlocked RAIS 3.0 front-
end. This allows for immediate testing of the new objects in their final environment.
Please refer to section 4 in the RAIS Administrator Guide for instructions about how
to create an unlocked front-end.