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
Filtering on property names and values are not case sensitive.
If you want to search for a part of a property's value, then you can use the wildcard character
% for that.
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(Timestamp) = "2020"
The same applies when you want to filter for a specific month, or day. Use
For the time part you can use the following methods:
You can combine these filters. For example, to filter for a specific MONTH in a specific YEAR.