How to query the Database using the EPL APPS

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

Hi,

if you open EPL Apps, you can find “Samples” on the the right hand side, including one that is an example to query for events:

Best regards,
Harald

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