Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug? - SOLVED
Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug? - SOLVED
- Subject: Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug? - SOLVED
- From: David Avendasora <email@hidden>
- Date: Tue, 29 Dec 2009 14:29:21 -0500
http://issues.objectstyle.org/jira/browse/WONDER-439
It's a direct copy of the method used by Postgress and FrontBase's plugins. I've tested it with our stuff and it seems to work perfectly.
Dave
On Dec 29, 2009, at 2:19 PM, Andrew R. Kinnie wrote:
> Thanks to Dave Avendasora, we have apparently fixed the issue by patching the Oracle plugin to properly handle distinct and sorting in ERXBatchingDisplayGroups.
>
> He will file a jira with his patch.
>
> Andrew
>
>
> On Dec 28, 2009, at 3:06 PM, Chuck Hill wrote:
>
>> And the qualifiers are what controls what SQL is generated. It could also be the way the DG is combining the qualifiers internally. Maybe try creating the OR externally and just setting one combined qualifier on the DG. If that does not work, consider dropping the ERXKey stuff and build it using the Wonder qualifiers directly. You might need to re-state the query.
>>
>>
>> Chuck
>>
>>
>> On Dec 28, 2009, at 10:20 AM, Andrew R. Kinnie wrote:
>>
>>> Also, the reason I point out the distinct/sorting issue is that the generated SQL uses an order by in the outer select, and if you add distinct in the inner select, it's not including the attributes required by the order by, but only the id attribute. Thus, Oracle raises an error, because the distinct select must contain all the attributes used by the order by. If I run the sql separately, I get the same error, and if I add the order by attributes manually to the SQL, I get the correct result.
>>>
>>> Andrew
>>>
>>>
>>> On Dec 28, 2009, at 12:53 PM, Chuck Hill wrote:
>>>
>>>>
>>>> On Dec 28, 2009, at 9:06 AM, Andrew R. Kinnie wrote:
>>>>
>>>>> As a followup, I get the correct number of rows if I comment out any code which sorts the displayGroup using attributes other than the id column of the entity populating the displayGroup.
>>>>>
>>>>> Without sorting, and with setUsesDistinct(true); I get 23 rows. Navigation works.
>>>>>
>>>>> If I then try to sort the displayGroup (using in this case the entity's lastname then firstname attributes) I get the oracle error, because the inner most select statement generated by Wonder/EOF has a distinct, but is trying to orderby attributes that are in the outermost select but not the inner most select where the distinct statement is.
>>>>>
>>>>> Is this a bug in Wonder where setUsesDistinct(true); does not work with sorting?
>>>>>
>>>>> Am I missing something?
>>>>
>>>>
>>>> What is the qualifier? If you are using one of the Wonder qualifiers, you may have found a bug or may be using them incorrectly.
>>>>
>>>>
>>>> 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
>
>
David Avendasora
Senior Software Engineer
K12, Inc.
*****
WebObjects Documentation Wiki : http://wiki.objectstyle.org/confluence/display/WO/
*****
WebObjects API: http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/index.html
*****
_______________________________________________
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