Posted: 6 Mar 2018 14:28 EST Last activity: 3 Apr 2018 9:14 EDT
Elastic Search alternative to exposing properties for reporting
Has anyone tried passing report definitions into pxRetrieveSearchData to query against Elastic Search, as opposed to the usual exposing of db columns for reporting? This would be for the purpose of avoiding exposing columns and the potential performance issues once too many columns need exposed to meet customer needs. Just trying to see if I'm in new territory here, or if this 'wheel' has already been created and proven out.
***Edited by Moderator Marissa to add SR Details***
V7 search API (pxRetrieveSearchData) requires class and report definition name as a parameter.
List fields that are defined in report definition are returned in search results and Filters that are defined in report definition are appended to search filters.
BTW, it only works with List report(Summary/rank/etc is not supported)
Also in customer's case, they will have to create or update data transform/data instance pySearchModel to include properties that they want to retrieve in search results(retrieval of standard properties is by default supported). Any changes to pySearchModel requires full re-indexing of given class.
Last but not the least assuming customer has work class, indexing should be enabled on work class for search to work.