Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Python Connector for SugarCRM Views
| Name | Description |
| ACLActions | Provides reference details for Access Control List (ACL) permissions in SugarCRM. This view lists the specific system actions that can be granted or restricted for user roles to enforce module-level and feature-level access security. |
| Activities | Provides a unified view of interactions such as calls, meetings, tasks, and emails across modules. This view helps users track engagement history and follow-up activity for accounts, contacts, and opportunities. |
| Audit | Provides a change history of audited fields across modules. This view supports compliance tracking, troubleshooting, and record-level change review. |
| DropDownValues | Provides field drop-down option definitions across modules. This view supports UI selection lists and ensures consistent controlled vocabulary values. |
| Relationships | Provides metadata describing how tables and records are related within SugarCRM. This view supports data modeling, dependency mapping, and relational schema analysis. |