You need to sign in to do that
Don't have an account?
Rachel Frazer
Trying to create cross filter functionality using SOQL
I am trying to query two related objects in Field Service Lightning. Ideally I would return the same results as in the report below, namely:
Show Name, Skill__c, and Territories__c from Service Resources, with this cross filter:
Service Resources WITHOUT Assigned Resources
with a Start Date less than 2/28/2019
and
an End Date less than 2/1/2019
Currently, my query looks like this:
SELECT Id,Name,Skill__c,Territory__c FROM ServiceResource
where (Id NOT in (select Service_Resource__c from Request_Resource__c where Start_Date__c < 2019-02-28 and End_Date__c > 2019-02-01))
but it is returning too many records.
Show Name, Skill__c, and Territories__c from Service Resources, with this cross filter:
Service Resources WITHOUT Assigned Resources
with a Start Date less than 2/28/2019
and
an End Date less than 2/1/2019
Currently, my query looks like this:
SELECT Id,Name,Skill__c,Territory__c FROM ServiceResource
where (Id NOT in (select Service_Resource__c from Request_Resource__c where Start_Date__c < 2019-02-28 and End_Date__c > 2019-02-01))
but it is returning too many records.
https://help.salesforce.com/articleView?id=reports_report_type_objects.htm&type=5
For each child object, select one of the following criteria:
customer feedback (https://customerfeedbacks.xyz/)