Jun 4, 2012 at 2:34 PM
Edited Jun 4, 2012 at 2:47 PM
I have two related parts: CountryPart and CityPart, titles for city and country store in TitlePart. Threr is record definitions for my custom parts:
SchemaBuilder.CreateTable("CountryPartRecord", table => table
SchemaBuilder.CreateTable("CityPartRecord", table => table
I want to implement ISortCriterionProvider to get City sorted by country title and city title.
As I understand it should looks like following code:
.Join(x => x.ContentPartRecord(typeof(CountryPartRecord)))
.OrderBy(x => x.ContentPartRecord(typeof(TitlePart)), x => x.Asc("Title"));
But it does not work.
How to write IHqlQuery for sorting by related ContentParts?
Could you advice some sample or doc to write ISortCriterionProvider?