Order group (filter)

1. Equal

Compares if two values of the same type are quantitatively the same. It returns only the rows where both values coincide.

How does it work?

This operation needs two arguments:

Argument Format
Value (mandatory) String, integer, float, IP, timestamp, boolean, duration, byte array, geocoord, mac
is equal to (mandatory) The same as the Value format. This can be a set value that you define or it could be another field in the table.

Example

In order to display only those events whose status codes are equal to 200 in the demo.ecommerce.data table, click Filter on the query toolbar and select the Equal operation. The arguments needed are:

  • Value - statusCode column
  • is equal to - 200

After applying the filter, only the rows where the statusCode value is equal to 200 are displayed

2. Greater or equal

Filters those events where a specific value is greater than or equal to another one.

How does it work? 

This operation needs two arguments: 

Argument Format
Value (mandatory) String, integer, float, IP, timestamp, boolean, duration, byte array, geocoord, mac
is greater or equal to (mandatory) The same as the Valuedata type.

Example 

In the demo.ecommerce.data table, suppose you want to view only those events with data transfer times that are 700 or more. Select Filter from the query toolbar, then select Greater or equal as the operation. The arguments needed are: 

  • Value - timeTaken column
  • is greater or equal to - 700

After applying the filter, the query displays only the rows where the timeTaken value is greater than or equal to 700


3. Greater than

Filters those events where one value is greater than either another field of the same data type or a specified value.

How does it work? 

This operation needs two arguments: 

Argument Format
Value (mandatory) String, integer, float, IP, timestamp, boolean, duration, byte array, geocoord, mac
is greater than (mandatory) The same as the Value data type

Example 

In the demo.ecommerce.data table, suppose you want to display only those events where the number of bytes sent is greater than 800. Select Filter from the query toolbar, then select Greater than as the operation. The arguments needed are: 

  • Value - bytesTransferred column
  • is greater than - 800  

 

After applying the filter, the query displays only the rows where the bytesTransferred value is greater than 800


4. Less or equal

Filters those events where one value is less than or equal to another field of the same data type or a specified value.

How does it work?  

This operation needs two arguments:  

Argument Format
Value (mandatory) String, integer, float, IP, timestamp, boolean, duration, byte array, geocoord, mac
is less than or equal to (mandatory) The same as the Value data type

Example 

To display only the status codes that are less than or equal to 400 in the demo.ecommerce.data table, click Filter on the query toolbar, then select Less or equal as the operation. The arguments needed are: 

  • Value - statusCode column
  • is less than or equal to - 400  

 

After applying the filter, only the rows where the the statusCode value is less than or equal to 400 are displayed


5. Less than

Filters those events where one value is less than another.

How does it work?

This operation needs two arguments:  

Argument Format
Value (mandatory) String, integer, float, IP, timestamp, boolean, duration, byte array, geocoord, mac
is less than (mandatory) The same as the Value format

Example 

In the demo.ecommerce.data table, to display only those events that sent fewer than 800 bytes, select Filter on the query toolbar, then select Less than as the operation. The arguments needed are:

  • Value - bytesTransferred column
  • is less than - 800  

 

After applying the filter, only the rows where the bytesTransferred value is less than or equal to 400 are displayed. 


6. Not equal

Filters those events where a specific value is not equal to another one.

How does it work?

This operation needs two arguments:

Argument Format
Value (mandatory) String, integer, float, IP, timestamp, boolean, duration, byte array, geocoord, mac
is not equal to (mandatory) The same as the Value format 

Example

In the demo.ecommerce.data table, to display all rows except those where the status codes is 200, select Filter on the query toolbar, then select Not equal as the operation. The arguments needed are:

  • Value - statusCode column
  • is not equal to - 200  

 

After applying the filter, the query displays only the rows where the statusCode value is not 200. 

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US