203 questions
-1 votes
0 answers
27 views
Print excel/pdf in jqgrid-php from an abstact grid
My project had too many grid pages and it was quite the mess so I decided to make one sole generic grid file with configurations and each time the same page loads different configs depending on the ...
0 votes
0 answers
41 views
Grid 4 PHP shows error only on SQL failure
Grid 4 PHP allows to set the debug mode on or off: Debug mode is enabled by default and it will show the server side failure reason. When debug mode is on and a query fails I get a blank page with ...
1 vote
1 answer
54 views
Grid 4 PHP does not show pager on top
This is my PHP code: include(PHPGRID_LIBPATH . "inc/jqgrid_dist.php"); $db_conf = array( "type" => PHPGRID_DBTYPE, "server" => PHPGRID_DBHOST, &...
0 votes
1 answer
82 views
Custom text on jqgrid column that takes data from a table
I've been making a code on PHP using jqgrid for displaying some data from a database table on mariadb. I am not really that accustomed with jqgrid and the thing I am trying to achieve just bothers me ...
0 votes
1 answer
373 views
Column text color when row takes focus (is clicked)
I use jquery and jgrid for create a grid in php. I have modified the color of a column of my grid, using: $grid[“loadComplete”] = "function(ids) { onloadFunction(ids)"; The onloadFunction function is ...
1 vote
0 answers
28 views
The search field in jqGrid doesn’t return the date: 20-03-2020
The search field in jqGrid doesn’t return the date 20-03-2020. For other dates it's OK, but this date is not being returned. Why? { colModel:[{ name:'data_reg', index:'data_reg', ...
0 votes
0 answers
33 views
How to dynmically make a cell editable in jqGrid PHP
I have a jqGrid PHP project where I have been able with the below code to make rows background color and editable = false, based on the value of a cell in that row. $rowattr = <<<ROWATTR ...
0 votes
0 answers
1k views
How to add Multiselect dropdown filter in jqGrid
I am trying to add the multi-select filter to my "PROVIDER" column in the jqGrid. I am able to add the normal select filter with the single selection but now I am converting it to the multi-select ...
0 votes
0 answers
180 views
jqGrid - Keep checkbox selected on grid reload when editing form
I have a form that utilizes jqGrid to display personalized info for the user to select from. Everything works fine however on the "Review" page there is an option to edit the form. When you click edit ...
1 vote
1 answer
444 views
How to sum the values of a JQgrid footer row when the value is already in linked
I have this code that needs to be display the total sum of few columns, The JQgrid works fine in normal column value. But when that column value is linked, It shows Nan grid.jqGrid({ data: mydata,...
0 votes
1 answer
128 views
Double WHERE query on server side to create jqgrid json
I use server side to create json on jqgrid. My problem is when I want to include WHERE into mySQL query, because WHERE has been used in searching operator. The server side code is <?php include(...
0 votes
1 answer
80 views
jqGrid. Grand Total with million rows from a REST
How to show Grand Total with million rows from a REST? Documentation has the example when all data is loading once with option loadonce: true but that is a very small number of rows. How can I attain ...
0 votes
2 answers
147 views
JQGrid date format Issue: Want to convert 30-JUN-2020 to 06/30/2020
I wanted to format the below source date to target format in JQGrid, I tried several formats but not able to do so. Please help. I am getting "01/30/2020" Source Format : 30-JUN-2020 Target Format : ...
0 votes
1 answer
466 views
Error in exporting pdf in JQgrid
I want to export the details in form of pdf file.Pdf are downloaded but only headers means product,quantity,price ,total only missing the body of the content means product details. $("#...
0 votes
0 answers
104 views
How to enable partial grouping in jqGrid
I need to group my jqgrid partially. I have a case if the grouping column has more than one record, I have to group otherwise I need to show it directly. Example : In the below example groupingId is ...