I want to find out how many products are underneath that category. Can you be a helper ?

Is there any reason why you are not using Kentico categories?

Hi Peter,

I am using the kentico API.

can you help me ?

Thank you

I Solved

Code Samples

var CategoryAndProductCustomColumuns2 = CustomTableItemProvider.GetItems("customtable.MyJoinCategory").Source(s => s.LeftJoin("customtable_MyJoinProduct", "ItemID", "CategoryID")).Column("Name").AddColumn(new CountColumn("CategoryID").As("ProductCount")).GroupBy("CategoryID,Name").Result;