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]> 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]> 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]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com >> >> This email sent to [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]
