title: Solr - index JSON query string from database?
body: <p>I would like to know if it is possible to index data that contains a JSON string that can be decoded and each JSON value to be indexed with the separate values.</p>
  
  <p>I am using the DIH to connect to a MySQL database and able to index the individual columns.
  The result would look like the following:</p>
  
  <pre><code>&lt;response name="response" numFound="1" start="0" maxScore="2.7143538"&gt;
      ...
      &lt;result name="response" numFound="1" start="0" maxScore="2.7143538"&gt;
          &lt;doc&gt;
          &lt;float name="score"&gt;2.7143538&lt;/float&gt;
          &lt;str name="id"&gt;82&lt;/str&gt;
          &lt;str name="name"&gt;jorge&lt;/str&gt;
          &lt;str name="otherinfo"&gt;{"day":15,"year":1989,"month":"January"}&lt;/str&gt;
      &lt;/doc&gt;
  &lt;/result&gt;
  &lt;/response&gt;
  </code></pre>
  
  <p>The problem is that "otherinfo" is a JSON string that I would like to decode and have something like the following in my index:</p>
  
  <pre><code>&lt;response name="response" numFound="1" start="0" maxScore="2.7143538"&gt;
      ...
      &lt;result name="response" numFound="1" start="0" maxScore="2.7143538"&gt;
          &lt;doc&gt;
          &lt;float name="score"&gt;2.7143538&lt;/float&gt;
          &lt;str name="id"&gt;82&lt;/str&gt;
          &lt;str name="name"&gt;jorge&lt;/str&gt;
          &lt;str name="day"&gt;15&lt;/str&gt;
          &lt;str name="year"&gt;1989&lt;/str&gt;
          &lt;str name="month"&gt;January&lt;/str&gt;
      &lt;/doc&gt;
  &lt;/result&gt;
  &lt;/response&gt;
  </code></pre>
  
  <p>Would this be possible to do at all with Solr?</p>
  
  <p>Thanks in advance</p>