I just want to note that the JavaLuceneAdaptor in Wonder uses EOFetchSpecification's hints() to do extra magic in a custom EOAdaptorChannel. You might want to look at that adaptor for ideas as well.
Ramsey On Feb 25, 2013, at 12:50 PM, Chuck Hill wrote: > My first guess is that you would need to subclass and extend OracleExpression > (from the Oracle plugin in JavaJDBCAdaptor). > > Chuck > > > On 2013-02-25, at 11:34 AM, Frank C wrote: > >> I have implemented several custom EOQualifiers for Oracle. Some for text >> searches and some for spatial searches. The queries work fine for what they >> do, however, I have been unable to take advantage of some of the Oracle >> features. >> >> When you perform these searches in Oracle you can assign a number to the >> query that allows you to perform operations on that query. As an example, >> when you do a full text search using the "CONTAINS" function, I can assign a >> number to the contains clause. I can then use the "SCORE" function to get >> the relevancy score for that contains clause. >> >> An Example: >> >> select SCORE(1) from Foo t0 where CONTAINS(t0.description, 'bar', 1) > 0 >> order by SCORE(1) desc; >> >> As you can see above I can use the "SCORE" function to both get the >> relevancy score in the column results and to order the results and put the >> most relevant results first. I could even add a second CONTAINS and label it >> "2" and then use "SCORE(2)." There are similar functions for Spatial queries >> as well. >> >> There are a couple of problems I do not know how to solve in WebObjects: >> >> 1) When my custom qualifier is generating the SQL, is there a way for it to >> insert the function into the select list and/or into the ORDER BY clause. Or >> is there a way to add a function column or ORDER BY clause that can peek >> into the qualifiers to see if there is a matching qualifier? >> >> 2) If I can accomplish #1, is there anyway for the qualifiers to know how >> many qualifiers are in the fetch specification so that I can make sure the >> multiple qualifiers do not use the same identifier. >> >> 3) If I can accomplish #1 and/or #2, how can I build a fetch on a table that >> brings back the extra column from the select (i.e. SCORE(1)). >> >> Thanks, >> Frank >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >> >> This email sent to [email protected] > > -- > Chuck Hill > Executive Managing Partner, VP Development and Technical Services > > 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/gvc/practical_webobjects > > Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing > Companies in B.C! > Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of > Canada’s Fastest-Growing Companies by PROFIT Magazine! > > > > > > > > > > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
