Hi Team,
I am attaching all the required files we are using to get the VJOIN
functionality along with the actual requirement statement.
Hope this would help you understand better the requirement for VJOIN
functionality.
Thanks,
Sukanta
From: Sukanta Dey
Sent: Wednesday, September 04, 2013 1:50 PM
To: 'solr-user@lucene.apache.org'
Cc: Sukanta Dey
Subject: Need help on Joining and sorting syntax and limitations between
multiple documents in solr-4.4.0
Hi Team,
In my project I am going to use Apache solr-4.4.0 version for searching. While
doing that I need to join between multiple solr documents within the same core
on one of the common field across the documents.
Though I successfully join the documents using solr-4.4.0 join syntax, it is
returning me the expected result, but, since my next requirement is to sort the
returned result on basis of the fields from the documents
Involved in join condition's "from" clause, which I was not able to get. Let me
explain the problem in detail along with the files I am using ...
1) Files being used :
a. Picklist_1.xml
--------------------------
<add><doc>
<field name="describedObjectId">t1324838</field>
<field name="describedObjectType">7</field>
<field name="picklistItemId">956</field>
<field name="siteId">130712901</field>
<field name="en">Draft</field>
<field name="gr">Draoft</field>
</doc></add>
b. Picklist_2.xml
---------------------------
<add><doc>
<field name="describedObjectId">t1324837</field>
<field name="describedObjectType">7</field>
<field name="picklistItemId">87749</field>
<field name="siteId">130712901</field>
<field name="en">New</field>
<field name="gr">Neuo</field>
</doc></add>
c. AssetID_1.xml
-------------------------------
<add><doc>
<field name="def14227_picklist">t1324837</field>
<field name="describedObjectId">a180894808</field>
<field name="describedObjectType">1</field>
<field name="isMetadataComplete">true</field>
<field name="lastUpdateDate">2013-09-02T09:28:18Z</field>
<field name="ownerId">130713716</field>
<field name="siteId">130712901</field>
</doc></add>
d. AssetID_2.xml
--------------------------------
<add><doc>
<field name="def14227_picklist">t1324838</field>
<field name="describedObjectId">a171658357</field>
<field name="describedObjectType">1</field>
<field name="ownerId">130713716</field>
<field name="rGroupId">2283961</field>
<field name="rGroupId">2290309</field>
<field name="rGroupPermissionLevel">7</field>
<field name="rGroupPermissionLevel">7</field>
<field name="rRuleId">13503796</field>
<field name="rRuleId">15485964</field>
<field name="rUgpId">38052</field>
<field name="rUgpId">41133</field>
<field name="siteId">130712901</field>
</doc></add>
2) Requirement:
--------------------------------------------
i. It needs to have a join between the files using
"def14227_picklist" field from AssetID_1.xml and AssetID_2.xml and
"describedObjectId" field from Picklist_1.xml and Picklist_2.xml files.
ii. After joining we need to have all the fields from the
files AssetID_*.xml and "en","gr" fields from Picklist_*.xml files.
iii. While joining we also sort the result based on the "en"
field value.
3) I was trying with "q={!join from=inner_id to=outer_id}zzz:vvv" syntax
but no luck.
Any help/suggestion would be appreciated.
Thanks,
Sukanta Dey
