How to change web application settings via Powershell or SQL?

Question

Third-party tools like SharePoint Manager allow you to change settings on your web application. I need to toggle the LookupDropDownUseStandardControl from TRUE to FALSE, but SharePoint Manager is not working for some reason. I posted this to the SPM site back in December, then reported it as an issue in January. I haven't gotten a response yet, and the business unit needs me to find an alternate way of fixing this issue. The setting was flagged TRUE after an update and broke all of our complex lookup dropdowns.

Is there a way to apply this change via Powershell, or even in the database directly via SQL?

I also have access to Visual Studio, although I'm only an amateur developer at best.

Answer 1

Via PowerShell, this is simple.

$wa = Get-SPWebApplication https://webAppUrl
$wa.LookupDropDownUseStandardControl = $true | $false
$wa.Update()

Direct updates to SQL are wholly unsupported.

You'll use the SharePoint Management Shell on one of the SharePoint servers which is a member of the farm.

EDIT: Disregard the above. It can't be set!

public bool LookupDropDownUseStandardControl
{
    get => 
        true;
    set
    {
    }
}