Differences

This shows you the differences between two versions of the page.

--- onboarding:reportingmanager:object_model_-_the_basics [2017/05/12 13:36] – mmcc
+++ onboarding:reportingmanager:object_model_-_the_basics [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Object model - the basics ======
+Author: Colm Carew
+===== Main Tables =====
+Script Report (script_report) - This is where the code for the reports is stored. It contains the report name. type (table,line, etc.) the date is was created, the report width and report height.
+Report Variable (report_variable) = This determines what variables a report has
+Scheduled Config (scheduled_config) - This determines if a report will be ran and emailed out at certain date/times
+Reporting Shiro User (reporting_shiro_user) - These are the users within the reporting manager
+Reporting Shiro Role (reporting_shiro_role) - These are the roles within the reporting manager
+**Search for columns in a Database -**
+<code>select column_name, table_name from information_schema.COLUMNS where column_name like'%enable_ems%' order by table_name;</code>
+===== Self Assessment =====
+Using MySQL, generate a query that gets all reports, what variables the report has, if the report is scheduled, who gets emailed for that schedule

Internal Errigal Collaboration Wiki