fieldcollapsing - Solr grouping using a comma separated field value -

-

i have comma separated field value called 'categories' have indexed & stored using custom field type defined as:

<fieldtype name="text_comma_delimited" class="solr.textfield">       <analyzer>         <tokenizer class="solr.patterntokenizerfactory" pattern="," />       </analyzer> </fieldtype>

and defined field as:

<field name="categories" type="text_comma_delimited" indexed="true" stored="true" />

now want products grouped these categories use simple grouping query this:

http://localhost:8089/solr/products/select?q=*:*&wt=json&indent=true&group=true&group.field=categories&group.limit=-1&rows=-1&group.ngroups=true&group.facet=true

but result gives 2 groups instead of 6. seems considering one-one relationship between product , category hence 1 product appearing once should 1 many. 1 product can appear in more 1 categories. here result:

{   "responseheader":{     "status":0,     "qtime":2,     "params":{       "fl":"category,sku",       "group.ngroups":"true",       "indent":"true",       "start":"0",       "q":"*:*",       "group.limit":"-1",       "group.field":"category",       "group":"true",       "wt":"json",       "group.facet":"true",       "rows":"-1"}},   "grouped":{     "specialties":{       "matches":6,       "ngroups":2,       "groups":[{           "groupvalue":"fiction",           "doclist":{"numfound":3,"start":0,"docs":[               {                 "sku":"f5678",                 "category":"fiction,abc,xyz"},               {                 "sku":"f9876",                 "category":"fiction,abc,pqr"},               {                 "sku":"f2365",                 "category":"pqr,fiction"},               ]},         {           "groupvalue":"technical",           "doclist":{"numfound":1,"start":0,"docs":[               {                 "sku":"t9876",                 "category":"cvb,technical"}]           }}]}}}

i tried faceting , shows correct count each category url:

http://localhost:8089/solr/products/select?q=*:*&wt=json&indent=true&facet=true&facet.field=categories

the result gives me perfect list , count, above grouping response falls short of data:

"facet_counts":{     "facet_queries":{},     "facet_fields":{       "categories":[         "fiction",3,         "mystery",1,         "sci-fi",1,         "self help",1,         "technical",1,         "philosophy",1         ]},     "facet_dates":{},     "facet_ranges":{}}}

also, 'load term info' in schema browser of solr admin console shows above field values , count. group query not returning correctly. else can tried this? appreciated.


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more