Hi...

thanks for these great modules...

I am using Search Lucene API on a project, which is really great... However, the client came back and asked if i can add a Top Rated filter to the results. I know the best way to accomplish this would be to use the Views integration. I downloaded the dev version and tried this. The views integration works fine with the keywords search. Howevever, when i add a node relationship for Node: Vote Results, it does not add any additional sort criteria..

can you tell me how i can accomplish this?

if this requires some additional coding or changes, please point me what i should be doing and i will be able to do it and submit the code for review... i am not a great deal of a programmer in Lucene but can code the drupal part of it if given directions...

i need this feature on a high priority, and any help is greatly appreciated...

thanks for your time :-)

Comments

nvl.sateesh’s picture

nvl.sateesh commented

@update:

I understand upon little code review that other sort filters have been intentionally removed

Because sorting and filtering must happen on the Lucene level, non-Lucene sorts and filters must be removed from the form to aviod confusion.

So, can i get these filters instead of the lucene level sorts ? i tried by commenting this function output so that all filters come back... they come back and i am able to use the voting api sort criteria before the view is saved. but once saved, it gives an error saying

User warning: Table 'rewardsatwork.luceneapi_views' doesn't exist query: SELECT DISTINCT luceneapi_views.nid AS nid, votingapi_cache_node_percent_average.value AS votingapi_cache_node_percent_average_value FROM luceneapi_views luceneapi_views LEFT JOIN node node ON luceneapi_views.nid = node.nid LEFT JOIN votingapi_cache votingapi_cache_node_percent_average ON node.nid = votingapi_cache_node_percent_average.content_id AND (votingapi_cache_node_percent_average.content_type = 'node' AND votingapi_cache_node_percent_average.value_type = 'percent' AND votingapi_cache_node_percent_average.function = 'average') LEFT JOIN domain_access da ON luceneapi_views.nid = da.nid WHERE ((da.realm = "domain_id" AND da.gid = 0)) ORDER BY votingapi_cache_node_percent_average_value DESC in _db_query() (line 128 of E:\ZendStack\Apache2\htdocs\4rewards\includes\database.mysql.inc).

i am assuming that luceneapi_views is rendered on the fly using some temporary table?

what can i do to use voting api results and other filters in search lucene results instead of the lucene's internal filters and sort?

thanks.....

cpliakas’s picture

cpliakas commented
Status: Active » Closed (won't fix)

Due to end of life announcement.