Hello everyone,
I’m trying to export specific details from my monitoring projects and would appreciate some guidance.
For each monitoring project, I want to retrieve only the most recent run, including:
-
Monitoring project name
-
Monitoring project ID
-
Stewardship information
-
Result name
-
Result status
-
Result count -(Passed Count/ Failed Count )
-
Date the run was executed.
I’m currently using a metadata reader to retrieve the monitoring project name, ID, and stewardship, which works as expected. However, when I add fields from the embedded Processing entity and join in the relevant columns, the export returns multiple rows per monitoring project, as it includes historical runs instead of only the latest one.
Has anyone encountered this before? What is the recommended approach to:
-
Filter or identify only the latest Processing run per monitoring project, and
-
Avoid duplicate rows when joining the Processing entity?
