February 2013
Intermediate to advanced
304 pages
8h 26m
English
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.
Listing 23.4. Changing the Maximum Number of Columns
Set-SPAccessServiceApplication -Identity "Access Services" ...
Read now
Unlock full access