Tests and quizzes creation with UniTest System software. Web Design. Software Development. Language Translation ...

Table of Contents
Intro
Editor
Test
Report
Report Features
Report Toolbars
The Filter Setup Dialog
The Filter Language
Report Creation
Results Database Field Names
The Change Password Dialog
Monitor
Settings
UniTest Starter
UniTest Direct

 Online Help System: UniTest System

The Filter Language

The Filter language used for filtering the results database is very simple and easy to understand.

The Filter construction consists of one or more simple filter expressions, bearing relation between a field and its value. For example, last name less than "L" (i.e. all last names starting from "A" to "K") written as [LastName]<'l' is a simple filter expression.

Field Names

Field names used in the Filter language differ slightly from the names used to describe these fields. See Results Database Field Names for the list of field names.

Besides, every field name used in the filter language must be written in square brackets ("[]"). For example, not LastName but [LastName].

Relation Operators

The Filter is a relation between a specific field and its value. Every filter has an "equal" (=), "not equal" (<>), "less than" (<), "more than" (>), "not less than" (>=) or "not more than" (<=) relation operator. for example, [FirstName]='Pete' (first name is Pete) or [Address]>='P' (address starting with P to Z letter).

Field Values

Field value is the value that will be compared with all records in the field. For example, in [UserField1]='Group 01A' Group 01A is the field value. Field value must be in single quotes (') if the corresponding field is a text or date field (see field types in Results Database Field Names table). Otherwise (if number field), without quotes.

For example, [FirstName]='Katie' and [TestDate]>'03.07.2001' but [Mark]>=4.

OR Condition

You can connect two or more simple filter expressions, so that if at least one filter expression is correct, then the whole filter structure is correct. To do this you need to connect these filter expressions with "OR". For example, if we have two expressions [LastName]<'l' and [First Name]='John', then connection will be [LastName]<'l' or [first name]='john'. This way we set a filter: last name is starting from "A" to "K" or the first name is John.

AND Condition

You can connect two or more simple filter expressions, so that only if all filter expressions together are correct, then the filter structure is correct. To do this you need to connect these filter expressions with "AND". For example, if we have three expressions [LastName]>='Se', [Address]='105 Bailey Alley' and [TestSubject]='Algebra', then the connection will be [LastName]>='Se' AND [Address]='105 Bailey Alley' AND [TestSubject]='Algebra'. This way we set up a filter: last name with letters starting from 'Se' to 'Z', the address is 105 Bailey Alley and the test name (subject) is Algebra.

Using Brackets in Huge Filter Structures

To select (point) field groups or logical blocks you can use brackets.

For example, (([LastName]>='K' AND [LastName]<'l') and [eduestablishment]='leibnitz university') or ([teacher]='steve p. peterson' and [mark]>=4) means that either the student's last name must start with 'K' letter and he/she must be from Leibnitz University or the student's teacher (trainer) must be Steve P. Peterson and the mark for the test must not be less than 4.

 

See Also:

Report Creation Tool

UniTest System: Report

Home :: News :: Products :: Services :: Support :: Feedback :: About