Hi All,
I have a requirement where I need to display all records based on their state in report. I’ve created a report in a dashboard, but I’m facing an issue where duplicate records are being shown for the same CPU ID.
Table 1: u_cpu_data → stores the list of all CPUs (unique IDs).
Table 2: u_cpu → stores CPU requests/usage records by users.
Each record in u_cpu table has a field u_cpu_id that references the CPU ID record in u_cpu_data.
Since CPUs are reusable, a single CPU ID can appear multiple times in u_cpu table for different users.
As a result, multiple request records exist in u_cpu table for the same CPU ID in different states.
I want the report to show only the latest record or latest state for each CPU ID.
For example, as show in below image:
CPU ID was previously used by User A and is no longer in use, so this record is marked as Closed/Cancelled as seen in below image. Later, the same CPU ID is used by User B, and this record is in NEW state later it will change to In Use state.
In the report, now the same CPU ID will appear under multiple states (Closed, Cancelled, In use, etc.). However, I want to display only the latest record (most recent state) for each CPU ID — that is, the most recent usage status based on the latest created or based on status anything is fine.
Could someone please guide me on how to achieve this?
Thank you.
