How do I add another unrelated query results to solr index

[sanjay92]

Hi,
How do I add two different queries into one single index.
e..g.
I have added following
      <entity name="salgrade" rootEntity="true"  query="select
grade,losal,hisal from salgrade" >
                <field column="GRADE" name="grade" />
                <field column="LOSAL" name="losal" />
                <field column="HISAL" name="hisal" />
      </entity>

But when I query, I dont see any data from salgrade table.
I have also tried another document tag but that also did not work as
expected.
Is it possible ?

<dataConfig>
  <dataSource type="JdbcDataSource"
              driver="oracle.jdbc.driver.OracleDriver"
              url="jdbc:oracle:thin:@mydb:1521:SID"
              user="****"
              password="****"  />
  <document>
      <entity name="salgrade" rootEntity="true"  query="select
grade,losal,hisal from salgrade" >
                <field column="GRADE" name="grade" />
                <field column="LOSAL" name="losal" />
                <field column="HISAL" name="hisal" />
      </entity>
    <entity name="mydept"  rootEntity="true" query="select deptno,dname,loc
from dept">
            <field column="DEPTNO" name="deptno" />
            <field column="DNAME" name="dname" />
            <field column="LOC" name="loc" />
            <entity name="myemp" query="select ename,job from emp where
deptno=${mydept.DEPTNO} " >
               <field column="ENAME" name="ename" />
               <field column="JOB" name="job" />
            </entity>
    </entity>
    
  </document>
  
</dataConfig>




--
View this message in context: 
http://lucene.472066.n3.nabble.com/How-do-I-add-another-unrelated-query-results-to-solr-index-tp4128932.html
Sent from the Solr - User mailing list archive at Nabble.com.