Getting an initial term of field expression must be a concrete SObject error:

Question

I'm getting the following error:

Save error: Initial term of field expression must be a concrete SObject: LIST Force.com save problem

Here are the snippets of code in question:

List <PricebookEntry> newProdsList = [SELECT ID //Creating a new PricebookEntry list with all relevant information
                                        ,ProductCode
                                        ,UnitPrice
                                        ,Product2.Description
                                    FROM
                                        PricebookEntry 
                                    WHERE 
                                        ProductCode in: productCodes
                                        AND
                                        Pricebook2Id in: Pbook2Id.Id
                                ];

The error is ocurring on the line Pricebook2Id in: Pbook2Id.Id.

Here is what Pbook2Id looks like:

List<Pricebook2> Pbook2Id = [SELECT Name
                            ,ID 
                                FROM Pricebook2 
                                    WHERE Name='Support Renewal' AND IsActive=true];

My question is, what does this error mean? I've looked at other such errors here and I'm not sure I fully understand why it's being caused.

Answer 1

Pbook2Id is a collection, so it doesnt have a field called Id.

The dot notation to access a field can only be used on an sObject (you can access static / instance variables using Class / Object names too)

In summary,

AND
PriceBook2Id IN : Pbook2Id

This works in Apex for an ID Field, if it didn't you'd have to construct a List for comparison

List<Id> PriceBookIds = new List<Id>();
for(PriceBook2 pb : Pbook2Id) //iterate over the list and collect ids for comparison
PriceBookIds.add(pb.Id);

and then use

PriceBook2Id IN :PriceBookIds

You can also cast to a Map dynamically and use the keySet for comparison

Map<Id, Pricebook2> Pbook2Id = new Map<Id, PriceBook2>([SELECT Id, Name
                                FROM Pricebook2 
                                    WHERE Name='Support Renewal' AND IsActive=true]);

And then Use

PriceBook2Id IN :Pbook2Id.keySet()