Hi thanks for reply.. Actually requirement is diffrent (sorry if I am unable to clerify in first mail).
basically follwoing are the fields name in schema as well: > 1. id > 2. name > 3. user_id > 4. location > 5. country > 6. landmark1 > 7. landmark2 > 8. landmark3 > 9. landmark4 > 10. landmark5 which carrying text... for example: <id>1</id> <name>some name</name> <user_id>user_id</user_id> <location>new york</location> <country>USA</country> <landmark1>5th avenue</landmark1> <landmark2>ms departmental store</landmark2> <landmark3>base bakery</landmark3> <landmark4>piza hut</landmark4> <landmark5>ford motor</landmark5> now if user search by "piza" then expected result like: <id>1</id> <name>some name</name> <user_id>user_id</user_id> <location>new york</location> <country>USA</country> <landmark4>piza hut</landmark4> it means I want to ignore all other landmark which not match. By filter we can filter the fields but here I dont know the the field name because it depends on text match. is there any other solution.. I am ready to change in schema or in logic. I am using solrj. please help me I stuck here.. with regards On Wed, Jul 28, 2010 at 7:22 PM, rajini maski <rajinima...@gmail.com> wrote: > you can index each of these field separately... > field1-> Id > field2-> name > field3->user_id > field4->country..... > > .... > field7-> landmark > > While quering you can specify "q=Landmark9" This will return you > results.. > And if you want only particular fields in output.. use the "fl" parameter > in > query... > > like > > http://localhost:8090/solr/select? > indent=on&q=landmark9&fl=ID,user_id,country,landmark& > > This will give your desired solution.. > > > > > On Wed, Jul 28, 2010 at 12:23 PM, Jonty Rhods <jonty.rh...@gmail.com> > wrote: > > > Hi All, > > > > I am very new and learning solr. > > > > I have 10 column like following in table > > > > 1. id > > 2. name > > 3. user_id > > 4. location > > 5. country > > 6. landmark1 > > 7. landmark2 > > 8. landmark3 > > 9. landmark4 > > 10. landmark5 > > > > when user search for landmark then I want to return only one landmark > > which > > match. Rest of the landmark should ingnored.. > > expected result like following if user search by "landmark2".. > > > > 1. id > > 2. name > > 3. user_id > > 4. location > > 5. country > > 7. landmark2 > > > > or if search by "landmark9" > > > > 1. id > > 2. name > > 3. user_id > > 4. location > > 5. country > > 9. landmark9 > > > > > > please help me to design the schema for this kind of requirement... > > > > thanks > > with regards > > >