you didn’t mention your database, but I have done things like this with a view.
I created a view with the appropriate columns and in the select statement I put in the order by CREATE OR REPLACE VIEW myNewView AS SELECT info1, info2, theDate FROM theTable ORDER BY extract (year from theDate) desc, extract (month from theDate) asc; A one point I actually set up some rules to make the ‘VIEW’ updatable. YMMV obviously depending on you access to the backend, and if Views are supported. Ted > On Jul 13, 2015, at 12:02 PM, Calven Eggert <[email protected]> wrote: > > 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/tedpet5%40yahoo.com > > This email sent to [email protected] _______________________________________________ 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]
