[Akshatha RajuParticipant]

Hi Peter,
Thanks for the reply. However I guess I had to be more specific on what I meant. What I require is, say if a grid has fixed 21 rows, where first 10 rows is displaying one result set, say related to Organization (Here below this 10 rows I require Aggregate of SUM for this first result set), then one blank row is present. Again second result set (10 rows) is displaying say related to Employees.(Here below this 10 rows I require another Aggregate of SUM for this second result set). Can this feature be possible, where one grid is displaying two rows of Aggregates for SUM?

[Akshatha RajuParticipant]

Hi Peter,
I didn’t find clipboard property in API references.

[Akshatha RajuParticipant]

HI
Please any one could reply for above post.

[Akshatha RajuParticipant]

Hi Peter,
This issue happens only when we have a vast data set bound to the grid and when vertical scroll appears for the grid, and then when we try to edit any cell value the screen moves up & down twice and then the entered value appears in the screen. This behaviour as I told is not code specific. Same code i use in mozilla and when I try to simulate it, it works fine. Only in IE I am seeing this problem.

[Akshatha RajuParticipant]

Hi Peter,

Actually the problem is, when I try to enter any alphabet in the filter row containing string values, that alphabet or string does not appear in the filter row. Hence filtering of rows based on the value entered in the filter row doesn’t happen. Instead, if I try and enter some numeric value in the filter row for the column containing string values, the filter functionality gets triggered. Hence it appears that the filter row functionality works fine for numeric values and not alphabets.
I am setting the following property
$(“#activityCodeRatioDistribution”).jqxGrid(
{
width : 800,
height : 227,
source : dataAdapter,
showfilterrow: true,
filterable: true,
theme : theme,
editable : true,
showstatusbar : true,
statusbarheight : 00,
showaggregates : true,

selectionmode : ‘multiplecellsadvanced’,
columns :activityRatioGridColumns

});
Also I am using the following plug-in: ‘jqwidget/jqwidgets/jqxgrid.filter.js’

Can you please let me know if I am committing any mistake?

[Akshatha RajuParticipant]

Hi Dimitar,
Many thanks for the reply. It worked

[Akshatha RajuParticipant]

Hi,

I have to develop four nested grids using spring MVC, for which I am referring to your sample code “server_side_grid__with_nested_grids” in phpdemos and am able to get two nested grids and now trying to for the next level nested grid by modifying the same code…

please suggest me the method to link to the third nested grid using your sample code!!

Thanks & Regards,

Sandhya S P

[Akshatha RajuParticipant]

Hi,

I am using Nested jqxgrids, and I am referring to your sample code “server_side_grid__with_nested_grids” in phpdemos folder, and trying to implement it  in my spring MVC java code.

I am able to link into the controller from both the URLs, and on debug I could see the data is being retrieved from the controller, but I am not able to display the data in neither of the grids other than the column names in both the grids,

And I guess my problem must be in the following lines from “index file” of your sample code, if that is the function used for displaying the data in the grid,

beforeprocessing: function (data) {
source.totalrecords = data[0].TotalRows;
},

data[] and TotalRows are defined in “data file” of your code,

but my query is how are they linked/defined in the “index file”??

please explain, as this may be the reason I am unable to display data in both the grids

Thanks & Regards,

Akshatha Raju

[Akshatha RajuParticipant]

Hi,

did u mean using setTimeout function, both grids will be exported to same excel on single button click?

I get only the first grid in Excel even after using setTimeout function !!,

[Akshatha RajuParticipant]

Thank you for the reply!!

How will I export multiple jqxgrids from a single jsp page to excel on a single button click,

If I call all the grids in the same click function,

by appending all the grid ID’s in the same function like following, it neither works or gives an error,,

$(“#excelExport”).click(function () {
$(“#jqxgrid1”, “#jqxgrid2”).jqxGrid(‘exportdata’, ‘xls’, ‘jqxGrid’);
});

Or,
If I call them separately as follows, I will get only the first grid in excel:

$(“#excelExport”).click(function () {
$(“#jqxgrid1”).jqxGrid(‘exportdata’, ‘xls’, ‘jqxGrid’);

$(“#jqxgrid2”).jqxGrid(‘exportdata’, ‘xls’, ‘jqxGrid’);
});

[Akshatha RajuParticipant]

Hi,

Ok, I got your point. Thanks for the information. In that case, I can’t make a column in jqxGrid editable or non-editable dynamically?

[Akshatha RajuParticipant]

Hi,

I have included ‘jqxgrid.edit.js’ and even though I enable the setting “editable” to true , it is not working for me. Is there anything wrong with this code, where in I am trying to make column ‘hoursSummary’ present in jqxGrid as editable, where in by default I have set the column’s setting as ‘editable:false’

$(“#jqxgridSkillGrpSummary”).jqxGrid(‘begincelledit’, 0, ‘hoursSummary’);

[Akshatha RajuParticipant]

Hello Klaus H ,

You got my problem, however I am not able to find the solution to get the rows of DTO. I have tried ‘N’ number of ways to convert this JSON data into rows of DTO. I have used all methods like JSONObject, JSONArray, JSONTokener etc to get the required solution. But I am getting one or the other exception when i try to convert it into list of DTO. Can you please provide me a snippet where in you have converted JSON data to rows of DTO, and also can you provide me the exact ‘JAR’ file which I need to download and add in my ‘LIB’ folder in order to achieve this. Right now I have downloaded & used the following JAR file ‘java-json.jar’. Thanks in advance!

[Akshatha RajuParticipant]

Hi rcm01, Thank you so very much for the solution. I am now able to get the json data in controller. But now my worry is i need to insert every row present in this JSON data into database. So, are you aware of any JSON parser or so to convert this json data into maybe a LIST, a list of DTO which will hold the data as individual rows, so that i can easily insert into the database, by iterating through the rows of List. Any help would be appreciated. Thanks in advance!

[Akshatha RajuParticipant]

Hi Peter,
Thanks for the reply! The explanation which you have given above is for manipulating a single row at a time (update or delete), but what I actually want is to fetch the data which is displaying in the jqxgrid, may be in some JSON format and to insert it into the database. What I mean is on click of some button, the data displaying in jqxgrid is to be inserted into the database. Is there any solution for this sort of requirement?

[Author]

Posts