Table view array/object head as field1.field2
Example json:
{
"_id" : ObjectId("518c42ba4a87f9b1ca48f3a4"),
"name" : "images",
"datesDif" : {
"average" : NumberLong(3600),
"min" : NumberLong(3598),
"max" : NumberLong(3602)
}
}
If you use the table view and you have some columns with multidimensional arrays/objects you must click on the cell to open and see the values of these multidimensional arrays/objects. But the other data is gone except for the _id field. What i like to see is that the multidimensional arrays/objects data is shown in the table.
Here are some examples to explain more what i mean;
How it now works:
The head of the table looks like with the data under the field names:
_id | name | datesDif
Then i click on the datesDif field and i see
_id | average | min | max
I would like to see this (no click necessary):
_id | name | datesDif.average | datesDif.min | datesDif.max |
Maarten Dreves
shared this idea
Allowed to Show Embedded Fields in Large Table View
-
Maarten Dreves
commented
Thats a good one Thomas! Didnt think of that one.
i have 2 theories about this.
1. If you use large array's just use the current tableview.
2. Or you can build the tableview so that you expand the object/array if you klik on it so you get more columns instead of a new page with the new columns. -
Ygor Lemos commented
+1 for this! you already kinda do this on the CSV exports. Showing nested data on tableview mode would be superb.
-
Kevin (Dillard's)
commented
There is a similar view inside of NoSQL Manager for MongoDB where it displays the inner json version of the object/array field inside the table's cell. Probably would need to function similarly, but maybe with a setting to limit on the number of elements/fields before it would force back to the current table view implementation.
-
Thomas (3T)
commented
Yes, that would indeed be very useful.
How do you suggest to treat arrays - especially those with many, many elements?
Arrays are really also just subdocuments with hard-coded fields "0", "1", etc.