You need to sign in to do that
Don't have an account?
Madhuri Londhe
Soql query on product item transaction help
I am writing query on Object ' Product Item Consumed'. It has lookup field 'Related Record'
I have to fetch fields of its parent.
please help me to write SOQL.
I tried below Query but its giving error.
SOQL :SELECT ProductItemId,RelatedRecord.Serial_Number__c FROM ProductItemTransaction where RelatedRecord.Id != NULL
Error:ERROR at Row:1:Column:22
No such column 'Serial_Number__c' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
I have to fetch fields of its parent.
please help me to write SOQL.
I tried below Query but its giving error.
SOQL :SELECT ProductItemId,RelatedRecord.Serial_Number__c FROM ProductItemTransaction where RelatedRecord.Id != NULL
Error:ERROR at Row:1:Column:22
No such column 'Serial_Number__c' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
But my lookup field is refering two different objects.
hope you understand my problem