Deleted records for report

[Jacobb]

Hello,
i would like to know if it's possible to make a report with deleted records.
I'm trying to create a report of deleted reports based on when they were deleted but the field deleted is not accessibile throough the report options nor through a complex expression.
Any form of help would be greatly appreciated.
Thanks.

[Vadym]

Hi Jacobb,

Unfortunately, there is no possibility to create a report for Report as it's a system entity.
As a workaround, you can check Report table records IDs with the deleted = 1 value by using phpMyAdmin, for example.

[Jacobb]

Thank you, for the response but i'm trying to create a report not on deleted reports rather a report for other deleted records of our own custom/standard entites.
Is that possible or we would just have to access them through the database by using for example phpMyAdmin as you suggested.
Thank you for the assistence.

[Jacobb]

Hello @Vadym,
as explained in the comment the report I'm trying to create will be based on deleted records of other entities for example Users.
I would like to make a report that shows how many records of an entity (eg. Users) were deleted in each month of the year.
Thank you.

[Vadym]

Hi Jacobb,

Thanks for the clarification.
You can implement the following solution by using Workflows from Advanced Pack and Formula Script: when a User is deleted, a custom entity record (Deleted Users) will be created with the specified fields. Please see screenshots below for a better understanding.

1. Custom entity and additional fields creation/adjusting by using the Entity Manager/Layout manager.

[Vadym]

2. Workflow and Formula Before Save Custom Script.



3. Result after users deleting.



Please note that records will be created for deleted users after the solution implementing only.
If you have any additional questions, please let me know.

[Jacobb]

Hi Vadym,
thank you so much for the solution.