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 protected]> 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 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]
