Elastic Search With JReport

Hello People,

I am trying to connect Elastic Search with JReport, JReport is a BI tool for analytics.
I want to do grouping on a particular field and get count of it.
Below is the SQL counterpart of it,
SELECT CUSTOMER_CODE,COUNT(TRANSACTION_REFERENCE_NO) FROM AXIA_REC_TXNS_METADATA_MST GROUP BY CUSTOMER_CODE ORDER BY 2 DESC.

How can i achieve same in elastic search?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.