Hi,
I tried to do the following:
"
<field column="id" name="db_id"/>
<entity name="comment" dataSource="db" query="select com_text from comment
where ftype=1 and fid='${db.tableA.id}' ">
<field column="com_text" name="comment"/>
</entity>
"
So I use the SQL Table Field "id" twice once for "db_id" in my index and for
the sql query as "fid=id".
That doesn´t work!
But when I change the query from "fid=id" to like "fid=otherkey" it does
work!
Like:
"
<field column="id" name="db_id"/>
<entity name="comment" dataSource="db" query="select com_text from comment
where ftype=1 and fid='${db.tableA.otherkey}' ">
<field column="com_text" name="comment"/>
</entity>
"
Is there any other kind of a workaround so I can use the SQL Field "id"
twice as I wanted to? Thanks
kind regards, Sebastian
--
View this message in context:
http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23904968.html
Sent from the Solr - User mailing list archive at Nabble.com.
