StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4369004
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-12-06T17:08:41.927
FavoriteCount
0
LastActivityDate
2010-12-06T17:08:41.927
LastEditDate
LastEditorUserId
0
OwnerUserId
344215
ParentId
4365627
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Is the number before each item strictly based on position? If so, once the sort is complete you could just replace the content based on each li element. Does it matter how the URL contains the list text? In the below I operated with the assumption that it can all be appended with a querystring value of list. There are shorter ways to do this, but hopefully the verbosity will aid in understanding what happens. <pre><code><script> var listChanger = function() { //updates the digits prepended to each item in list //updates URL with text of list in querystring //accumulates the text of each list item var valueAccumulator = []; //Operate of each item in myList $('#myList li').each(function(index) { //regular expression to strip initial digits var reInitialDigits = /^\d+/; //remove initial digits var textWithoutDigits = $(this).text().replace(reInitialDigits,""); //prepend new digits (index starts at 0, so add 1 then multiply by 10 to get desired number) $(this).text(((index + 1) * 10) + textWithoutDigits); //append text to accumulator valueAccumulator.push($(this).text()); }); //querystring to strip everything after the querystring var reQueryString = /\?list\=.*$/; //placeholder var linkWithoutQueryString = ''; //remove querystring linkWithoutQueryString = $('#myLink').attr('href').replace(reQueryString,''); //change link to include URL encoded list of values $('#myLink').attr('href',linkWithoutQueryString + "?list=" + encodeURI(valueAccumulator.join("|"))); } $(document).ready(function() { //make the list sortable and each time the sorting stops, run the listChanger function $("#myList").sortable({stop:listChanger}); }); </script> <ul id="myList"> <li>10 Apple </li> <li>20 Banana </li> <li>30 Orange </li> </ul> <a id="myLink" href="mylink.html">mylink.html</a> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBest way to iterate through a 'sortable' list and then change the values accordingly
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAdolph Trudeau
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. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.