Database.Query Variable Does Not Exist

Question

How can I get the field results from a dynamic database query to be available to be put into a list? Here is the code I have:

//Query on the destinationObjectFieldName results
    List<sObject> desinationObjectList =
        Database.query('SELECT Id, Name FROM ' + destinationObject + 'WHERE Id IN :relJunctionObjects' );
    System.debug('desinationObjectList List contains: ' + desinationObjectList);

    //Add the results into the RelatedObject list
    for(sObject s: desinationObjectList) {
        pickListValuesList.add(new RelatedObject(s.Id,s.Name));
    }

Yet I get the error

Variable does not exist: Name

sfdcfox · Accepted Answer · 2018-01-09 16:09:12Z

9

The only field you can directly retrieve from an sObject is Id. All other fields must be referenced dynamically:

    pickListValuesList.add(new RelatedObject(s.Id,(String)s.get('Name')));

This is due to the fact that the compiler must be able to verify that the field exists, which it cannot do for Name without a concrete sObject type (e.g. Account). Note that a few objects do not have a Name field, so if you use this code on some specific objects, expect a QueryException.

answered Jan 9, 2018 at 16:09

sfdcfox

1

Add a comment |

Stack Exchange Network

Database.Query Variable Does Not Exist

1 Answer 1

You must log in to answer this question.

Hot Network Questions