You need to sign in to do that
Don't have an account?
Ben Meyers
Error querying lookup field in where clause
I am trying to use a lookup field in the where clause of a soql query (query is below). For some reason it errors (screen shot attached). Weird part is I can add the lookup field to the query body without issue. Salesforce only has an issue when its in the where clause. Has anyone seen this before?
select id, description, product2id from quotelineitem where quote.quotenumber = '00032686' and product2.sales_type_id__c = 5 and ParentLineItem__r.product2.sales_type_id__c = 4
select id, description, product2id from quotelineitem where quote.quotenumber = '00032686' and product2.sales_type_id__c = 5 and ParentLineItem__r.product2.sales_type_id__c = 4
This error in internal salesforce error and is mostly fixed with time, I tried the query and it worked for me. You can try again or check ParentLineItem__r relationship , I guess this is creating issue