Databases
StackOverflow2013
Postsdbo
POHow do I get solr to return results from all indicies?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I get solr to return results from all indicies?
    primarykey
    data
    text
    <p>I am starting to integrate with Solr and have run across what I perceive as an issue. I uploaded a simple spreadsheet using the java API (here is an exert:</p> <pre><code> - Document, id, value - Excel3, name, steelers - Excel3, subject, pirates - Excel3, description, penguins - Excel3, comments, panthers - Excel3, author, panthers </code></pre> <p>)</p> <p>Using this I used the first column as the "document name", second column as the field in the document to index, and the third column as the indexed data. All of these fields already existed in schema.xml, but here is how they are set up:</p> <pre><code>&lt;field name="id" type="string" indexed="true" stored="true" required="true" /&gt; &lt;field name="name" type="text_general" indexed="true" stored="true"/&gt; &lt;field name="subject" type="text_general" indexed="true" stored="true"/&gt; &lt;field name="description" type="text_general" indexed="true" stored="true"/&gt; &lt;field name="comments" type="text_general" indexed="true" stored="true"/&gt; &lt;field name="author" type="text_general" indexed="true" stored="true"/&gt; </code></pre> <p>now here is where my problem comes into play. I run a search for say steelers, and it comes back fine, but if I look for penguins, or many of the other fields, it does not pull back any results. However if I do description:penguins, the result pulls back as expected.</p> <p>Can anyone please help me understand why the part before the : is required for some fields, but not others?</p> <p>example searches: solr/select?indent=on&amp;q=penguins&amp;wt=xml ----Doesn't return any results</p> <pre><code>&lt;response&gt; &lt;lst name="responseHeader"&gt; &lt;int name="status"&gt;0&lt;/int&gt; &lt;int name="QTime"&gt;0&lt;/int&gt; &lt;lst name="params"&gt; &lt;str name="indent"&gt;on&lt;/str&gt; &lt;str name="q"&gt;penguins&lt;/str&gt; &lt;str name="wt"&gt;xml&lt;/str&gt; &lt;/lst&gt; &lt;/lst&gt; &lt;result name="response" numFound="0" start="0"/&gt; &lt;/response&gt; </code></pre> <p>solr/select?indent=on&amp;q=description:penguins&amp;wt=xml</p> <pre><code>&lt;response&gt; &lt;lst name="responseHeader"&gt; &lt;int name="status"&gt;0&lt;/int&gt; &lt;int name="QTime"&gt;18&lt;/int&gt; &lt;lst name="params"&gt; &lt;str name="indent"&gt;on&lt;/str&gt; &lt;str name="q"&gt;description:penguins&lt;/str&gt; &lt;str name="wt"&gt;xml&lt;/str&gt; &lt;/lst&gt; &lt;/lst&gt; &lt;result name="response" numFound="1" start="0"&gt; &lt;doc&gt; &lt;str name="author"&gt;panthers&lt;/str&gt; &lt;str name="comments"&gt;panthers&lt;/str&gt; &lt;str name="description"&gt;penguins&lt;/str&gt; &lt;str name="id"&gt;Excel3&lt;/str&gt; &lt;str name="name"&gt;steelers&lt;/str&gt; &lt;str name="subject"&gt;pirates&lt;/str&gt; &lt;/doc&gt; &lt;/result&gt; &lt;/response&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBrendan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI believe the default query parser only searches one field. Try dismax. http://wiki.apache.org/solr/DisMax Try `solr/select?indent=on&q=description:penguins&wt=xml&defType=dismax`
      singulars
      1. POHow do I get solr to return results from all indicies?
      1. USFrank Farmer
    2. COFrank, I looked in the schema file, and am using the edismax query parser. with the query above, it does not return anything, but the query I provided did return results. (I am looking to not have to use description: and search only one field, but search all at once.
      singulars
      1. POHow do I get solr to return results from all indicies?
      1. USBrendan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload