example Get : http://domain/Kentico12_1_Admin/rest/customtableitem.customtable.name1/i want to join table customtableitem.customtable.name1 with customtableitem.customtable.name2what should i do t...

I have some code which uses a Source to join two tables.How do I fake that for a unit test?for example:DataSet result = UserInfoProvider.GetUsers().Source(si =@ si.Join

Hi there; how to get Kentico users via a join with another table? I have a custom field in the CMS-User table and it is a foreign key of another table which I named it BusinessUnit, I want to get...

I don't typically write custom SQL queries, so please forgive the inefficiencies in the following test code. I'm trying to retrieve data from both a page type (table) and a custom table via a Query...

CustomTableItemProvider.GetItems@MyJoinUserItem@().Source(s =@ s.LeftJoin@MyJoinOrderItem@(@ItemID@, @UserID@).LeftJoin@MyJoinProductItem@(@ProductID@, @ItemID@)).Columns(@Name@, @ProductName@,...

Hi, I can combine more than one table but I can not select the columns.var UserProductOrder = CustomTableItemProvider.GetItems@MyJoinUserItem@().Source(s =@ s.LeftJoin@MyJoinOrderItem@(@ItemID@, @U...

How do I group and group two tables together ?CodeExamples Not Working !CustomTableItemProvider.GetItems(@customtable.MyJoinCategory@).Source(s =@ s.LeftJoin(@customtable_MyJoinProduct@, @ItemID@, ...

Hi am using Kentico 10 I am trying to combine two tables. I want to find out how many products are underneath that category. Can you be a helper?//Code Samples var result = CustomTableItemProvider....

Hello,I am currently trying to convert a custom query that I have running for a repeater into code using the DocumentHelper class, however I have run into some brick walls. It is a relatively simpl...

My question comes in two parts. For starters and I will tell you what I first attempted and how that lead to a workaround with a dead end. Hopefully you can tell me how I could of accomplished th...