How do I group and group two tables together?

Unal UN asked on January 16, 2018 09:31

How do I group and group two tables together ?

CodeExamples Not Working !

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

Can you Help Me Please ?

Recent Answers


Trevor Fayas answered on January 16, 2018 14:11

Is there an error? Just nothing returning?

0 votesVote for this answer Mark as a Correct answer

Unal UN answered on January 16, 2018 15:20

Thank you Trevor

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;

0 votesVote for this answer Mark as a Correct answer

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