All system components for data viewing and editing have special tools for search. Two types of search are possible: quick category search and advanced (detailed) search using the search line.

The quick category search is performed in the category tree. The tree contains user-added categories and a number of standard ones. The search is performed by selecting a category (by the check box). Only items of this category will be displayed. "Standard" categories are:

• New items. The folder 'New' contains 3 categories, which enable quick search of items added to the collection during the last day, week and month. Using them, you can easily answer your friend's question: "And what are the latest receipts?"
• Debtors. The folder 'Debtors' contains all "active debtors", i.e. those people who owe you something at present. Selecting the whole group or a separate debtor helps to find out quickly which items you have lent, that is, to see what items are missing in the collection at present.

Detailed search is a search by the search line of a special format. The line is similar to WHERE of SQL condition, if this notion means something to you. For the detailed search you should enter a search line and click on the button 'Search'. To cancel the search, delete the line and click on the button 'Search' again. Examples of search lines:

• "name LIKE 'C++'" - to find all items having 'C++' in the name;
• "genre = "comedy" AND description LIKE 'funny'" - to find all comedies whose descriptions contain the word "funny".

Thus, a search line is a combination of conditions used for item fields. The field is identified by its name and may not be present in all classes of objects. The field and the field name, like all other constants, act as operands. Field names and operands are not case sensitive. The following keywords (symbols) can be used as conditions of the search operation:

• = - comparing operands at the left and at the right side of the symbol for exact match condition.
  Syntax:
  (operand1) = (operand2)
  Example:
  Label = Metallica
• <,>,<=,>= - arithmetic comparison.
  Syntax:
  (operand1) symbol (operand2)
  Example:
  Ratio >= 4
• LIKE - examination of the field value which name is written at the left in order to discover presence of the piece of data positioned at the right.
  Syntax:
  (operand1) LIKE (operand2)
  Example:
  name LIKE 'C++'
• IN - search for the coincidence of field value which name is written at the left with a value from the list.
  Syntax:
  (operand1) IN (operand2,[operand2],..,[operandN])
  Example:
  Type IN ('DVD','CD')
• OR - this command combines two conditions (logical OR). A record will be in the search result, if it satisfies at least one of the conditions.
  Syntax:
  (operand1) OR (operand2)
  Example:
  Label = Metallica OR Label = Scorpions
• AND - intersection of two conditions (logical AND). A record will be in the search result, if it satisfies both conditions.
  Syntax:
  (operand1) AND (operand2)
  Example:
  Type = CD AND Name = Load
• NOT or ! - negation (inversion). A record will be in the search result, if it doesn't satisfy the search condition. Note that both identical recording forms of the command ('NOT' and '!') can be used.
  Syntax:
  NOT (operand1) OR ! (operand1)
  Example:
  NOT (Label = Metallica) OR ! (Label = Metallica)

Here we described common search rules. User interfaces are separately described in detail for each system: SIce/SIWinViewer.

---

Tweet