Thanks Indika, that looks good. I'll look at the article. If anyone else has any good ideas please send them too.
On Mon, Mar 29, 2010 at 11:09 AM, Indika Tantrigoda <indik...@gmail.com>wrote: > Hi Dhanushka, > > Have you tried to use the filter query parameter. > Check out this article, the Applying Constraints section should be helpful > to you. > > http://www.lucidimagination.com/Community/Hear-from-the-Experts/Articles/Faceted-Search-Solr > > Solr Wiki link to filter query parameter > http://wiki.apache.org/solr/CommonQueryParameters#fq > > I am at the moment implementing a similar system where the user needs to > drill down to the data. > What I am doing now is say if the user selects "Chemistry" from the facet I > request a query with > the filter query applied to fDepartmentName and when the user selects "US > Cancer/Diabetic Research Institute" > from the fSponsor facet I will apply filter querying to both the > fDepartmentName and fSponsor. > > Hope this helps. > > Regards, > Indika > > > On 29 March 2010 21:19, Dhanushka Samarakoon <dhan...@gmail.com> wrote: > >> Hi, >> >> I'm trying to perform a search based on keywords and then reduce the >> result >> set based on facets that user selects. >> First query for a search would look like this. >> >> >> http://localhost:8983/solr/select/?q=cancer+stem&version=2.2&wt=php&start=&rows=10&indent=on&qt=dismax&facet=on&facet.mincount=1&facet.field=fDepartmentName&facet.field=fInvestigatorName&facet.field=fSponsor&facet.date=DateAwarded&facet.date.start=2009-01-01T00:00:00Z&facet.date.end=2010-01-01T00:00:00Z&facet.date.gap=%2B1MONTH >> >> In the above query (as per dismax on the solr config file) it searches >> multiple fields such as GrantTitle, DepartmentName, InvestigatorName, >> etc... >> >> Then if user select 'Chemistry' from the facet field 'fDepartmentName' >> and >> 'US Cancer/Diabetic Research Institute' from 'fSponsor' I need to reduce >> the >> result set above to only records from where fDepartmentName is 'Chemistry' >> and 'fSponsor' is 'US Cancer/Diabetic Research Institute' >> The following query is not working. >> select/?q=cancer+stem+fDepartmentName:Chemistry+fSponsor:US >> Cancer/Diabetic >> Research Institute&version=2.2& >> >> Fields starting with 'f' are defined in the schema.xml as copy fields. >> <field name="DepartmentName" type="text" indexed="true" stored="true" >> multiValued="true" /> >> <field name="fDepartmentName" type="string" indexed="true" >> stored="false" >> multiValued="true" /> >> <copyField source="DepartmentName" dest="fDepartmentName"/> >> >> Any ideas on the correct syntax? >> >> Thanks, >> Dhanushka. >> > >