PowerShell™ for SharePoint® 2013 How-To

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.

Listing 23.9. Disabling Outer Joins in Queries

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.

Listing 23.10. Enabling Outer Joins ...