Enable and Disable the Use of Outer Joins
Scenario/Problem: You need to enable or disable the use of outer joins within queries.
Solution: Use the OuterJoinsAllowed
switch parameter with the Set-SPAccessServiceApplication
cmdlet.
By default, the Access Services service application is configured to allow outer joins within queries. Because OuterJoinsAllowed
is a switch parameter, you can use it with a $false
setting to disable outer joins, as shown in Listing 23.9.
Set-SPAccessServiceApplication -Identity "Access Services"-OuterJoinsAllowed:$false
You can use -OuterJoinsAllowed
by itself to enable this setting or with a $true
value, as shown in Listing 23.10.
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.