Background Information
Database queries Your image analysis program offers three methods of finding images in a database.
Query by Example You can use this query for a simple search for the entry of a field. You can also link several fields using the AND link. For a query by example you can use the " * " wild- card.
Query by Free Filter You can use this query for a search using several search criteria which you want to connect in a complex way using AND or OR links.
Query by SQL This query uses the standard SQL database administration language to formulate the search criteria.
Query You can use this button to carry out an initial query by example. For subsequent queries, you open the dialog box of the pervious query.
Save search filter For queries by free filter and queries with SQL, you have the possibility of saving your search filter so that it may be reloaded later if required.
Representation of the query results:
•
The data found is indicated in the "Query results" database folder directly under the database symbol in the tree structure.•
The "Query results" database folder is updated with the new query results for each search.•
Query results are no longer present after a new start of the program.Query by Example
Search targets are ... Field Entry
... all records by Christian User Christian
... all records beginning with letters "Gold" Record Name Gold* ... Database folders created after 16.4.2005 Date >16.04.2003 ... all records inserted on 31.5.05 before 18.30 Document Insertion Date 31.5.2005
Document Insertion Time <18:30 ... all images which were not acquired using the
"SlowScan" logical input channel
Channel <> SlowScan ... all images with a magnification of 200 or
more
Magnification >=200
... all sheets file name *.sfs
Query by Free Filter
Search targets are ... Field C. with C. with ... all folders from 2008 Date >= 1.1.2008 < 1.1.2009 ... all RGB and gray-value
images
Image Type = RGB
OR
Image Type = Mono
... all image names which begin with A
image name >= A < B
... all images were inserted on the 20.5.2003 between 15.00 and 20.00 Document Inser- tion Date = 20.5.2003 AND Document Inser- tion Time >= 15:00 <= 20:00
Archiving Images Finding data - Step-by-step
85
Step-by-step
Selecting the database fields which you need in the query mask
In your database there is the user-defined "User" field. You want to be able to find all the images the user "Mr. Smith" inserted into the database in 2003.
1) Select the Database > View > Arrange Fields... command.
2) Mark Query by Example in the View/Type list.
3) Select the fields in which you want to search for images, e.g., the user-defined "User" field and the predefined "Document Insertion Date" field.
4) Click OK to close the dialog box.
Searching for images in your database
1) Select the Database > Query by Example... command.
"
The Query by Example dialog box contains the selected database fields.2) Enter the required entries into one or more fields. For example, enter "Mr. Smith" into the "User" field and "31.12.2002" into the "Document Insertion Date" field.
•
During the query by example, fields are linked with "AND". You will only find the images which fulfill all the search criteria simultaneously.•
The query mask offers you a selection assistant for all date fields. Click the... button next to the date field. A dialog box with a predefined date opens. Click on the arrow to open a calendar in which you can select the date that you need.
3) Click the Advanced >> button in the query mask. Click the Unselect All button. Mark the check box in front of the Image data type to limit the search to images. Other documents will not be found.
4) Click the Search button to carry out the search.
"
The images found will be displayed in a separate database folder with the name "Query results". The query results are displayed directly under the database icon in the tree structure."
Some information about the current query is displayed in the form, for example, the number of records that have been found.Archiving Images
Work in the database window - Background Information
86
The "Query results" database folder shows all the data that has been found. The form contains information about the query.
5) Use the Previous record in history button to return to the record which was marked before the query was carried out.
6) Mark the "Query results" database folder in the tree structure.
7) Mark one of the images that has been found. Click the right mouse button and select the Goto Record command from the context menu.
"
The marking in the tree structure jumps to the database folder which contains the selected record.8) Mark the "Query results" database folder again. Use the [Del] key to delete the search result.
Load data
Background Information
Load stored data If you have already archived part of your data on removable data media, the system searches for a data medium with a fixed name when loading. This explicit data medium name is automatically assigned by the system during filing. You will be asked to label the data medium with the name. To load the data, insert the required data medium. Then select the "DocumentFiles"- directory or click the Query button.
Integrate images in reports
Use the report generator to produce professional multiple page reports (File > Report > New...). It offers layout options for the highest standard of reports. Images, docu- ments and database fields can be easily integrated directly. You can also import values from previously-specified table boxes into a report.
Export images You can copy database images and documents as files onto any network drive at any time (Database > Export record files...). You can then edit these files using other programs and also print them out.
Archiving Images Load data - Step-by-step
87
Step-by-step
Loading an image
1) Mark an empty image buffer in the image buffer box.
2) In the database document's gallery view, doubleclick the image you want to load.
"
The image is loaded into the image buffer and represented in the image window.•
Alternatively, you can drag&drop the image, either from the gallery view or from the tree structure, onto the image buffer.•
Please note: using these two methods will load the image, but not the documents which may be attached to them.Loading several images in a defined order
1) If the images that you want to load are in different database folders, carry out a query to find all the required images. Search for example, for all the images which have been inserted for the projects A and B.
"
All images found will be displayed in the gallery view.2) Mark the images in the order in which you want to load them. To do this, depress the [Ctrl] key and mark the images with the left mouse button.
"
All the marked images have a colored background. The numbers in the top right corner of the images represent the order of the marking.3) Mark an empty image buffer in the image buffer box.
4) Select the Database > Load Document command.
"
The marked images will be loaded into the successive image buffers of the image buffer box in the selected order. If one of the image buffers is write protected, your image analysis program stops loading at this point.•
Please Note: images in image buffers that are not write protected will be overwritten without warning.Archiving Images
Work in the database window - Step-by-step
88
If you mark several records, the records in the galleryare numbered on the top right in the order of selection. Select the Load Document command to load all the selected images into the image manager in the order selected.
Loading all the data within a database folder 1) Mark a database folder in the tree structure.
2) Select the Database > Load Document with Subdocuments command if you want to load all the records within the database folder.
"
Images will be loaded one after another into the successive image buffers of the image buffer box."
Documents are opened in your image analysis program - these are for example the sheets with the SFS file name extension and the diagrams with the SFD file name extension."
Other document files are loaded in the appropriate application programs - these are for example the text files with the DOC file name extension in Word and the sheets with the XLS file name extension in Excel.Archiving Images Archive data - Background Information
89
There are four images in the marked database folder. Select the Load with Documents command to load all the images into the image manager.