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 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].
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 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.
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.
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.
Report Creation Tool
UniTest System: Report