StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16935333
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-06-05T08:45:59.250
FavoriteCount
0
LastActivityDate
2013-06-05T08:45:59.250
LastEditDate
LastEditorUserId
0
OwnerUserId
50079
ParentId
16935125
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
To sort an array you use <a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/sort" rel="nofollow"><code>Array.sort</code></a> with an appropriate comparison function as an argument. The comparison function accepts two arguments, which in this case are expected to be objects with just a single property. You want to sort based on the name of that property. Getting an object's property names is most convenient with <a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys" rel="nofollow"><code>Object.keys</code></a>, so we have this comparison function: <pre><code>function(x, y) { var keyX = Object.keys(x)[0], keyY = Object.keys(y)[0]; if (keyX == keyY) return 0; return keyX < keyY ? -1 : 1; } </code></pre> It can be used like this: <pre><code>var input = [{ d: "delete the text" }, { c: "copy the text" } ]; var sorted = input.sort(function(x, y) { var keyX = Object.keys(x)[0], keyY = Object.keys(y)[0]; if (keyX == keyY) return 0; return keyX < keyY ? -1 : 1; }); </code></pre> <a href="http://jsfiddle.net/cEFg3/" rel="nofollow">See it in action</a>. Note that <code>Object.keys</code> requires a reasonably modern browser (in particular, IE version at least 9); otherwise you would need to write something such as this instead: <pre><code>var keyX, keyY, name; for (name in x) { keyX = name; break; } for (name in y) { keyY = name; break; } </code></pre> <a href="http://jsfiddle.net/fFRTD/" rel="nofollow">See it in action</a>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POJson object sort by ascending using javascript
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJon
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThe `break` is actually not necessary since it only would work reliable on one-key-objects anyway :-)
 singulars
 PostPostId
 PO
 UserUserId
 USBergi
2. CO@Bergi: True! Habit of "not doing more than you need". :-)
 singulars
 PostPostId
 PO
 UserUserId
 USJon

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.