ObjectQuery SkuInfo Join error

Tommy De Notarpietro asked on June 3, 2016 12:05

I'm using the ObjectQuery API to retrieve data from a custom table which is generated by Kentico and inherits from SKUTreeNode. When I join it with the Com_Sku table ( with SKUInfo ), I'm getting an error.

The example code I use is: var test = CustomProductProvider.GetCustomProducts() .Source(sourceItem => sourceItem.Join<SKUInfo>("no", "SKUNUMBER")).FirstOrDefault();

The error is "Invalid column name 'no'.", while this column belongs to the product table.

The query which is generated is ( I excluded the where-clause ):

SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN custom_product AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.tableID AND V.ClassName = N'custom.product' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID INNER JOIN COM_SKU ON S.no = COM_SKU.SKUNUMBER

Why can't I join or how can I retrieve the information in the custom table joined by the COM_SKU table?

Recent Answers


David te Kloese answered on June 3, 2016 12:50

Id say double check to see if the columns are really added.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.