function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
tyweedtyweed 

Trying to query reference items but they are null or invalidate query?

So, here is my structure in Apex Explorer 8.0 to help get an idea of what im trying to query

 

Case

   - Site__c reference

       -  Attribute

       -  label

       -  Site_r

           -

           - bunch of stuff i need 

       - type - reference

 

 Query

     Select Site__c.Site__r from case

 

   or Select Site__r from case

 

  select Site__c.Site__r.Name from case

 

 None are valid and even look close to correct. How do i tell it to grab the Site__c -> Site__r which has all the info i need?

 

Message Edited by tyweed on 03-09-2009 09:04 PM
SuperfellSuperfell
select site_r.someField, site__r.someOtherField from case. see the SOQL-R section in the api docs.