• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: EOFetchSpecification - sorting by partial date
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EOFetchSpecification - sorting by partial date


  • Subject: Re: EOFetchSpecification - sorting by partial date
  • From: Calven Eggert <email@hidden>
  • Date: Mon, 13 Jul 2015 17:18:35 -0400

I'm not going good to be changing the value of the date but thanks for the heads up. Good idea on using the calculation to get a number!

Calven


On Jul 13, 2015, at 5:11 PM, Samuel Pelletier <email@hidden> wrote:

Keep in mind that the YM value on your EO will not be updated if you change the apptDate unless you refresh the object from the database.

To save string creation and manipulation on the server, you may generate a number instead of a string...

EXTRACT(YEAR FROM APPT_DATE) * 100 + EXTRACT(MONTH FROM APPT_DATE) AS YM

Samuel

Le 2015-07-13 à 16:48, Calven Eggert <email@hidden> a écrit :

Thanks Chuck!

I had to add the ‘AS’ clause to the Read Format, otherwise, I received an invalid SQL statement.  I then took advantage of the situation by concatenating my two values (year and month) and padded the month so that I would always get a 6 digit string so I could then do some comparisons with the value for a report.

Read Format:
EXTRACT(YEAR FROM APPT_DATE) || LPAD(EXTRACT(MONTH FROM APPT_DATE), 2, '0') AS YM


On Jul 13, 2015, at 4:10 PM, Chuck Hill <email@hidden> wrote:

Sorry, not derived.  Battling too many tasks this morning.  A read format should do it (so the same column defined as three class property attributes: theDate, theDateYear and theDateMonth (feel free to pick better names :-)
<DE4C48C1-45C2-420F-A017-59C3BC72CBD6.png>




On 2015-07-13, 1:05 PM, "Theodore Petrosky" wrote:

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



Calven


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
  • Follow-Ups:
    • Re: EOFetchSpecification - sorting by partial date
      • From: Timothy Worman <email@hidden>
References: 
 >EOFetchSpecification - sorting by partial date (From: Calven Eggert <email@hidden>)
 >Re: EOFetchSpecification - sorting by partial date (From: Theodore Petrosky <email@hidden>)
 >Re: EOFetchSpecification - sorting by partial date (From: Chuck Hill <email@hidden>)
 >Re: EOFetchSpecification - sorting by partial date (From: Theodore Petrosky <email@hidden>)
 >Re: EOFetchSpecification - sorting by partial date (From: Calven Eggert <email@hidden>)
 >Re: EOFetchSpecification - sorting by partial date (From: Samuel Pelletier <email@hidden>)

  • Prev by Date: Re: EOFetchSpecification - sorting by partial date
  • Next by Date: Re: EOFetchSpecification - sorting by partial date
  • Previous by thread: Re: EOFetchSpecification - sorting by partial date
  • Next by thread: Re: EOFetchSpecification - sorting by partial date
  • Index(es):
    • Date
    • Thread