You could create two read only, columns with a definition that extracts the year and month using SQL functions and use those columns to sort on.
Chuck On 2015-07-13, 9:36 AM, "Calven Eggert" wrote: Thanks for the idea. sorting in memory is the other option I've considered, however, was hoping to get the results faster at the database end. On Jul 13, 2015, at 12:27 PM, Samuel Pelletier <[email protected]<mailto:[email protected]>> wrote: Calven, There is no easy way on the database but you can add a method that returns a formatted string or int and sort in memory on it. To use an int, you take the date year*100 + month number, for a string a formatter like this "yyyy-MM". For more readable code, add an ERXKey on your entity class like this: public static ERXKey<String> YEAR_MONTH = new ERXKey<String>("yearMonth"); and sort like this: sortedRows = EntityClass.YEAR_MONTH.ascs().sorted(rowsFromDB); BTW, if you are using the Wonder templates, your sort ordering can be created like this with no strings constants: orderings = SOURCE.ascInsensitive().then(APPOINTMENT_DATE.ascInsensitive()).then(SITE.ascInsensitive()); Samuel Le 2015-07-13 à 12:02, Calven Eggert <[email protected]<mailto:[email protected]>> a écrit : Hi, All I have a fetch that sorts records by three columns where one of the columns is a date (timestamp). Is there a way to sort the date by month & year only? Thanks, Calven Here is the current fetch: ... EOSortOrdering sortBySource = new EOSortOrdering("source", EOSortOrdering.CompareCaseInsensitiveAscending); EOSortOrdering sortByAppt = new EOSortOrdering("appointmentDate", EOSortOrdering.CompareCaseInsensitiveAscending); EOSortOrdering sortBySite = new EOSortOrdering("site", EOSortOrdering.CompareCaseInsensitiveAscending); NSMutableArray orderings = new NSMutableArray(); orderings.addObject(sortBySource); orderings.addObject(sortByAppt); orderings.addObject(sortBySite); EOFetchSpecification spec = new EOFetchSpecification("records", qual, orderings); _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]<mailto:[email protected]>) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com This email sent to [email protected]<mailto:[email protected]> Calven
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
