You need to sign in to do that
Don't have an account?
TehNrd
Query related objects requires hardcoding object ID?
We have a custom object (NSP) that has a look up field to an opportunity. I would like to query the opportunity object but also determine if the opp has any NSPs attached to it. I can build out the query with the force.com IDE but this is what I get:
select Id, (Select Id, Name From R00N50000001gFM3EAM limit 1) from Opportunity
It seems a little bizarre the relationship name is a pseudo ID. I would rather not have to hard code this value if possible. Any one have ideas?
Thanks,
Jason
All Answers
you can try like this
Thanks withoutme. That worked.
hisrinu, this will work by default for parent-child relationships but you have to manually define this label for lookups.