Table of Contents

Enhance report performance with new Elasticsearch features (8.2)

New Elasticsearch enhancements improve reporting performance and the reporting and searching experience.

  • Filtering in reports is now case-insensitive. You can turn off case-insensitive filtering, for example, by using an activity. You might want to do this if your index is too big or if the length of time it takes for indexing affects performance.
  • Reports that use string comparison operators in filters can now run queries against Elasticsearch instead of querying the database. The following operators are supported for Elasticsearch queries:
    • Starts with, Ends with, Does not start with, and Does not end with
    • Contains and Does not contain
    • Greater than, Less than, Greater than or equal, and Less than or equal

    In cases where a query cannot be run against Elasticsearch, the query is run against the database, for example, if the query includes a join. To determine if a query was run against Elasticsearch, use the Tracer tool and enable the Query resolution event type.

The following image shows the filters on the Report Definition.

Thumbnail

Report Definition filters

For more information about report filtering, see Editing filter conditions

For more information about tracing events, see Tracer event types to trace.

Suggest Edit

33% found this useful

Have a question? Get answers now.

Visit the Pega Support Community to ask questions, engage in discussions, and help others.