Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
43
After copying the new report from the front end to the creator, modification of the creator is
necessary for the new report to be created upon the next creation run See section 3.2 for
details.
2.12 Customizing Search Functionality
The search form allows for searching of information items as for instance facilities, sources
and workers. Information items may be searched by parts of the regulatory authority number
or their names. SQL statements are used to display search results in the result window of the
search form. Double-clicking on any entries of the result list then allows switching to the
selected record.
Search filters are defined by records in the table [System - Search]
Search Item Name of the item to search for (need not match any table name)
Search Field Name of the data field to be searched for (need not match any field name).
The value of this field is to be used in filter statements with the expression
[NAME]
Search SQL SQL string filtering for search results matching the search field value.
Result Menu Menu to load on double-click
Result Form Data entry form to load on double-click
Example:
This example shows definitions required for a search filter allowing for searching a facility
by name:
Search Item Facility
Search Filed Name
Search SQL select [PK Facility ID], [Facility Name] from [Facility] where [Facility
Name] like "*" & [Value] & "*" order by [Facility Name]
Result Menu INPUT
Result Form SUB EDIT Facility