What is the query that you are using ? Try something like q=city:Chicago .

Look at the solrconfig file and you will see
<defaultSearchField>name</defaultSearchField> . This is the reason that
unless you specify the search field in the query, solr will always
search the field name.

On 09/03/2010 04:52 PM, ankita shinde wrote:
hello,
I have done all the suggested changes. My table name is 'info' having
columns id,name,city and skill. I am able to index them all successfully.
But I am able to search the data only using name and not other column names.
Where did I go wrong?


*My data-config.xml file is as below:*

<dataConfig>
   <dataSource type="JdbcDataSource"
               driver="com.mysql.jdbc.Driver"
               url="jdbc:mysql://3307/dbname"
               user="user-name"
               password="password"/>
   <document>
     <entity name="id"
             query="select id,name,city,skill from info">
<field name="id" column="id"/>
<field name="name" column="name"/>
<field name="city" column="city"/>
<field name="skill" column="skill"/>
    </entity>
   </document>
</dataConfig>




*And the entries made in schema.xml are:*

<field name="city" type="string" indexed="true" stored="true"/>
<field name="skill" type="string" indexed="true" stored="true"/>


entries for id and name are already present.


*And i also have added requestimporthandler in solrconfig.xml as follow:*


<requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
   <str name="config">data-config.xml</str>
</lst>
</requestHandler>


Pink OTC Markets Inc. provides the leading inter-dealer quotation and trading 
system in the over-the-counter (OTC) securities market.   We create innovative 
technology and data solutions to efficiently connect market participants, 
improve price discovery, increase issuer disclosure, and better inform 
investors.   Our marketplace, comprised of the issuer-listed OTCQX and 
broker-quoted   Pink Sheets, is the third largest U.S. equity trading venue for 
company shares.

This document contains confidential information of Pink OTC Markets and is only 
intended for the recipient.   Do not copy, reproduce (electronically or 
otherwise), or disclose without the prior written consent of Pink OTC Markets.  
    If you receive this message in error, please destroy all copies in your 
possession (electronically or otherwise) and contact the sender above.

Reply via email to