You need to sign in to do that
Don't have an account?
Danielle Rosen
Trying to query a lookup relationship from non-master object.
Hello,
I have a field called 'Main Contact,' which is a lookup relationship on my Account object. I am trying to query the Main Contact's email, full name, and phone number, from a button on the Contract object, (custom Conga object.) I've come at this a bunch of different ways, but can't seem to get the data to pull. Here's what I have at the moment: SELECT Main_Contact__r.Email, Main_Contact__r.Name, Main_Contact__r.Phone FROM Account WHERE Id = '{pv0}' Any guidance would be much appreciated! Thank you!
I have a field called 'Main Contact,' which is a lookup relationship on my Account object. I am trying to query the Main Contact's email, full name, and phone number, from a button on the Contract object, (custom Conga object.) I've come at this a bunch of different ways, but can't seem to get the data to pull. Here's what I have at the moment: SELECT Main_Contact__r.Email, Main_Contact__r.Name, Main_Contact__r.Phone FROM Account WHERE Id = '{pv0}' Any guidance would be much appreciated! Thank you!
Raj Vakati
Try this
sharathchandra thukkani
Your query should work fine but in place of pv0 it should be 18 or 15 digit id.