Question
Navy Federal Credit Union
US
Last activity: 12 Sep 2019 16:07 EDT
Range search using in-build Pega elastic search
Elastic search is powerful and super efficient in searching complex case structures.
Is it possible to perform a range query using Pega in-build elastic search params. For e.g. fetch cases that were created between 1/19/2019 and 6/19/2019.
Our typical usage would be : get cases that are of 1) specific case property (like order# which can be multiple in a case) AND 2) created by specific user AND 3) created between a specific date range
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
In Pega 8, there is an option on the Report Definition - Data Access tab that allows you to design complex report definitions and check the box to have the report be fulfilled by elasticsearch instead of by a database query. This can allow you to leverage the efficiency that elasticsearch has with regard to searching complex case structures which would not be especially efficient in an SQL query.