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 protected]> 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 protected]> 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 protected]> 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 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]> 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/chill%40gevityinc.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/samuel%40samkar.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]
