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'

 



 

posted @ 2019-07-12 15:22  Dynamics365峰  阅读(713)  评论(0编辑  收藏  举报