Apple

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

References:
	>EOQualifier to qualify NSTimestamp by month (From: Joe Kramer <email@hidden>)
	>Re: EOQualifier to qualify NSTimestamp by month (From: Chuck Hill <email@hidden>)
	>Re: EOQualifier to qualify NSTimestamp by month (From: Joe Kramer <email@hidden>)
	>Re: EOQualifier to qualify NSTimestamp by month (From: Farrukh Ijaz <email@hidden>)