I've come across a SOQL syntax which I cannot find any documentation for, and was wondering if anyone knew about it.
SELECT Id, Name
FROM Contact
USING LOOKUP Account.ParentContact__c
BIND ParentId = '0010Y00000aXWI7'
I have a lookup field on Account, ParentContact__c, which looks up to the Contact object, and is filtered so that I can only select Contacts related to the Account's Parent Id.
This query syntax allows me to input any variables which are used by the lookup filter using the BIND variable, and then returns results according to the configured lookup filter (LOOKUP Account.ParentContact__c).
The only reference I can find to the syntax is that it was removed from the winter 15 release, per the release note changes.
Is this documented anywhere? The SOQL reference only talks about USING SCOPE
.
(These can be combined: USING SCOPE Everything, LOOKUP Account.ParentContact__c
)
Does anyone know any other parts to this syntax? Was this ever released officially by Salesforce, or is it an accident? Does anyone have an original version of the winter 15 release notes which might document this?