I just looked in there. How do you set that up? I tried playing but I guess I don’t understand the derived column.
Thanks Chuck! > On Jul 13, 2015, at 2:20 PM, Chuck Hill <[email protected]> wrote: > > Just a note that you can use the extract (year from theDate) and extract > (month from theDate) in a derived column in EntityModeler which avoids the > need for a view. > > On 2015-07-13, 11:16 AM, "Theodore Petrosky" wrote: > > 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] > <mailto:[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] > <mailto:[email protected]>) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com > <https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com> > This email sent to [email protected] <mailto:[email protected]> > > > _______________________________________________ > 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/chill%40gevityinc.com > <https://lists.apple.com/mailman/options/webobjects-dev/chill%40gevityinc.com> > > This email sent to [email protected] <mailto:[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]
