ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData Code Assist MCP for SugarCRM ビュー
| 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 dropdown 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. |