Including transactions disables report record commands

Content

Hi Community!

While working on improving the quality of data and reduce the amount of duplicate information in the system I have found that by joining the tasks table with the transactions table and using data from the transactions I lose the functionality of the report records command, meaning that I'm no longer able to double click on a record to open a task/incident etc.

The goal would be to show when a task was assigned to a specific team (if at all) by showing the timestamp of the relevant transaction rather than creating a custom field for the task and the relevant workspace rules and business rules to capture the action and set the due dates.