Re: SELECT DISTINCT with Display group
Re: SELECT DISTINCT with Display group
- Subject: Re: SELECT DISTINCT with Display group
- From: Art Isbell <email@hidden>
- Date: Tue, 18 Mar 2003 11:42:41 -1000
On Tuesday, March 18, 2003, at 10:19 AM, Alvaro Muir wrote:
I dont know why this is so hard. I can do this in JSP with my eyes
closed. Can someone help me pull a DISTINCT query from a display group
app in WO 5.2 ? Im a super newbie.
I don't use WODisplayGroups so I may be missing a way to configure a
DISTINCT fetch graphically in WebObjects Builder (WOB). But I do know
that the EOFetchSpecification associated with the display group
controls fetch properties like DISTINCT.
The no coding approach would be to create a fetch specification in
your eomodel, set the "Fetch distinct rows" in the fetch spec's Options
in EOModeler, and associate that fetch spec with your display group
using WOB's display group configuration panel.
Or you can send the fetch spec a setUsesDistinct(true) message
programmatically. You can get the existing fetch spec from the display
group by sending it a dataSource() message which should return an
EODataSource object. Cast this data source object to
EODatabaseDataSource and send it a fetchSpecification message to get
its fetch spec.
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.