Version 4 - Unwinds, cannot select middle item on the tree

Dony perdana shared this problem 2 years ago
Known

I cannot select item on the middle,if I have unwind query.

Comments (5)

photo
1

Could you please give me the detailed steps and sample script to recall the issue?

photo
1

4ae52501541309e785a919e623631567

I'm trying to select the 4th item and, the third is highlihted, and if i click, the third one that expand.

i'm using 3 version, 3.4.0, 3.4.2, and 3.4.4.

on version 3.4.4, this issue is not happening.

thanks for the support.

photo
1

This question is related to the specific data, Could you please make a few test docs that can reproduce the problem for me?

photo
1

experiencing the same issue

when preforming an aggregation operation, the UI of the results tree acts weird.

my query looks like this:

db.boxes.aggregate([

{$match:{published:true}},

{$project:{"products.variants.url":1}},

{$unwind:"$products"},

{$unwind:"$products.variants"}

])


and a "Box" document looks like this:

const BoxSchema = new mongoose.Schema({

name: {type:String, trim:true},

description:{type:String, trim:true},

copiedDescription: {type:String, trim:true},

boxImage:{

type: String,

default: null

},

gridImage:{

type: String,

default: null

},

cardGridImage:{

type: String,

default: null

},

createdBy: String,

products: [{

variants:[{

title:String,

description:String,

url:String

price:Number

}]

}],

}});

thanks

photo
1

Thank you for your feedback. If possible, Can you give me some test data to quickly reproduce the problem locally?

And, Which platform are you using? Windows, Mac or Linux?

How about your MongoDB server Version? 3.2, 3.4 or 3.6?

photo
1

Using windows 10,

mongo version 3.4

the bug happens in both noSqlBooster, and in mongoBooster

sample data :

{

"boxes": [

{

"_id": "5a1d4ba5dcdb2d1cfd18f40c",

"copiedName": "World of Leather",

"copiedDescription": "It’s hard to find great gifts for guys! Not anymore – Leathertastic features a travel toiletry bag, bottle opener, leather wallet & leather key ring. Super practical & stylish.",

"boxImage": "http://res.cloudinary.com/givo-ai/image/upload/v1515060687/5a1d4ba5dcdb2d1cfd18f40c.png";,

"gridImage": null,

"cardGridImage": null,

"products": [

{

"_id": "5a1d4df0dcdb2d1cfd18f413",

"variants": [

{

"_id": "5a1d4df17efabeae0dfd9daa",

"copiedTitle": "Bottle Opener",

"copiedDescription": "American Flag bottle opener made from coated mild steel that fits perfectly in wallets.",

"asin": "B075831RX6",

"price": "1000",

"formattedPrice": "$10.00",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B075831RX6";

}

]

},

{

"_id": "5a1d4df9dcdb2d1cfd18f415",

"variants": [

{

"_id": "5a1d4dfa7efabeae0dfd9dab",

"copiedTitle": "Kattee Travel Toiletry Bag",

"copiedDescription": "army green Canvas Leather Cosmetic Organizer ",

"asin": "B01N1ZJ8BI",

"price": "1090",

"formattedPrice": "$10.90",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B01N1ZJ8BI";

}

]

},

{

"_id": "5a1d4fc5dcdb2d1cfd18f418",

"variants": [

{

"_id": "5a1d4fc67efabeae0dfd9daf",

"copiedTitle": "Hammer Anvil Leather Wallet",

"copiedDescription": "Minimalist Leather Slim Front Wallet",

"asin": "B00N9OPF3Q",

"price": "999",

"formattedPrice": "$9.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00N9OPF3Q";

}

]

},

{

"_id": "5a1d5399685ea91681036f37",

"variants": [

{

"_id": "5a1d53997efabeae0dfd9db5",

"copiedTitle": "Hide & Drink Key Ring Holder",

"copiedDescription": "Rustic Key Ring Holder hand crafted with the finest Full Grain Leather",

"asin": "B01GOOF6MW",

"price": "1499",

"formattedPrice": "$14.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B01GOOF6MW";

}

]

}

],

"calculatedPrice": 66

},

{

"_id": "5a1bdb524b7b0648d334b0b2",

"copiedName": "Artsy Fartsy",

"copiedDescription": "The Artsy Fartsy box will get the creative juices flowing in any budding creative, featuring a backpack, notebook and pencil case. Because let's face it - when you look the part, you feel the part!\n",

"boxImage": "http://res.cloudinary.com/givo-ai/image/upload/v1515060623/5a1bdb524b7b0648d334b0b2.png";,

"gridImage": null,

"cardGridImage": null,

"products": [

{

"_id": "5a1bdb5edc84b142384bc794",

"variants": [

{

"_id": "5a1bdb5e7efabeae0dfd9d25",

"copiedTitle": "Zebella leather Backpack",

"copiedDescription": "professional manufactured, roomy and Light Weight.",

"asin": "B00MA5VH4Q",

"price": "2899",

"formattedPrice": "$28.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00MA5VH4Q";

}

]

},

{

"_id": "5a1bdb6c4b7b0648d334b0b4",

"variants": [

{

"_id": "5a2fdb0a7efabeae0dfda08f",

"copiedTitle": "Denik Obsidian Layflat Notebook",

"copiedDescription": "lined softcover journal with a watercolored cover and foiled lettering",

"asin": "B0731N9P5F",

"price": "999",

"formattedPrice": "$9.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B0731N9P5F";

}

]

},

{

"_id": "5a1bdb8ddc84b142384bc796",

"variants": [

{

"_id": "5a1bdb8d7efabeae0dfd9d27",

"copiedTitle": "Leder nature Leather pouch",

"copiedDescription": "\"Felix\" practical multi-purpose pouch holds your writing utensils and more",

"asin": "B01M0Y8LVQ",

"price": "999",

"formattedPrice": "$9.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B01M0Y8LVQ";

}

]

}

],

"calculatedPrice": 69

},

{

"_id": "5a11ba96255d0419083c33f6",

"copiedName": "Hungry Outdoorsman",

"copiedDescription": "Be prepared for all your food needs while out in the wilderness. Hungry Outdoorsman features pocket axe multi-tool, cutlery multi tool, unique water bottle, and aluminum lunch box.",

"boxImage": "https://res.cloudinary.com/givo-ai/image/upload/v1519723115/5a11ba96255d0419083c33f6.png";,

"gridImage": null,

"cardGridImage": null,

"products": [

{

"_id": "5a11ba9b6ca18878fe5ac973",

"variants": [

{

"_id": "5a11ba9c7efabeae0dfd9a0d",

"copiedTitle": "Pocket Axe Multi-Tool",

"copiedDescription": "Gentlemen's hardware is proud to introduce it's manliest multi-tool to date: the 10 - in - 1 axe multi-tool! all camping expeditions are incomplete without it",

"asin": "B01NBTM085",

"price": "2500",

"formattedPrice": "$25.00",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B01NBTM085";

}

]

},

{

"_id": "5a11baae255d0419083c33f9",

"variants": [

{

"_id": "5a11b9dd7efabeae0dfd9a0b",

"copiedTitle": "Camping Cutlery Multitool",

"copiedDescription": "Gentlemen's Hardware presents its handy and stylish multitools. No feast is too much for this clever camping cutlery gadget. Includes spoon, fork, corkscrew, foil cutter, penknife and bottle opener.",

"asin": "B01DOA073W",

"price": "1169",

"formattedPrice": "$11.69",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B01DOA073W";

}

]

},

{

"_id": "5a11bac46ca18878fe5ac975",

"variants": [

{

"_id": "5a11ba087efabeae0dfd9a0c",

"copiedTitle": "Thirst Trendy Bottle",

"copiedDescription": "Fire extinguisher replica water bottle with a metal casing looks just like the real thing. Great size to keep your thirst quenched all day long.",

"asin": "B01M3X33V0",

"price": "2299",

"formattedPrice": "$22.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B01M3X33V0";

}

]

},

{

"_id": "5a11bae7255d0419083c33fb",

"variants": [

{

"_id": "5a11bae77efabeae0dfd9a0e",

"copiedTitle": "Aluminum Lunch Box",

"copiedDescription": "Store your sandwiches in the gentlemen's hardware Snap-shut aluminum lunch tin.",

"asin": "B00NRZEFFQ",

"price": "2400",

"formattedPrice": "$24.00",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00NRZEFFQ";

}

]

}

],

"calculatedPrice": 104

},

{

"_id": "5a1409920fda7e0a76d066b3",

"copiedName": "Cognac Magic",

"copiedDescription": "For someone who likes to finish a long day with a glass of cognac. Cognac Magic features a brandy guide, brandy warmer, and a four-piece cognac glass set.\n",

"boxImage": "http://res.cloudinary.com/givo-ai/image/upload/v1515062135/5a1409920fda7e0a76d066b3.png";,

"gridImage": null,

"cardGridImage": null,

"products": [

{

"_id": "5a14099687582c6836f5247d",

"variants": [

{

"_id": "5a140a8e7efabeae0dfd9a95",

"copiedTitle": "Classic Brandy book",

"copiedDescription": "Far-ranging guide to the brandies of the world. The histories of the brands, their techniques, and their tastes expertly described by renowned writer on spirits.",

"asin": "1853753335",

"price": "7724",

"formattedPrice": "$77.24",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/1853753335";

}

]

},

{

"_id": "5a1409a80fda7e0a76d066b5",

"variants": [

{

"_id": "5a1409a87efabeae0dfd9a93",

"copiedTitle": "Old Dutch Brandy Warming set",

"copiedDescription": "4 pc Set includes snifter, stand, candle cup and tea light candle. Just add brandy to experience the release of mouth-watering aromas and flavors.",

"asin": "B00014CQ8Y",

"price": "1699",

"formattedPrice": "$16.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00014CQ8Y";

}

]

},

{

"_id": "5a1409be87582c6836f5247f",

"variants": [

{

"_id": "5a1409bf7efabeae0dfd9a94",

"copiedTitle": "Cognac Glass Set",

"copiedDescription": "four Cognac Glasses that are substantial and attractive. Presenting the classic cognac glass profile. ",

"asin": "B00JB02S3W",

"price": "1499",

"formattedPrice": "$14.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00JB02S3W";

}

]

}

],

"calculatedPrice": 130

},

{

"_id": "5a1d564f685ea91681036f3c",

"copiedName": "Golfing Expert",

"copiedDescription": "For all the Golf Experts. Featuring a ball towel, groove tool, fastening straps, golf towel and golf hat. Now that’s what you call a hole in one!\n",

"boxImage": "http://res.cloudinary.com/givo-ai/image/upload/v1515060675/5a1d564f685ea91681036f3c.png";,

"gridImage": null,

"cardGridImage": null,

"products": [

{

"_id": "5a1d5730685ea91681036f46",

"variants": [

{

"_id": "5a1d56617efabeae0dfd9dba",

"copiedTitle": "Frogger Golf Amphibian Ball Towel",

"copiedDescription": "Frogger Golf \"Award winning\" Amphibian ball towel features a dual folded, wet and dry design and a waterproof membrane. ",

"asin": "B0035YSC30",

"price": "1195",

"formattedPrice": "$11.95",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B0035YSC30";

}

]

},

{

"_id": "5a1d575cdcdb2d1cfd18f423",

"variants": [

{

"_id": "5a1d575c7efabeae0dfd9dbe",

"copiedTitle": "Golf Club Groove Tool by VersaGolf",

"copiedDescription": "Do not buy new clubs, use the VersaGolf TruGroove tool to sharpen and clean your club grooves and extend the life of your irons and wedges.",

"asin": "B00JHOO1QY",

"price": "1388",

"formattedPrice": "$13.88",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00JHOO1QY";

}

]

},

{

"_id": "5a1d58e4685ea91681036f4a",

"variants": [

{

"_id": "5a1d58e47efabeae0dfd9dc0",

"copiedTitle": "Frogger Golf Universal Rangefinder Latch",

"copiedDescription": "Rangefinder Latch-It securely attaches your rangefinder to golf carts for quick, easy access.",

"asin": "B0722P9TDY",

"price": "1999",

"formattedPrice": "$19.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B0722P9TDY";

}

]

},

{

"_id": "5a1d5a53dcdb2d1cfd18f428",

"variants": [

{

"_id": "5a1d5a547efabeae0dfd9dc3",

"copiedTitle": "Greenside Microfiber Golf Towel",

"copiedDescription": "This 3 pack for microfiber waffle weave golf towels are the perfect design for any golfer. Each towel is sized to be taken with you to the green.",

"asin": "B00WJAQGYS",

"price": "1695",

"formattedPrice": "$16.95",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00WJAQGYS";

}

]

},

{

"_id": "5a1d5b1d685ea91681036f4f",

"variants": [

{

"_id": "5a1d5b1e7efabeae0dfd9dc7",

"copiedTitle": "Nike Men's Adjustable Golf Hat ",

"copiedDescription": "Nike Swoosh Left Logo cap",

"asin": "B0148KW0UK",

"price": "1700",

"formattedPrice": "$17.00",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B0148KW0UK";

}

]

},

{

"_id": "5a3a3a158a664a3c44be22c0",

"variants": [

{

"_id": "5a3a3a167efabeae0dfda18e",

"copiedTitle": "Laser Golf Rangefinder",

"copiedDescription": "Laser Golf RangeFinder with advanced Slope function is an advanced laser range finder system that rapidly provides an accurately measures distances of up to 500m",

"asin": "B00UR4TEI8",

"price": "17999",

"formattedPrice": "$179.99",

"leadingImage": "http://res.cloudinary.com/givo-ai/image/upload/c_fit,f_auto,w_100/B00UR4TEI8";

}

]

}

],

"calculatedPrice": 280

}

]

}

photo
photo
1

Thank you for your feedback.

We have worked out a new test build to resolve the issue, please download it and give it a try.

Win: https://s3.mongobooster.com/download/releasesv4/nosqlbooster4mongo-4.5.3.exe

photo
1

Hey,

Seems to work fine.

Thanks a lot

photo