Fork me on GitHub
Phraseanet Documentation

All the search operators available in Phraseanet

Here is the list of the different search operators available in Phraseanet.

Boolean operators

The conjunction operator AND

Used by default, it is not mandatory to type it. The operator AND displays the media that contains all the typed terms in their descriptive note.

The disjunction operator OR

It allows to search for several terms in the media notes. If the search is sweet OR sour the descriptive sheets of the media will contain either the word sweet, or the word sour, or both.

The negation operator NOT

It allows to exclude terms from the search.

The common operators ALL and LAST

  • all: to search all the documents in the selected Phraseanet bases and collections.
  • last (with no specific number) displays by default the last 12 documents added in the Phraseanet base.

The operator last is valid per opened Phraseanet bases and collections.

The substitution operators

The wildcard *

The truncation character *, used on the right of a string allows to search descriptive notes that contains terms starting with the characters before the asterisks.

The replacement character ?

A character can be replaced by ?. So, the search wo?ds displays the media which descriptive notes contains terms like words or woods.

The proximity operators

The operator NEAR

It allows to fetch all the media in which the result of the term 1 is at a specific distance (n) of the term 2.

For example, (Eiffel NEAR 2 Tower) will select all the records in which there is a maximum distance of 2 words between Eiffel and Tower.

Note

If no distance is specified, the PRES operator is handled like a boolean operator AND.

The operator BEFORE

It allows to fetch all the records in which the result of the term 1 is before the term 2 at a specified distance (n). For example, (Eiffel BEFORE Tower) will select all the records in which the term Eiffel is located, at max, two words before the word Tower.

Note

It is not mandatory to specify a distance. If the distance is not specified, the default value is 12.

The operator AFTER

It allows to fetch all the records in which the result of term 1 is after the term 2 at a specified distance (n). For example, (Tower AFTER 2 Eiffel) will select all the records in which the word Tower is located, at max, two words after the word Eiffel.

Note

If the distance is not specified, the default value is 12.

Warning

For all the operators stated earlier, using double quotes on the operator will cancel its function.

Numerical comparisons

It is possible to select documents comparing dates and numbers, for fields typed as Date or Number. So, the search date > 14/07/2014 displays media that have a field name date containing a date before the 14th of July 2014.

The comparison operators are : >, <, =, <=, >=, between (the limits are included).

The days (DD), months(MM), years (YYYY) can be staggered or separated with a slash /, a dash -, a space.

  • Search on one day: DD/MM/YYYY, YYYYMMDD, DD/MM/YY, YYYY/MM/DD, DD-MM-YYYY, YY-MM-DD
  • Search on one month: MM/YY, YYYY/MM, YYYYMM, MM/YYYY
  • Search on one year: YYYY

The dates fields type is strict. The user can prefer to search using an advanced search window.