[argopmParticipant]

That’s perfect for #3, thanks so much. Will check on #1 and #2 and i am sure it will work as you said.

Thanks again,
MP.

[argopmParticipant]

Hi Dimitar,
Yes for

For #1 custom sorting can be done but was not able to implement that successfully. It was not working (sort of working ) but gird was not showing up/down arrow in column header. Not sure why.
For #2: I ment by sortfield at column level not via api. What i wanted is to use inbuild jqxgrid sorting but can specify like sortfield like below:

{text:’S/N’,datafield:’stn’,width:”3%”,cellclassname: cellclass,sortable:true,sortfield:”sname”, sorttype:’case_insensitive’}

Sorry but next question: Do we have any in build property of grid that can indicate whether select all checkbox is clicked or in intermediate state?

Regards,
MP.

[argopmParticipant]

Hello Dimitar,
Thanks for letting me know and i have used updatebounddata method instead of databind and it’s working. A few things:
1) Is it possible to specify case insensitive sorting? I know we can define custom sort function but just thinking if there’s any direct way?
2) Is it also possible to specify sort field? For example i have a filed called ‘quantity’ but want to sort it using ‘quantity_int’ field as my ‘quantity’ field have KG as suffix with it.?
3) Where can i get the $.jqx.cookie documentations? I am thinking to save grid state in cookies and then reload on page refresh? Right now it doesn’t seems to store complete object.
4) Is there any place where i can override the tooltip value for cells?

Thanks so much for you help.
Regards,
MP.

[argopmParticipant]

OK, just got solution of loosing sorting by using below code from a old forum thread

$("#jqxgrid").jqxGrid('databind', getDataAdapter() , 'sort');

But would it also preserve any filter applied?

Regards,
MP.

[argopmParticipant]

Hello Dimitar,

Thanks this is working as expected. Thought i was also able to get the my original solution working with below approach (just mentioning if someone else might need it). My issue was checkbox cells were background color when page is resized so i captured the global window resize event and just re-added the background to the cells.

I will test this solution for couple of days and in case of having issues i will switch to your code.

Thanks so much, you are really helpful. Ohh just another thing; have you seen grid to loose the sorting when grid is reloaded. In my case my grid is reloaded in each 60 second but after reload last sorted column is no more sorted (even none of the column is sorted). Below is my reload code:

$("#jqxgrid").jqxGrid({ source: getDataAdapter() });

Regards,
MP.

[argopmParticipant]

Hi Dimitar,
Ok, then can i add custom control on grid header, like if i want to create custom select all/deselect all. But i think this way i will have to manually add logic to select/deselect row or enable checkbox selection.

Can you suggest any idea to me?

Regards,
MP.

[argopmParticipant]

Hi Dimitar,

Thanks for the reply, it’s very unfortunate that i could not get any event when grid is re-rendered. So any other work around for me to apply cellclassname for checkbox column?

Regards,
MP.

[argopmParticipant]

Hi Dimitar,

Thanks for the reply and workaround for #1 and #2. I did exactly what you mentioned by overriding jqx-grid-cell-selected and to get the single row selected i am using cellclassname property of column object. Well strange thing is i could not find documentation about this property anywhere on website (i found it in your example). I am using function for this property and returning the class name as needed and it has also fixed the issue when row highlight style was loosing when grid is re-rendered on scroll.

For #3, as you mentioned that grid is re-rendered many times so is there any method that i can bind or is being invoked when gird rendering is finished so that i can re apply my logic of background colour?

Also am i doing it correctly by using bindingcomplete event to apply the changes on grid (i am assuming that this is only fired when data from server is loaded into the grid)? Because sometime i noticed error like ‘call this method when binding completed….’ something like that.

Regards,
MP.

[Author]

Posts