Apple

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@hidden> 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@hidden)

Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

_______________________________________________

Do not post admin requests to the list. They will be ignored.

Webobjects-dev mailing list (email@hidden)

Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References:
	>EOFetchSpecification - sorting by partial date (From: Calven Eggert <email@hidden>)
	>Re: EOFetchSpecification - sorting by partial date (From: Theodore Petrosky <email@hidden>)