Modify the Maximum Calculated Columns in a Query
Scenario/Problem: You need to modify the maximum amount of calculated columns in a query.
Solution: Use the OutputCalculatedColumnsMax
parameter with the Set-SPAccessServiceApplication
cmdlet.
The OutputCalculatedColumnsMax
parameter has a default value of 10
and determines the maximum number of calculated columns that can be contained in the output of a query. This value does not include any calculated columns that are part of SharePoint lists. The valid range of values for this parameter is 0
to 32
. Listing 23.4 shows a sample modification of the maximum number of calculated columns.
Set-SPAccessServiceApplication -Identity "Access Services" ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.