Hi!, to sort grid columns im using
function customColumnSort(ind)
{
if (ind == 0)
{
var a_state = mygrid.getSortingState();
window.s_col = ind;
window.a_direction = ((a_state[1] == “des”)?“asc”:“des”);
//alert( “HERE!” );
reloadGrid();
return true;
}
}
but if i uncomment the alert msg every time i click on the “0” column… alert appears twice…why is that? Im debbugin the server side, and do the following SQL…
When Page Load First - This is Ok…
SELECT * FROM (
SELECT IT_., ROWNUM AS RN_ FROM (
SELECT * FROM IDS_OD_FORMULA ORDER BY NOMBRE ASC
) IT_ ) WHERE RN_ > 0 AND RN_ <= 50 ORDER BY NOMBRE ASC
When i click to Order executes 3 SQL’s — WHY Goes to Server 3 times?
SELECT * FROM (
SELECT IT_., ROWNUM AS RN_ FROM (
SELECT * FROM IDS_OD_FORMULA ORDER BY NOMBRE DESC
) IT_ ) WHERE RN_ > 0 AND RN_ <= 50 ORDER BY NOMBRE DESC
SELECT * FROM (
SELECT IT_., ROWNUM AS RN_ FROM (
SELECT * FROM IDS_OD_FORMULA ORDER BY NOMBRE ASC
) IT_ ) WHERE RN_ > 0 AND RN_ <= 50 ORDER BY NOMBRE ASC
SELECT * FROM (
SELECT IT_., ROWNUM AS RN_ FROM (
SELECT * FROM IDS_OD_FORMULA ORDER BY NOMBRE ASC
) IT_ ) WHERE RN_ > 0 AND RN_ <= 50 ORDER BY NOMBRE ASC
For which event customColumnSort attached?
If it attached to onSort event it may have sense to use
reloadGrid();
return false;
<< this will block any default reaction
}
Also, if you are using grid in paging mode - there is an issue in current version of grid, on grid clearing additional request to server can be sent to server side script
( if its your case - please constact us at support@dhtmlx.com - we will send you updated js file )
Ok, i already solve this thanks anyway.