Re: EOQualifier to qualify NSTimestamp by month
Re: EOQualifier to qualify NSTimestamp by month
- Subject: Re: EOQualifier to qualify NSTimestamp by month
- From: Chuck Hill <email@hidden>
- Date: Tue, 1 Jun 2010 16:47:02 -0700
On Jun 1, 2010, at 4:18 PM, Joe Kramer wrote:
Hi Chuck,
Thanks for the response. Generally I avoid "non trivial" things as
much as possible because I'm lazy...oops... I mean keenly focused on
efficiency (that sounds better). But I think in this case the SQL
approach may be worth it. In looking at the EOSQLQualifier docs I
see that it is deprecated. It looks like using
EOFetchSpecification.setHints() should do the trick in this case.
Thanks for weighing in!
Just be aware that hints are very under documented.
Regards,
Joe
On Tue, Jun 1, 2010 at 3:53 PM, Chuck Hill <chill@global-
village.net> wrote:
On Jun 1, 2010, at 3:30 PM, Joe Kramer wrote:
Hi all,
I may be barking up the wrong tree here, but I wanted someone to
confirm that for me. I have a simple Person EO with a NSTimestamp
attribute for birthdate. I'm wondering if it is possible to create
a qualifier to get all the people whose birthday is in a particular
month (May, for example). The year doesn't matter so I can't do a
simple ">" or "<". If this isn't possible (or efficient) I can
change the data model to capture the birth month separately. Then I
can just set the month programatically when a new person is created
and use that value as the qualifier. Just curious what others think.
Define "possible". :-P The SQL way is
select extract(MONTH from col_name) from table_name;
So you could write a custom qualifier to do this. Generally,
writing qualifiers ranks as "non trivial". I don't know of an
existing qualifier that you can use. Depending on your needs, SQL
might be the way to go. See EOSQLQualifier JavaDocs.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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