Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>None of the answers so far have touched on the real problem with custom sort order and that is what happens when two different people want the same records sorted differently. </p> <p>If you need a custom sort order, you need a related table to store it in, not an additional field. The table would have the userid, the recordId of the data and the sort order for the record. That way Joe Smith can have one order and Sally Jones another for the same data. Now you have the problem of new records being added to the data set. Do you put them at the beginning of the sort order or the end or do you require the person to set an order for them before they can be added to the set. This is in actuality a very complex porblem that is generally not worth the amount of time it takes to implement becasue almost no onne ever uses that system once it's inplace (I mean do I really want to go through a hundred records and mark the individual order of each one?). Now it gets complicated interms of saving the order of all the records (which will of course require changes the next time the query is run since there will be new records.) This is very painful process of limited untility.</p> <p>I did this once in a proposal writing appliction because we needed to be able to sort the parts and tasks on the propoasal in the order we thought woudl be most impressive to the customer. Even then, we had to institute a default order, so that they only neede to move around teh two or three things they really wanted to show up first instead of ordering 10,000 individual parts.</p> <p>A better choice if you can get them to buy off on it, is to allow them to sort the data by columns (desc or asc). Usually the user interface can be designed so that if you click on a column header, it will resort the data by that column. This is relatively straightforward to do and meets most needs for custom ordering. </p> <p>You really need to discuss this requirement with management and get details of how they want it to work beyond, I want custom ordering. This is often one of those things people think they want, but don't really use. </p>
    singulars
    1. This table or related slice is empty.
    1. POWhat's the best way to store sort order in SQL?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USHLGEM
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat's the best way to store sort order in SQL?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CO+1 for getting spec from the end user but moreover for the detail in explanation
      singulars
      1. PO
      1. USKris.Mitchell
    2. COGood answer. I will check with them about requirements but I believe it's going to end up completely customisable order, but probably one global order. The order will only be editable by admin and will be used by all users.
      singulars
      1. PO
      1. USAnthony
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload