Option Description
has in it Only data which contains the number or text entered in the Value field will be included in the report. For example:
Card Number has in it 13 means that only card numbers
containing 13 will be included in the report, for example, 13, 130, 131, 132, 113, 213, 313, 1130, 1131, 2131, etc.
User Name has in it ins means only cardholders whose names contain the text ‘ins’ will be included in the report, for example, Hawkins, Tomkins, Tomkinson, Instow.
same as Only data that matches what is typed in the Value field will appear in the report. For example:
Card Number same as 113 means that only card number 113 will be included in the report.
User Name same as Hawkins means that only cardholders called Hawkins will be included in the report.
not same as Only data that does not match that typed in the Value field will appear in the report. For example:
Card Number not same as 113 means that card number 113 will not be included in the report.
User Name not same as Hawkins means that cardholders called Hawkins will not be included in the report.
after Only data of a greater number, or later in the alphabet, than that entered in the Value field will appear in the report. For example:
Card Number after 113 means that only card numbers 114 and above will be included in the report.
User Name after Hawkins means that only cardholders that appear alphabetically after Hawkins will be included in the report.
Option Description
before Only data of a smaller number, or earlier in the alphabet, than that entered in the Value field will be included in the report. For example:
Card Number before 113 means that only card numbers 112 and below will be included in the report.
User Name before Hawkins means that only cardholders that appear alphabetically before Hawkins will be included in the report.
same as or after Only data of the same or a greater number, or the same or later in the alphabet, than that entered in the Value field will appear in the report. For example:
Card Number same as or after 113 means that only card numbers 113 and above will be included in the report.
User Name same as or after Hawkins means that only
cardholders called Hawkins or that appear alphabetically after Hawkins will be included in the report
same as or before Only data of the same or a smaller number, or the same or earlier in the alphabet, than that entered in the Value field will appear in the report. For example:
Card Number same as or before 113 means that only card numbers 113 and below will be included in the report.
User Name same as or before Hawkins means that only
cardholders called Hawkins or that appear alphabetically before Hawkins will be included in the report.
is null Only null data fields are returned. For example:
User Name is null means only records where the user name field has no content will be included in the report.
is not null Only data fields that are not null are returned. For example:
User Name is not null means that records where the user name field contains anything at all will be included in the report.
Date
Option Description
of Only activity occurring on the date typed in the Value field will be included in the report. For example:
Date of 11/6/2009 means that only activity occurring on 11th June 2009 will be included in the report.
Date of today means that only today’s activity will be included in the report.
Date of yesterday means that only yesterday’s activity will be included in the report.
not of Only activity not occurring on the date typed in the Value field will be included in the report. For example:
Date not of 11/6/2009 means that only activity which didn’t happen on 11th June 2009will be included in the report.
after Only activity occurring after the date typed in the Value field will be included in the report. For example:
Date after 11/6/2009 means that only activity after 11th June 2009 will be included in the report.
before Only activity occurring before the date typed in the Value field will be included in the report. For example:
Date before 11/6/2009 means that only activity before 11th June 2009 will be included in the report.
of and after Only activity occurring on or after the date typed in the Value field will be included in the report. For example:
Date of and after 11/6/2009 means that only activity on and after 11th June 2009 will be included in the report.
of and before Only activity occurring on or before the date typed in the Value field will be included in the report. For example:
Date of and before 11/6/2009 means that only activity occurring on or before 11th June 2009 will be included in the report.
is null Only null data fields are returned. For example:
Date is null means only records where the date field has no content will be included in the report.
is not null Only data fields that are not null are returned. For example:
Date is not null means that records where the date field contains anything at all will be included in the report.
Time
The filter operators for time are the same as those for Text and Number. The JANUS system uses a 24 hour clock format, therefore all times should be entered accordingly.
For example, 3:15 pm should be entered as 15:15. Times before 10 am must be entered with a leading zero for the hours. (i.e. 07:30 for 7:30 am). If the leading zero is left out the system will not find the appropriate records.
All separators between hours and minutes or between minutes and seconds must be a colon (:) with no additional spaces. The use of seconds is optional.