Hi,
It is possible but remove rootEntity="true" from entity declarations.
On Thursday, April 3, 2014 10:29 PM, sanjay92 <sanja...@hotmail.com> wrote:
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.
