• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: qualifierWithQualifierFormat ???
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: qualifierWithQualifierFormat ???


  • Subject: Re: qualifierWithQualifierFormat ???
  • From: David LeBer <email@hidden>
  • Date: Tue, 4 May 2010 14:31:36 -0400

On 2010-05-04, at 2:23 PM, David LeBer wrote:

>
> On 2010-05-04, at 12:34 PM, Theodore Petrosky wrote:
>
>> David,
>>
>> This is fantastic...
>>
>> EOQualifier openVersionsQualifier = Job.VERSIONS.dot(Version.VERSION_STATUS).dot(VersionStatus.VERSION_STATUS_TITLE).eq("Released").and(Job.CLIENT.eq(currentClient));
>> readyToBillJobList = Job.fetchDistinctJobs(jobListEC, openVersionsQualifier, null);
>>
>> fantastic....
>
> Yes it is, isn't it.
>
>>
>> BTW,
>>
>> I copied the fetchJobs(EC, qual, sort) from the _Job.java and pasted into Job.java with the change "fetchSpec.setUsesDistinct(true);".
>> Is this the recommended way to handle this?
>>
>>
>> public static NSArray<Job> fetchDistinctJobs(EOEditingContext editingContext, EOQualifier qualifier, NSArray<EOSortOrdering> sortOrderings) {
>>   EOFetchSpecification fetchSpec = new EOFetchSpecification(_Job.ENTITY_NAME, qualifier, sortOrderings);
>>   fetchSpec.setUsesDistinct(true);
>>   fetchSpec.setIsDeep(true);
>>   NSArray<Job> eoObjects = (NSArray<Job>)editingContext.objectsWithFetchSpecification(fetchSpec);
>>   return eoObjects;
>> }
>
> That would be my first choice, or modify your EO generation templates to take a 'useDistinct' parameter on the fetchEntityName methods.
>
> Something like:
>
> public static NSArray<Job>fetchJobs(EOEditingContext editingContext, EOQualifier qualifier, NSArray<EOSortOrdering> sortOrderings) {
> 	return fetchJobs(editingContext, qualifier, sortOrderings, false, true);
> }
>
> public static NSArray<Job> fetchJobs(EOEditingContext editingContext, EOQualifier qualifier, NSArray<EOSortOrdering> sortOrderings, boolean useDistinct, boolean isDeep) {
>   EOFetchSpecification fetchSpec = new EOFetchSpecification(_Job.ENTITY_NAME, qualifier, sortOrderings);
>   fetchSpec.setUsesDistinct(useDistinct);
>   fetchSpec.setIsDeep(isDeep);
>   NSArray<Job> eoObjects = (NSArray<Job>)editingContext.objectsWithFetchSpecification(fetchSpec);
>   return eoObjects;
> }

Which a good idea I think... humming to himself while he sets off to modify his templates...

>
>
>>
>> Thanks,
>>
>> Ted
>>
>>
>> --- On Tue, 5/4/10, David LeBer <email@hidden> wrote:
>>
>>>> NSMutableArray<Client>  args = new
>>> NSMutableArray<Client>();
>>>> args.addObject(currentClient);
>>>>
>>>> openVersionsQualifier =
>>> EOQualifier.qualifierWithQualifierFormat("versions.versionStatus.versionStatusTitle
>>> = 'Released' and client = %@)", args);
>>>>
>>>> readyToBillJobList = Job.fetchDistinctJobs(jobListEC,
>>> openVersionsQualifier, null);
>>>>
>>>> I wanted to put two objects into the args array.
>>>> object 1:  String
>>>> object 2:  currentClient
>>>>
>>>> but of course args is of type Client so I can not do
>>> that... I did try to use the primaryKey of currentClient,
>>> but then the qualifier is expecting an integer... so I
>>> casted the string to an int and it worked. but then args is
>>> of type Integer... still no joy.
>>>>
>>>> so I tried to let the primaryKey be a string but then
>>> the qualifier barked it needed an integer.
>>>>
>>>> Either I just don't get it or there is an easier way
>>> that I just don't see.. If I could cast to integer in the
>>> qualifier like   " clientid = %@::int",
>>> args   would fix my problem. then I could
>>> save all strings in 'args'.
>>>>
>>>> Ted
>>>
>>>
>>> Couldn't you use NSMutableArray<Object>?
>>>
>>> But really, I'd avoid using qualifierWithQualifierFormat
>>> (Icky, icky, 'magic' strings).
>>>
>>> If you are using Wonder then this is easy to do using the
>>> ERXKey support:
>>>
>>> EOQualifier qual =
>>> UndocumentedRootObject.VERSIONS.dot(Version.VERSION_STATUS).dot(VersionStatus.VERSION_STATUS_TITLE).eq("Released").and(UndocumentedRootObject.CLIENT.eq(myClient));
>>>
>>> ;david
>>>
>>> --
>>> David LeBer
>>> Codeferous Software
>>> 'co-def-er-ous' adj. Literally 'code-bearing'
>>> site:     http://codeferous.com
>>> blog:     http://davidleber.net
>>> profile:    http://www.linkedin.com/in/davidleber
>>> twitter:    http://twitter.com/rebeld
>>> --
>>> Toronto Area Cocoa / WebObjects developers group:
>>> http://tacow.org
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>
> ;david
>
> --
> David LeBer
> Codeferous Software
> 'co-def-er-ous' adj. Literally 'code-bearing'
> site: 	http://codeferous.com
> blog: 	http://davidleber.net
> profile:	http://www.linkedin.com/in/davidleber
> twitter:	http://twitter.com/rebeld
> --
> Toronto Area Cocoa / WebObjects developers group:
> http://tacow.org
>
>
>
>
> _______________________________________________
> 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

;david

--
David LeBer
Codeferous Software
'co-def-er-ous' adj. Literally 'code-bearing'
site: 	http://codeferous.com
blog: 	http://davidleber.net
profile:	http://www.linkedin.com/in/davidleber
twitter:	http://twitter.com/rebeld
--
Toronto Area Cocoa / WebObjects developers group:
http://tacow.org




 _______________________________________________
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

References: 
 >Re: qualifierWithQualifierFormat ??? (From: Theodore Petrosky <email@hidden>)
 >Re: qualifierWithQualifierFormat ??? (From: David LeBer <email@hidden>)

  • Prev by Date: Re: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup
  • Next by Date: Re: ERModernLook
  • Previous by thread: Re: qualifierWithQualifierFormat ???
  • Next by thread: Re: qualifierWithQualifierFormat ???
  • Index(es):
    • Date
    • Thread