Search
The media list can be filtered and ordered by the search input on the nav bar in list mode. A search term is tested by default agains a space separated basic text of id prefix, media type, filename, date, camara vendor, camara model, geo names, tags and objects. The search test is case insensitive.
By default each space separated word is a search term and all search term must be a part of the basic text. A search term with a white space must be escaped by single or double quotations. So the input of san francisco is treaded as san and francisco while "san francisco" is treaded as complete name with whitespace.
Search terms can be combined with boolean operands of not, and, or and parenthesis. Search terms of not, and and or must be escaped by quotations. Advance search terms like explicit tag search or aspect ratio comparison are listed below.
Date format is currenty in ISO 8601 format: YYYY-DD-MM'T'hh:mm:ss like 2020-09-23T08:24:54
Search Examples
berlin
Search for filename, address or tag containing search term berlin
berlin tower
Is the same as berlin and tower. Search for filename, address or tag
containing search term berlin and term tower
city:berlin or tower
Search for images in the city berlin or having tower in filename, address or tag
city:berlin not tower
Search for images in the city berlin and not haveing tower in filename, address or tag
tags in (vacation, family)
Search for all images with tags vacation or family
tags all in (vacation, family)
Search for all images with tags vacation and family
type:video year in [2015:2020] order by duration
Is the same as type:video and year in [2015:2020]. Search all media
type of video within the years between 2015 and 2020 with longest
video first.
ratio:landscape
Lists all media in landscape orientation
not exists(geo)
Lists all images whithout geo information via latitude or longitude
order by count(faces)
Lists all images with detected faces, most faces first
Query BNF
The query language follows following backus naur form.
? is optional. | is an alternative
Query
: Terms OrderBy? | OrderBy
Terms
: Term Terms?
Term
: Term `or` Term | Term `and` Term | `not` Term | `(` Terms `)` |
Expression
Expression
: KeyValueExpression | CmpExpression | CountFnExpression |
ExistsFnExpression | ListExpression | RangeExpression | Value
KeyValueExpression
: Identifier `:` Value
CmpExpression
: Identifier Operand Value
CountFnExpression
: `count(` Identifier `)` Operand Value
ExistsFnExpression
: `exists(` Identifier `)`
ListExpression
: Identifier `in (` Values `)` | Identifier `all in (` Values `)`
RangeExpression
: Identifier `in [` Value `:` Value `]`
Operand
: `=` | `<` | `<=` | `>` | `>=` | `!=` | `~`
Values
: Value Values?
Value
: "double quoted value" | 'single quoted value' | *text or number*
Identifier
: text
OrderBy
: `order by` OrderExpression OrderDirection?
OrderExpression
: see order expressions below below
OrderDirection
: 'asc' | 'desc'Operands
Following operands are used for comparison
| Operands | Descriptions |
|---|---|
: | Key value, in most cases it is an alias for = |
= | Equal to case sensitive in some cases |
< | Smaller to for numeric values |
<= | Smaller or equal to for numeric values |
>= | Greater or equal to for numeric values |
> | Greater to for numeric values |
!= | not equal |
~ | contains case insensitive |
count(key) | Counts elements of a list |
exists(key) | Check if elements exists |
- Number operands:
:,=,<,<=,>,>=,!=,in [from:to] - Text operands:
:,=,!=,~ - List operands:
in (value, ...),all in (value, ...)
Advance Search Terms
| Term (alias) | Operands | Value type | Examples |
|---|---|---|---|
id | text operands | text | id~a52f8e |
type | :, =, != | text | type:image, type != video, type=rawImage |
index | text operands | text | index:Pictures |
file | text operands | text | file~101Canon/IMG_1234 |
filename | text operands | text | filename~IMG_1234 |
path | text operands | text | path~101Canon |
ext | text operands | text | ext:xmp |
filesize | number operands | number/text | filesize >= 1024, filesize > 2MB |
width | number operands | number | width >= 1980 |
height | number operands | number | height < 3000 |
ratio | number operands | number | ratio > 2 |
ratio | : = | text | ratio:panorama, ratio:landscape, ratio:square, ratio:portrait |
duration | number operands | number | duration > 60, duration in [120:360] |
year (y) | number operands | number | year:2000, y >= 2020, y in [2010 : 2020] |
month (m) | number operands | number | month != 12, m in [1 : 6] |
day (d) | number operands | number | day = 3, d in [4 : 10] |
hour (H) | number operands | number | hour > 6, H in [9 : 17] |
minute (M) | number operands | number | minute = 4, M in [0 : 30] |
make | text operands | text | make:canon, make ~ niko |
model | text operands | text | model:m50, model ~ A22 |
location | text operands | text | location:germany, location ~ thai |
country | text operands | text | location:germany, location ~ thai |
state | text operands | text | state != florida, state ~ fornia |
city | text operands | text | city = rome, city ~ stock |
road (street) | text operands | text | road:main, street ~ way |
longitude (lon) | number operands | number | lon > 0 |
latitude (lat) | number operands | number | latitude < -20 |
tag | text operands | text | tag:vacation, tag != 'san francisco' |
tags | list operands | list | tag in (vacation, winter) |
object | text operands | text | object:couch |
exists(make) | exists(make) | ||
exists(model) | exists(model) | ||
exists(location) | exists(location) | ||
exists(country) | exists(country) | ||
exists(state) | exists(state) | ||
exists(city) | exists(city) | ||
exists(road) (exists(street)) | exists(road) | ||
exists(geo) | exists(geo) | ||
exists(tags) | exists(tags) | ||
exists(objects) | exists(objects) | ||
exists(faces) | exists(faces) | ||
count(files) | number operands | number | count(files) = 1 |
count(tags) | number operands | number | count(tags) > 1 |
count(objects) | number operands | number | count(objects) = 0 |
count(faces) | number operands | number | count(faces) = 0 |
Order Expressions
The search result can be ordered by following expressions
| Expression | Example |
|---|---|
date | Default order by date desc, newest first |
updated | Order by file updates |
random | Order randomly |
duration | Order by video duration |
width | Order by image width |
height | Order by image heigt |
filesize | Order by the largest file |
count(files) | Number of files |
count(tags) | Order by detected faces |
count(faces) | Order by detected faces |
count(objects) | Order by detected objects |
: Order expressions