How do we add order by on php side ?

ksubba commented 11 years ago

I need to default SQL order to 'id desc' , now how do I do that ? That was easy on previous version, couldn't find about it on documentation either.

Please advice ? Kaushal

optikalefx commented 11 years ago

in the js just do

orderBy: "id",
sort: "desc"

ksubba commented 11 years ago

Thanks !

Kaushal

ksubba commented 11 years ago

Just a suggestions if it might help lot of folks like me. I think you need to create a example setup with big list of all parameters used (well commented) for both JS and PHP calls.

Example: http://jquery.malsup.com/cycle/options.html

Thx Kaushal

optikalefx commented 11 years ago

In the documentation, square-bracket.com/openjs go to the bottom and click "advanced". There are all your options.

Though what you sent me is just a copy and paste from their code - and all of my code is fully commented hence the "open" in openJS. So if you just pop open grid.js you get to see and read about all the nice options you have.

ksubba commented 11 years ago

Sure, just trying to add in with feedback so your already awesome product is easy for implementation to all the levels of programmers. While it's already easy enough I couldn't find the ordering option on documentation even on the advanced view.

Yeap reading the code is an option, but not quick way to find it out :)

for instance order and sort option doesn't seems to be a part of ops at a first glance.

  // default settable options
  opts : {
      title : "",                 // title attribute on this table
      action : "",                // action url on this table  
      nRowsShowing : 10,          // number of rows to show on load
      minAllowedColWidth : 50,    // when auto sizing columns, they can't be less than this size
      minWidthForDynamicCols : 20,// dynamic cols, like row number and checkboxes have a smaller min width
      class : "",                 // classes on this table
      showPager : true,
      deleting : false,
      deleteConfirm: true,
      checkboxes : false,
      rowNumbers : false,
      editing : false,
      width : "100%",
      rowHeight : null,           // this is null to start because if you dont use it, it doesn't loop through stylesheets
      page : 1
  },

Thanks Kaushal

optikalefx commented 11 years ago

my god you're right. Great catch!

ksubba commented 11 years ago

Sure buddy .. glad I could add something for the good :)

I am creating a PHP CRUD class by using openjsgrid and another awesome project: http://code.google.com/p/php-form-builder-class/

You both have embraced bootstrap open hearty which is a GREAT choice.

Keep up a great work.

optikalefx commented 11 years ago

Thanks! Glad you like the project, stay tuned for pushed updates

optikalefx / OpenJS-Grid

How do we add order by on php side ? #18