Tree view and table view unavailable

Andres shared this problem 23 months ago
Cannot Reproduce

Hi.

In some collections tree view and the table view is not available. Only JSON view is available.

a4642b0d06ad1df0c1702a1af91a5ab6NoSQLBooster for MongoDB

Version 5.0.2 (5.0.2)

Thanks so much for your support!

Comments (3)

photo
2

It's hard to pinpoint a problem by guessing.

Could you please give me some test data and detailed steps to recall the issue locally?

photo
1

Thanks so much for your answer qinghai!

I noticed this behaviour in a normal insert document operation.

It only happens if the post request comes from another project file.

I also noticed the red string color in the Json documents. In NoSqlBooster the normal Json strings color is green. I do not know if this has anything to do with the problem.

photo
photo
1

...

photo
1

I have a similar problem.

When I run the following query for the first time, the table view is working:

db.owid.aggregate(

[{$match: {'date' : ISODate("2020-04-01T00:00:00.000+08:00")}},

{$match: {'total_cases' : {$gt: 10}}},

{$match: {'continent' : {$in: ['Asia', 'Europe']}}},

{

$group:

{

'_id':'$location'

}

}

])


When I enhanced the query to the following, the table view breaks:

db.owid.aggregate(

[{$match: {'date' : ISODate("2020-04-01T00:00:00.000+08:00")}},

{$match: {'total_cases' : {$gt: 10}}},

{$match: {'continent' : {$in: ['Asia', 'Europe']}}},

{

$group:

{

'_id':'$location'

}

},

{

$addFields: { 'country': "$_id"}

},

{

$project: { '_id': 0}

}

])


The table view remains broken even after I revert back to the first query.