Re: EOFetchSpecification - sorting by partial date
Re: EOFetchSpecification - sorting by partial date
- Subject: Re: EOFetchSpecification - sorting by partial date
- From: Samuel Pelletier <email@hidden>
- Date: Mon, 13 Jul 2015 12:27:58 -0400
Calven,
There is no easy way on the database but you can add a method that returns a formatted string or int and sort in memory on it.
To use an int, you take the date year*100 + month number, for a string a formatter like this "yyyy-MM".
For more readable code, add an ERXKey on your entity class like this:
public static ERXKey<String> YEAR_MONTH = new ERXKey<String>("yearMonth");
and sort like this:
sortedRows = EntityClass.YEAR_MONTH.ascs().sorted(rowsFromDB);
BTW, if you are using the Wonder templates, your sort ordering can be created like this with no strings constants:
orderings = SOURCE.ascInsensitive().then(APPOINTMENT_DATE.ascInsensitive()).then(SITE.ascInsensitive());
Samuel
> Le 2015-07-13 à 12:02, Calven Eggert <email@hidden> a écrit :
>
> 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