Re: EOQualifier to qualify NSTimestamp by month
Re: EOQualifier to qualify NSTimestamp by month
- Subject: Re: EOQualifier to qualify NSTimestamp by month
- From: Kieran Kelleher <email@hidden>
- Date: Wed, 2 Jun 2010 11:06:56 -0400
Sounds like a better plan than me breaking out the JDGui.app!
On Jun 2, 2010, at 10:56 AM, Mike Schrag wrote:
> admittedly, i could probably answer that more easily than you could at this point :)
>
> On Jun 2, 2010, at 10:47 AM, Kieran Kelleher wrote:
>
>> I never noticed your comment until 5 seconds ago!! :-)
>>
>> -Kieran
>>
>> On Jun 2, 2010, at 10:45 AM, Mike Schrag wrote:
>>
>>> you never responded to my comment btw :)
>>>
>>> ms
>>>
>>> On Jun 2, 2010, at 10:38 AM, Kieran Kelleher wrote:
>>>
>>>> FYI, prototypes of derived columns don't exactly work in EntityModeler. So you need to write the derived prototype config on a piece of paper and recreate those derived attributes from your notes on that piece of paper instead ;-)
>>>>
>>>> http://issues.objectstyle.org/jira/browse/WOL-1153
>>>>
>>>>
>>>> On Jun 1, 2010, at 7:35 PM, Chuck Hill wrote:
>>>>
>>>>> Now there is a bit of smart thinking! Make it a prototype and you retain some measure of database independence.
>>>>>
>>>>> Chuck
>>>>>
>>>>>
>>>>> On Jun 1, 2010, at 4:20 PM, Johnny Miller wrote:
>>>>>
>>>>>> Could he follow your advice, about using SQL, and create a derived column in his model and then use a standard qualifier against the derived column?
>>>>>>
>>>>>> On Jun 1, 2010, at 12:53 PM, Chuck Hill 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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>>
>>>>>> Johnny Miller
>>>>>> Kahalawai Media Corp
>>>>>> http://www.kahalawai.com
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> 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
>>>>
>>>> _______________________________________________
>>>> 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