Synatic

Click the Filter &gt; button to filter the buffer data and view only selected values using the Query Builder.

___________________________________________________________

This tab enables you to build a filter query to:

View the data in a list that matches the selected criteria.

- View the data in a list that matches the selected criteria.
- Interrogate and debug the data.
- Search the data.

The Query Builder uses the following criteria to set up the filter.

Boolean logic to apply logical filter operations. • Select an appropriate operator from <code>AND, OR, NOT</code>.

Rules to apply comparative operators to return records with specified data values. • Select a data field, an operator, the value, and the data type in each line. • To add more rules, click the Add Rule or Add Group buttons.

Field tags to only display specified columns. • Click on Add a tag, then type in the column name.

Sort fields to list the data in a specific order using the Order By operator. • Click the + icon to add key index fields using the <a href="https://docs.mongodb.com/manual/reference/mongodb-extended-json/" rel="nofollow noopener noreferrer" target="_blank">MongoDB Extended JSON specification</a>.

Skip is used to omit the first <code>n</code> number of records as specified. • As an example, enter 5 into the input to omit the first five records.

Click the Query Values text button to execute the query and list the result below.

- Boolean logic to apply logical filter operations. • Select an appropriate operator from <code>AND, OR, NOT</code>.
- Rules to apply comparative operators to return records with specified data values. • Select a data field, an operator, the value, and the data type in each line. • To add more rules, click the Add Rule or Add Group buttons.
- Field tags to only display specified columns. • Click on Add a tag, then type in the column name.
- Sort fields to list the data in a specific order using the Order By operator. • Click the + icon to add key index fields using the <a href="https://docs.mongodb.com/manual/reference/mongodb-extended-json/" rel="nofollow noopener noreferrer" target="_blank">MongoDB Extended JSON specification</a>. 
- Skip is used to omit the first <code>n</code> number of records as specified. • As an example, enter 5 into the input to omit the first five records.
- Click the Query Values text button to execute the query and list the result below.

The Raw Query option lets you examine the filter query with the comparative operators displayed in MongoDB Query Language.

Revisit the <a href="http://help.synatic.com/en/collections/2416458-getting-started">Getting Started</a> page for a refresher.

Read more about <a href="http://help.synatic.com/en/articles/4170597-flows">Flows</a>.

Read more about <a href="http://help.synatic.com/en/collections/2698551-buffers">Buffers</a>.

&lt; <a href="http://help.synatic.com/en/articles/4757607-managing-buffer-values">Managing Buffer Values</a>

Filter Tab

Query Builder tab

Raw Query

Useful Tutorials