Which fields does the Pre-Processing Filter consider when it?s being used in a report?
2 years ago
Originally Published: 2009-09-30
Article Number
000041783
Applies To
All Versions of enVision

Resolution

Preprocess filtering improves the performance of reporting by reducing the amount of event data enVision transfers into an SQL database which in turn reduces the time that the report takes to complete.

 

It will consider any fields, The process will build up a regex string based on the WHERE clause criteria in the report. 

 

If it passes and meets certain rules, then the regex string will be applied to the parsed data before the data is added to the return buffer.

 

If it doesn?t meet the rules it will be dropped.

 

The following are the "rules" that it must meet:

 

  1. All values in the where criteria are using =, like, or IN
  2. Values must be more than a single character

 

 If any NOT variations are used, the regex string will be ignored and report data will be returned without using it.