What product/components do you use and which version/fix level are you on?
latest
Is your question related to the free trial, or to a production (customer) instance?
production
What are you trying to achieve? Please describe it in detail.
Query the database every hour with logic of groubby statement and count aggregate function.
The event in the DB
{“time”: “2023-02-14T11:00:53+01:00”,
“event_type”: “UDI-Event”,
“child_type”: “Pixpro_Sensor_Visual_MCS-02I502”,
“text”: “Quality test event”,
“lot”: 45627964,
“ref”: 557808,
“producer”: “ETDG”,
“udi-type”: “HIBC”,
“udi-code”: “+ETDG5578083/$45627964/14D20270214/16D20230214Y”,
“quality”: “A”,
“test_status”: “Rejected”,
“reason”: “Wrong code”,
“image_string”: “Simulation! → Picture is not available”,
“location”: “Office”
}
The groupby should happen on the lot and count aggregate function.
How to write this logic in the EPL Apps.
Do you get any error messages? Please provide a full error message screenshot and log file.
Have you installed all the latest fixes for the products and systems you are using?
yes