This fuSeQL Reference is
helpful
when using the FUSE Search
API to write a query. "Series" refers to data
stored in FUSE.
| Syntax | Example | Notes |
|---|---|---|
set=<field_name> | set=country | Finds series where the field is
set (i.e. has a value).
Useful in
finding problematic series (e.g. not
set:country would
find series
where the country is missing,
which might be indicative of
an
issue). |
AND | Japan AND
Weather | Requires both terms; this is the
default operation when two terms
are next to each other, so is
always optional. |
OR | Japan OR
Weather | Checks for the presence of either
term. |
NOT | Japan AND NOT
Weather | Negates the term immediately
following. |
( ) | (Japan OR Weather) AND NOT
Celsius | Enforces a specific order in
expressions, standard logic use of
the ( ). |
" " | "Japan Weather" OR "My
Weather" | Finds text phrases. Note that this
is required if the value to find
includes spaces or any of the
following characters: ~><*(),:=@. |
* | (Ja OR "South A")****
Weather | Finds values that start with Ja or South
A, so it would find
weather in Japan, Jamaica, South
America, and South Africa. Note
that for quoted terms, the ***** immediately
follows the
quotes. |
= | country=Japan OR
country="South
Africa" | Finds series that have exactly Japan or South
Africa as the
country. Note the usage of the
quotes around South Africa because
it has a space. |
=( ) | country=(Japan,"South
Africa") | Finds the exact same as above more
conveniently. Values within the
parenthesis, separated by commas
cannot have spaces in
between. |
: | country:South | Finds South anywhere
in the country field. South Africa and South
Korea would
be found. |
sid: or _tree: | sid:jodi\primary or my_tree:my\category | Finds series where the
series id (sid) begins with jodi\primary or where
values of
the my_tree field
begin with my\category |
< > or =<
>= | forecast_date>2015-01-01 or some_num<=10 | Finds based on a value range. Most
frequently used with _num and _date fields. |
( )^ | set:country OR
(set:city)^10 | Finds series where either the country or city are set, but
boosts series where city is set by 10. The series where city is set
shows up first. |
<optional_prefix>*:(<field
value>) | *:(gas) or p*:(gas) | Wildcard field searching. Searches ALL fields (with <optional_prefix>)
for a
particular value.Returns any
series where value is present in any field, not just default fields
— default fields are
defined/referenced in various
places in the API
documentation). Note: must be the last part
of a query. |
<field
value> | gas | Search default
fields only. Default fields are
defined/referenced in various
places in the API
documentation. To search all fields, use
the wildcard example immediately
above. |