Issue with Multiple Values in Process Report Affecting Active Process ID Query

Hi everyone,

We have configured a process report to retrieve all active processes.

Additionally, we have a query to obtain the active process ID for each case based on the Case ID.

However, we are encountering an issue where multiple values are appearing in the column of the process report (mapped pv value for column in process report). As a result, some of the active process IDs are not being queried correctly.

Could someone please help us understand why multiple values are appearing in the process report? Is it because the process report contains the value changes from the process history?