Dynamics CRM 数据数量限制更改
1.在CRM2016中如果想要导出超过10000记录数据,更新 MaxRecordsForExportToExcel 这个字段的值。
SELECT MaxRecordsForExportToExcel FROM [XXCRM_MSCRM].[dbo].[OrganizationBase]
2.列表页面,最大显示的数量 5000+,修改 DeploymentProperties表中 IntColumn字段
select * from [MSCRM_CONFIG].[dbo].[DeploymentProperties] where ColumnName='TotalRecordCountLimit'
3.列表页面,最大显示的每页数量 50,修改 DeploymentProperties表中 IntColumn字段
select * from [MSCRM_CONFIG].[dbo].[DeploymentProperties] where ColumnName='PagingLimit'
4.仪表板中数据量超高50000,显示超出数量限制,修改 DeploymentProperties表中 IntColumn字段
select * from [MSCRM_CONFIG].[dbo].[DeploymentProperties] where ColumnName='AggregateQueryRecordLimit'
5.仪表板 最多6个限制, DashboardMaximumControlsLimit
select * from [MSCRM_CONFIG].[dbo].[DeploymentProperties] where ColumnName='DashboardMaximumControlsLimit'