Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When the list is summarized, the value of the COUNT field/Column will show the sum of the line items.  The example Audit Log report illustrates that there are 3 records that match the criteria listed in the columns shown.

...

Logic Options

OR = Bob;Jim;Larry - means the search will only contain: Bob OR Jim OR Larry

NOT = !Bob;Jim;Larry - means search will not contain: Bob but will contain: Jim OR Larry. To omit Bob, Jim, AND Larry, the filter list would be: !Bob;!Jim;!Larry

EXACT Match - Using !! (double exclamation points) - means to look for an exact match, example of a search !!Bob. That will return ONLY account names or data that match exactly that with no surrounding text or symbols (i.e. accounts with a Contact Name containing 'Bobby' would not be returned).

...

Exclude

A check box named ‘Exclude’ now exists on date range and numeric value range filters. Exclude will allow you to filter out things like zero values or a range of values from being returned. ie if you want all non zero transactions, you can use the exclude check box with numeric filters entered as Min: 0 and Max: 0. Prior to this you could only filter out less than or greater than values. Exclude also works on date filters allowing you to exclude a specific date or a date range from the filtered list.

Advanced Sorting Functionality

...