Izenda Database Behaviors¶
Instead of physically removing rows, Izenda will set the Deleted flag on
them to preserve historical data. Therefore, normal-case queries should
always include a
Deleted = 0 condition.
Report Relationship Data¶
Each report uses its own set of relationships. Report creators are free to modify or remove the default relationships suggested from Data Model or create new ones. Therefore, IzendaRelationship table stores both Data Model relationships (without a ReportId) and Report-specific relationships (with a value in ReportId). Report-specific relationships will also be deleted along with the report.
- First row is a Data Model relationship.
- Second row is a Report relationship with value in ReportId, and copied from the Data Model relationship above.
Dashboard Filter Data¶
Dashboard part can use a different filter value than the specified value in the included report part. Therefore, dashboard part filter data is stored in the separate table IzendaDashboardPartFilterField, with the default values copied from report filter data in Izenda(ReportPart)FilterField.
Subscription Filter Data¶
Specific subscriptions can also choose to use a different filter value than the one in report/dashboard. Therefore, subscription filter data is also stored in a separate table IzendaSubscriptionFilterField.
History tables are used to keep previous versions of the data in a separate place, for specific Izenda features:
to display in View Report History in Report List.
to validate against new passwords following System Configuration/Security Policies.
Normal tables only retain deleted data for a short time before archiving, and do not keep updated data. Hence, there should be no attempt to read history information from them.