1.在CRM2016中如果想要导出超过10000记录数据,更新 MaxRecordsForExportToExcel  这个字段的值。

SELECT MaxRecordsForExportToExcel FROM [FCCRM_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'
05-27 08:24