jQuery Grid Plugin – jqGrid

hi, before i start to test this new version, i would like to thank you so much for your huge work. it had been very useful

very good!
thank you very mach!

Hi there,

Nice work again and the documentation is so easy to read, well done and thanks for the hard work!! So here’s my question (same as posted in “Grid 3 final preview”):

Do you plan on introducing a mode that allows multiple select of rows based on drag/drop operation, i.e. via a transversal mouse drag across the grid ?

Nicolas

Hi Nicolas,

I really do not understand what you mean 🙁 . Sorry. If I look into the example that you publish in previous post I see that only particular cell is validated at server – nothing more.

Please explain me in detail what you mean.

Regards
Tony

do you no Show/hide columns?

Yes – this can be done via methods – showCol, hideCol – see documantation for more details

Regards
Tony

Hi, first a huge thank is in order for this amazing plugin. Brilliant; thanks a lot.

Now from the preview version to the final release, I am getting a slight problem with the method “sortGrid”;

Data is fed using javascript; Records are not in order and while entering I would like to sort by the date field; Now I have tried setting “sortName” and “sortOrder” while initializing the grid which didn’t work. The way I had the preview version to work was to call “sortGrid” method before/after adding the data.

jQuery(“#smslog”).sortGrid(“dts”,false);
for(var i=0;i<=mydata.length;i++) jQuery(“#smslog”).addRowData(i+1,mydata[i]);

on final release, on loading the page, it is always displaying in ascending order; I have tried setting “setSortOrder” to both “asc”/”desc” without any luck; finally as a workaround I am using

jQuery(“#smslog”).sortGrid(“dts”,false);
for(var i=0;i<=mydata.length;i++) jQuery(“#smslog”).addRowData(i+1,mydata[i]);
jQuery(“#smslog”).sortGrid(“dts”,false);

Not very efficient; any idea?

Also, calling the method “setSortName” is returning an error “p is null or not an object”

jQuery(“#smslog”).setSortName(“dts”)

thanks once again for this brilliant code.

regards
Rana

When I selected a data line time, how to get this data, there is a problem
Initialization do not show how that data will only show a title, and then I click the right button in time that the data will show that there should be a boolean value!

how to get data use a onSelectRow ?

@Rana,
There is a bug in setSortName – it is corrected – Thank you.
If you call setSortName or setSortOrder after that you should call trigger(“reloadGrid) to have this effect – that is:
1. add data
2.setSortName or/and setSortOrder
3. trigger(“reloadGrid”)

sortGrid do this at once.
There is other issue with sorting which I should resolve.

If data is local these methods should be called after the data is populated and not before. If you add data via addRowData grid does not recognize that data should be sorted when the row is added. With other words your first call of sortGrid is not needed.

@Handan
Maybe here is the solution

onSelectRow: function (rowid) {

mydata = jQuery(“#mygrid”).getRowData(rowid)
// my data is array that have a selected row values
…
}

For more information read API methods in Documentation section

Regards
Tony

Hi Tony,

where can I download the new release?

As an idea, can we get onMouseOver as an event or perhaps a way to change the look of the alt tags : that would be awesome;

Thanks once again.

Rana

Hi,
I plan to publish the bug fix release at end of this week.

As for the altRows – you can change this in the css – see alt rows.
If you want to do that dynamically you can make something like:
$(“table.scroll tr.alt td”,”#mygridid”).css(“background-color”,”mycolor”)

Documentation section
hidegrid Type: boolean
Enables or disables the hide grid button, which appear into the right side of the Caption layer. Have sense only if caption parameter is not empty string.
Default value: true !

how to hide grid? not hide gird button?
When I JQGrid initialization time, how kind hidden Grid, show only Caption

Hi Tony,

My question in more details:

Try going to this address: http://www.zapatec.com/website/main/products/grid/demo.jsp#editable_autosave_cell.html

Now, with your mouse start from the upper left corner of the grid, hold down the mouse button and drag down to the bottom right corner.
You will notice that a “rectangle selection“ (tranparent div with dashed border) draws over the rows wich activates an alternate state (color) for each row hovered in the grid.

Well that’s what I mean. I’d like to enable users to “select” multiple consecutive rows.

In the end my goal is to be able to re-arrange the grid by moving those selected rows up or down like in this example:
http://www.dhtmlgoodies.com/scripts/arrange-nodes/arrange-nodes-d2.html
but with multiple rows at a time.

I’m describing it right ? Bear with me I’m french 😉
Tx for your time.
Nicolas

@Handan,
If you set a caption the button is displayed automatically according to the option hidegrid. If you do not set caption this options remain true, but the caption is not displayed.

@Nicolas,
At end I understand what you mean 🙂 . I’m not sure that this will be done at near future, but you can try integrate the dragable plugin combined with loadComlete event – i.e. use loadComplete to bind dragging of each row.

Regards
Tony

Hi and thanks for the great plugin,

I may feel completly n00b on this but i dont understand where does the $responce variable comes from in your php examples. Could you enlight me please ?

Tx for the advice tony, I keep you updated with this implementation once we’re done.
cheers,
Nicolas

hi ,
Can any one tell me how to hide page navigation buttons in editgrid