solr grouping

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

solr grouping

swap
I have document in solr as mentioned below

{
        "event_name":"product viewed",

"event_property":["category","product_name","product_code","price","brand","color","discount","is_new_visitor"],
        "event_value":["category-sunglasses","product_name-david blake grey
sunglasses","product_code-lcsgdb364x1880gryx""price-590","brand-david
blake","color-grey","discount-70"],
        "session_id":"mf1545212054754888840",
        "company_id":"31",
        "created":1545212153,
        "email":"[hidden email]",
        "name":"tttt"
},
{
        "event_name":"product viewed",

"event_property":["category","product_name","product_code","price","brand","color","discount","is_new_visitor"],
        "event_value":["category-sunglasses","product_name-david blake grey
sunglasses","product_code-lcsgdb364x1880gryx""price-590","brand-david
blake","color-grey","discount-70"],
        "session_id":"mf1545212054754888840",
        "company_id":"31",
        "created":1545212153,
        "email":"[hidden email]",
        "name":"tttt"
}

i need to query and group email with filtered query fq as mentioned below

http://solr-url/solr/solr-core/select?q=:&fq=((event_name:"product+viewed"+AND+event_property:"product_name"+AND+event_value:"category-sunglasses")+AND+(event_name:"add+to+cart"+AND+event_property:"product_name"+AND+event_value:"category-sunglasses"))&group.limit=1&group.ngroups=true&group=true&group.field=email

i need filter query
(event_name:"product+viewed"+AND+event_property:"product_name"+AND+event_value:"category-sunglasses")
with "AND" on
event_name:"add+to+cart"+AND+event_property:"product_name"+AND+event_value:"category-sunglasses")

In response i am not getting the email e.g user who as performed both event
e.g "product viewed" and "add to cart".

document have email and activity perform by user in event key.now i need to
make request to group email to find unique email using filter query.i have
used the query mentioned below







--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html