I am working on building a report based on indexed documents. Following is the scenario of the report:
Status field that contains two types of values (ERROR, OK)
Destination field containing all the destination phone numbers (long data type)
Each destination field has a status either it is Error or OK. In some cases destination numbers have errors but same number also have OK status with different timestamp.
One report is of all the numbers delivered (status OK): done
Second report is all the number that were not delivered i.e number must not have a OK status but ERROR only.
P.S I am newbie in ES.