I have documents with the following fields:
id
name
parent
color
The parent field is an ID of another document.
I want to select all documents where the color is red and sort the results
by the name of the parent.
Can it be done in solr?
-
I am a student IT
--
View this message in context:
Thanks reply !
I use Solr to name products for storing search information, and core
categories I use for reference, because it CATEGORY_NAME fields.
to use the sort asc | desc.
If so, the field CATEGORY_NAME on products later CATEGORY_NAME I edit. with
10 million rows is very dangerous.
-
Thanks Kranti Parisa !
I have 2 core :
products(id, product_name, category_id );
categories(category_id, category_name);
query similar SQL:
SELECT p.* from Products AS p
Inner join Categories AS c
ON p.category_id = c.category_id
Order by c.category_name asc;
Purpose sorting by category_name,
Pls! Help me.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Join-solr-tp4132615p4132830.html
Sent from the Solr - User mailing list archive at Nabble.com.
http://localhost:8081/solr/products/select?q={!join+from=category_id+to=category_id
fromIndex=categories v=$vk}*:*&vk=(sort= category_name+desc)
products( id, name, category_id);
categories( category_id, category_name)
order by desc|asc category_name
--
View this message in context:
http:/
Pls, Help me !
--
View this message in context:
http://lucene.472066.n3.nabble.com/Join-solr-tp4132615p4132625.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hi all,
A problem .
http://localhost:8081/solr/products/select?q={!join%20from=category_id%20to=category_id%20fromIndex=categories}yyy
-yyy : &sort= category_name+desc
You have a query for problem. Help me
--
View this message in context:
http://lucene.472066.n3.nabble.com/Join-solr-tp4132
Hi . all. I has table
Product (id, name, cat_id)
Category (id, name);
Select pro.id, pro.name, cat.name from Product as pro inner join Category as
cat
On cat.id = pro.cat_id
Now. In solr join core similar above
http://localhost:8081/solr/product /select?q={!join+from=cat_id+to=
id+fromIndex=cat
