Revert "LPS-46859 SF"

This reverts commit e5e93c7aa96508c8c4b00e9463931ca29a6049b9.
Revert "LPS-46859 Source formatting"

This reverts commit 258efdaf6d595b63fb2016064c884ee5845e87a7.
Revert "LPS-46859 Add other columns to query or it will break when using certain comparators (see LPS-47159)"

This reverts commit 6f262424a1e140967e39e7bcaab5189e1f427b32.
Revert "LPS-46859 Only check if arrays are empty once"

This reverts commit 1c16a875a07ac4c5978e5f796e6f3577da84b9d5.
Revert "LPS-46859 If all the values of firstNames, middleNames, lastNames, screenNames and emailAddresses are null, we should ignore all of these parameters in the query"

This reverts commit 66043a450663e89f3912fb1acae1f0703e5b8e2e.