You need to sign in to do that
Don't have an account?
GB3
Select Fields From Parent Where Child field has a certain value
Hi,
Is it possible to select parent values where the child field has a certain value?
For example:
Didn't understand relationship 'Contracts' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Even if I add the __r to Orders though, I get the error...
Is it possible to select parent values where the child field has a certain value?
For example:
Select Name From Contract Where Contract.Orders.Status = 'Draft'I get the error:
Didn't understand relationship 'Contracts' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Even if I add the __r to Orders though, I get the error...
You can try to query like this.
please check and let us know.
Is it possible to do this query From the Contract table (or any other parent table)?