Data Queries

Many panes have a Query Line. This field provides a simple yet very powerful way to search for and display data matching some criteria. For example, you can easily:

It is a very flexible search system. Once entered, queries can be saved to a Filter Pane for instant recall with a mouse click.

Searching through All Data Columns

The simpliest thing you can do with the query line is type a few characters into it. For example, typing "River" will find all lines which contain that text in any column. It is a fast way to search through your GPS tracks (or in other panes, searching for views, predefined queries, or data points).

You can also type a Perl-style regular expression to search for that expression through all columns.

Comparing Values

It is often useful to search for tracks meeting a certain criteria, such as being longer than 10 miles, or having more than 1 hour of moving time.

Typing the name of a field (as displayed in the headers, with underscores replacing spaces) allows the use of comparison operations. To avoid colliding with regular expressions, the operators must be preceded or followed by a space. Examples:

The complete set of comparison operators is:

Op

Meaning

=~ or : or ~

Matches value as a regular expression

!~

Matches text not containing a regular expression

==

Exact equality

!=

Not equal

<

Less than

<=

Less than or equal

>

Greater than

>=

Greater than or equal

Boolean Operators

In decreasing precidence order, queries support !, ^, &, and |, for boolean operations. Parentheses can be used to overrule the normal operator precedence.

Op

Meaning

!

Logical negation

& or &&

And

| or ||

Inclusive Or

^

Exclusive Or

For example, to find all tracks over 10 miles in length or which ascend over 500 ft, AND have the Hike tag:

As with comparison operators, booleans and parentheses must be preceded or followed by a space, to avoid colliding with use of the same character in a regular expression.

Completion

The text entry field for queries provides a completion facility. The completer will suggest column names and unit suffixes.