Real-time view-based reporting metadata

A computerized method comprising:

• accessing a database to obtain reporting metadata, the reporting metadata including metadata of a first metadata type, metadata of a second metadata type, and metadata of a third metadata type, the first metadata type being of a type that is updated by the application less frequently than the second metadata type is updated by the application, the second metadata type being of a type that is updated less frequently by the application than the third metadata type is updated by the application, the third metadata type including instance-specific reporting metadata;
• based on a determination that a first portion of the reporting data is of the first metadata type, persisting the first portion in a memory;
• based on a determination that a third portion of the reporting data is of the third metadata type, not persisting the third portion of the reporting data;
• receiving a request from a graphical user interface to provide options for inclusion in a custom report template;
• and
• in response to the receiving:
• generating information regarding the instance-specific reporting metadata by executing structured query language (SQL) queries stored in database views for the database, the information regarding the instance-specific reporting metadata preventing inclusion of one or more selectable objects and fields in the custom report template.

A non-transitory machine-readable storage medium comprising instructions, which when implemented by one or more machines, cause the one or more machines to perform operations comprising:

• accessing a database to obtain reporting metadata, the reporting metadata including metadata of a first metadata type, metadata of a second metadata type, and metadata of a third metadata type, the first metadata type being of a type that is updated by the application less frequently than the second metadata type is updated by the application, the second metadata type being of a type that is updated less frequently by the application than the third metadata type is updated by the application, the third metadata type including instance-specific reporting metadata;
• based on a determination that a first portion of the reporting data is of the first metadata type, persisting the first portion in a memory;
• based on a determination that a third portion of the reporting data is of the third metadata type, not persisting the third portion of the reporting data;
• receiving a request from a graphical user interface to provide options for inclusion in a custom report template;
• and
• in response to the receiving:
• generating information regarding the instance-specific reporting metadata by executing structured query language (SQL) queries stored in database views for the database, the information regarding the instance-specific reporting metadata preventing inclusion of one or more selectable objects and fields in the custom report template.