Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I believe isotope caches sorts so it doesn't have to recalculate a sort that it has already done. It even does this on "random" it seems.</p> <p>A fix/hack is to <code>reloadItems</code> after the random sort:</p> <pre><code>$('#reorder').click(function () { $('.container').isotope({sortBy: 'random'}).isotope('reloadItems'); }); </code></pre> <p>Demo: <a href="http://jsfiddle.net/nT66r/" rel="nofollow">http://jsfiddle.net/nT66r/</a></p> <p>As for filtering the menu item, random simply returns a random number, so there is not a lot you can do. However, you can write a custom random sort which would allow you to "filter" the menu:</p> <pre><code>getSortData: { name: function ($elem) { return $elem.data('name'); }, myrandom: function ($elem) { if($elem.hasClass('menu')) { return -1; } return Math.random(); } } </code></pre> <p>Demo: <a href="http://jsfiddle.net/PvnMn/" rel="nofollow">http://jsfiddle.net/PvnMn/</a></p> <p>Note, because <code>menu</code> is a class, you leave yourself open to some possible weirdness if there are multiple <code>menu</code> items. If you only have one, an ID is a better choice. In that case, you would use <code>$elem.is('#menu')</code> instead of <code>$elem.hasClass('menu')</code>.</p> <p>With <code>#menu</code>: <a href="http://jsfiddle.net/PvnMn/1/" rel="nofollow">http://jsfiddle.net/PvnMn/1/</a></p> <p>Here is a version with my stab at filtering for other sorts: <a href="http://jsfiddle.net/jtbowden/Vuqgu/" rel="nofollow">http://jsfiddle.net/jtbowden/Vuqgu/</a></p>
    singulars
    1. This table or related slice is empty.
    1. POisotope resort without moving the first element
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJeff B
    1. USJeff B
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POisotope resort without moving the first element
      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. VTAcceptedByOriginator
    1. COThis doesn't seem to work for me. It worked the first time I tried it, but on subsequent sorts and page loads it reordered at random again. Good info to know though, I didn't realize it cached the values for sorts.
      singulars
      1. PO
      1. USShortRound1911
    2. COIsn't it supposed to reorder at random? Sorry, it is not clear to me what problem you are having.
      singulars
      1. PO
      1. USJeff B
    3. COAh sorry for the vague question. I'm trying to shuffle all elements BUT the first element (the menu). So I'd like the menu to stay in place as the first element and have all other isotope elements reorder randomly. I updated the question a bit for clarity.
      singulars
      1. PO
      1. USShortRound1911
 

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