ITACAT Search

 

 

Legenda for Evaluation Field Legenda for Kind (C.E.) Field
INS. Insufficient Information 0 Close Encounter with No Effect
UNR Unreliable Information 1 Close Encounter with Temporary Effects
POSS. Possible Explanation 2 Close Encounter with Permanent Effects
PROB. Probable Explanation 3 Close Encounter with "Occupants"
IDEN. Identified Event 4 Abduction - Direct Contact

 

QUERY WIZARD DO-IT-BY-YOURSELF WIZARD
Select a Field

FIELDS:
  • date
  • time
  • location
  • province
  • kind
  • evaluation

OPERATORS:

  • <
  • >
  • <=
  • LIKE
  • =
  • <>
  • >=
  • CLIKE (case-insensitive LIKE)

WILDCARDS:

'%' = undefined number of characters
'_' = a single character

You may define your own Search String simply taking note of the available Fields, Operators and Wildcards listed on the left.

Beside that, please also remember two simple points:

1) DATE has been recorded in the following format: yymmdd (ex.: 970101 is for January 1st, 1997).

2) TIME has been recorded in the following format: hhmm (ex.: 2330 is for 11.30 pm)
Operator

Value

The correct syntax for the Query String is as follows:
(please note the use of the character ' instead of ")

field-name operator value

Example:

date > '800000'
(means all cases after January 1st, 1980)

kind = '3'
(menas all cases labelled as Close Encounters of the Third Kind)

 
Condition

NONE AND OR
Select Second Field

Using Wildcards.

Using Wildcards.
Remember to make use of operators Like and CLike only.

Example:

date like '7%'
(means all cases taken place during the seventies)

date like '5410__'
(means all cases taken places in October 1954)

 More advanced Searches may be achieved by Conditions (And / Or). Syntax:

field-name operator value and field-name operator value

Example:

date > '500000' and date < '600000'
(means all cases after January 1st, 1950 but before January 1st, 1960)

province = 'MI' or province='RM'
(means all cases taken places in the provinces of Milano and Roma)
Second Operator

Second Value

Write here on right your Search String

       
 

 

 


BACK TO THE HOME PAGE
TORNA ALLA PAGINA INIZIALE
/strong>' = undefined number of characters
'_' = a single cha