Creating a view
When you create a new view, ensure all SELECT statements on primary entities in the view retrieve the _secterr column, the _assigneduserid (or equivalent) column, and the _channelid (or equivalent) column for each primary entity referenced in the view. To do this, select the column explicitly or select all columns from the relevant primary entities. If you do not select the columns, an SQL error may occur in the Sage CRM UI when the view is executed.
