About Views

Views are customised viewpoints of database data. Included within this section is a list of the views that autologyx offer as part of the Data and Analytics connector component.

We provide an explanation of each view together with examples of useful SQL scripts for each that can be used to present the information in a different way.

We provide a few basic and commonly requested views for convenience, but in the main customers would use SQL to create their own queries (which might be saved as their own views) using JOIN statements against the various tables to get the data they want. 

For example then, say you wanted to produce a table that related  a latest criteria response against SLA  completion time and Target group. No such table or view exists, but the query could be created by recursively joining history_log table against criteria_state.

This can then either be executed directly, or saved as a View (which is just a shortcut to the underlying SQL) by the customer.

A view created in this way (by the customer) will update on demand e.g. every time it is requested, however there is a second type of view called 'materialised' which is used where the underlying data set is very large and can benefit from the trade off between being cached (and consequently slightly out of date) and the pre-compilation that means the view is much faster to load than it would otherwise be.

In ALX, some of the standard views (we provide by default) take advantage of this and you can identify them by the 'm_' prefix on the view.

While this second type of view is not something that a customer can create (it requires development resource as it has to be setup as a scheduled query), in the main its not something that they need to unless their data set is of such a size that it is necessary. Please contact us if this is something you would like help with.