The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or can't be done in Reports, Marketing Groups, Lists, etc.

There have been discussions of calculated and derived views

• Adding Derived Fields in Views into Meta Data
• Custom_Edits and Derived Fields Created in Views
• But I really, really need to see the actual oppo_opportunityid displayed!
• Reports and Graphs using Key Attribute Data
• HTML in the database

And we have discussed the columns that have to be included in the SQL of a view

• Sage CRM and Security Territories

Building Views that Connect to External Databases has been written about.

• Building Cross Database Views for Reporting
• Database Case-Sensitivity and Connecting to an External Case Sensitive Database

The exposure of views to web services has been discussed

• Using Joins in Web Services

The relationship of views with other meta data, and the impact that changes to meta data may have on the recreation of views has been discussed in these articles.

• Adding Fields, Deleting Fields, Views, vSentinel and SQL Errors
• You may need to recreate views manually