Entity State Change History

Unknown

Entity State Change History

Unknown

I am looking to create a Report which displays the state change history of an Entity. Can you let me know how I can achieve this?

Unknown

[color=rgb(34, 34, 34)][font=georgia, serif]You can use the [/font][/color][b]Folder State[/b][color=rgb(34, 34, 34)][font=georgia, serif] as the Report Data Source through [/font][/color][b]Common → All Entities Datasource. [/b][color=rgb(34, 34, 34)][font=georgia, serif]This will return[/font][/color][b] [/b][color=rgb(34, 34, 34)][font=georgia, serif]all records about the various Folder States.[/font][/color]
[color=rgb(34, 34, 34)][font=georgia, serif]
[/font][/color]
[img]https://i.imgur.com/IjAHdCH.png[/img]

Unknown

Is it possible to return my Entities data in this Report?

Unknown

[color=rgb(34, 34, 34)]Please find attached Project showing how to achieve this. [/color]
[color=rgb(34, 34, 34)]
[/color][color=rgb(34, 34, 34)]I built this by creating Table Relationships between entity_folder and my Flow Extension (on the extension_id field) as well as between entity_folder and folder_state (on folder_id and entity_folder_id field respectively) and then using them in the Report. [/color]

For more information on Table Relationships, please refer https://documentation.decisions.com/docs/creating-database-table-relationships.
[i]edited by kshitij@decisions.com on 3/20/2019[/i]