StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSuggestions of outputting JSON as a table - jQuery.tmpl? Something else?
primarykey
Id
9181581
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2012-02-07T18:16:46.590
FavoriteCount
0
LastActivityDate
2017-07-26T17:10:18.937
LastEditDate
2017-07-26T17:10:18.937
LastEditorUserId
4370109
OwnerUserId
490154
ParentId
0
PostTypeId
1
Score
0
ViewCount
270
LastEditorDisplayName
text
Body
I've got JSON being returned from the server. I'll paste the 2 first records here (long), but in theory it could be 100's. <pre><code>{ "1": { "text": "First Thoughts and Feelings", "filters": { "2": { "text": "% Postive", "banners": { "2": { "text": "Ontario", "val": "46.1907" }, "3": { "text": "Quebec", "val": "47.9016" }, "1": { "text": "Total Respondents", "val": "52.9057" } } }, "1": { "text": "Net Positive", "banners": { "2": { "text": "Ontario", "val": "51.9106" }, "3": { "text": "Quebec", "val": "50.7760" }, "1": { "text": "Total Respondents", "val": "47.9157" } } } } }, "2": { "text": "Purchase Intent", "filters": { "2": { "text": "% Postive", "banners": { "2": { "text": "Ontario", "val": "54.5407" }, "3": { "text": "Quebec", "val": "53.9017" }, "1": { "text": "Total Respondents", "val": "49.7267" } } }, "1": { "text": "Net Positive", "banners": { "2": { "text": "Ontario", "val": "51.7294" }, "3": { "text": "Quebec", "val": "52.7261" }, "1": { "text": "Total Respondents", "val": "52.9762" } } } } } } </code></pre> I want to put this data into a table, where there is basically a column for question (the root text), the filter, and then each banner. I'd create a thead like this <pre><code><thead> <tr> <th>Question</th> <th>Filter</th> <th>Ontario</th> <th>Quebec</th> <th>Total</th> </tr>... </code></pre> I'm trying to figure out the best way to populate this table given that the number of banners is dynamic, could be 2, could be 20. If there are 2 questions, 2 filters, with 3 banners each, I need a table consisting of 5 columns, 4 rows (excluding headers). <pre><code>Row 1 -> Q1 -> filter1 -> banner1 -> banner2 -> banner3 Row 2 -> Q1 -> filter2 -> banner1 -> banner2 -> banner3 Row 3 -> Q2 -> filter1 -> banner1 -> banner2 -> banner3 Row 4 -> Q2 -> filter2 -> banner1 -> banner2 -> banner3 </code></pre> Ideally sortable too I guess, but any column, though I know I can add that type of functionality with jQueury afterwards. Looking for suggestions on how to get this done as I'm having trouble wrapping my head around it.
Tags
<javascript><jquery><json><html-table><jquery-templates>
Title
Suggestions of outputting JSON as a table - jQuery.tmpl? Something else?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMcB
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.