Filter syntax

InvisionLog supports a powerful, SQL like, filter syntax.


Filtering on properties

If you click on any row in your log window you will then see that you can expand the log details of a row.
This will expose multiple properties the belong to that log record. You can easily filter your log results based on one or more of those properties.

An easy way to get started with this is by expanding one of your log records and click on one of the small icons () that you see infront of the property name. This will add a filter to the input field for you, based on that property and its value.

In the case of the screenshot above, when you click on the LogLevel icon, you would get the following result.

Please note that all values that come after the equals sign (=) MUST be encapsulated in either double or single quotes.


Using AND / OR filter

If you would click on a second filter icon, then the "query" will be automatically expanded by adding an AND to your filter.

It should be no surpise that you can also substitude the AND keyword with an OR keyword.

Filtering on property names and values are not case sensitive.


Wildcard filter

If you want to search for a part of a property's value, then you can use the wildcard character % for that.

For example:

LogLevel LIKE '%some value%'

Dates and time filter

All logs have a Timestamp property that you can use to filter down to a specific period in time.

For example, to find all logs where the Timestamp was greater than "2019-08-20":

Timestamp > "2019-08-20"

To find logs for a specific year simply encapsulate the Timestamp property in a YEAR function:

YEAR(Timestamp) = "2020"

The same applies when you want to filter for a specific month, or day. Use MONTH or DAY respectively.

For the time part you can use the following methods: HOUR, MINUTE and SECOND

You can combine these filters. For example, to filter for a specific MONTH in a specific YEAR.