[NeelamMember]

Hi,

I tried my best to solve the error but did work at all.

I am getting most of the issues in jqxdata.js file at line no. 1812. also if i include jquery-1.8.1.js, get error 1.jqx is undefined thats why using jquery-1.7.2 .js

 

Regards,
Neelam

[NeelamMember]

Hello,

Please suggest me something what can I do for large data size to make export functionality working otherwise export is no more useful for us.

Regards,
Neelam

[NeelamMember]

Hi,

Thanks but as I said in my previous post that export throws me to the save-file.php file for data more than 8 MB. So if I host this file on our server, it has no connection with export plugin.

Regards,
Neelam

[NeelamMember]

Hi,

How this file work with jqxgrid.export.js and jqxgrid.filter.js? There is no connection of save-file.php with filter js file.

It should export data with filter condition irrespective of data size?

Regards,
Neelam

[NeelamMember]

Hi Peter,

I found the issue. The data which is being shown in jqgrid is very huge and varies in size. So I am able to export data for max 8.6MB. If data exceeds more than this it redirects me to the below url.

http://www.jqwidgets.com/export_server/save-file.php

Regards,
Neelam

[NeelamMember]

Hi,

I created a sample script but its working fine. but the same script in my application giving me popup to stop script.

Could you please tell me what could be the problem?

[NeelamMember]

Hello,

Nice to see new version 2.4. I am using export to excel in jqgrid where it works fine. but in html page, I have used 2 grids which are toggled by clicking on button. so when first time page renders and I click on export button, then export funcationality works good. after I click on a button say ‘detail’ whic h gives me second grid. it also has export functionality but it doesn’t work for second grid.

Regards,
Neelam

[NeelamMember]

Hello,

Above solution return values and condition but didn’t returns datafield name. Also if I apply filter on second column, it returns me filter value but if dont click on clear button of filter and apply second filter on first column, it returns me filter value of second column instead of first column.

I tries using clearfilters, removefilter, and refresh methods.

$(“#jqxgrid”).bind(“filter”, function (event) {

//$(‘#jqxgrid’).jqxGrid(‘removefilter’, ‘datafield’);
//$(‘#jqxgrid’).jqxGrid(‘clearfilters’);

var filter = $(“#jqxgrid”).jqxGrid(‘getfilterinformation’);

for (i = 0; i < filter.length; i++) {

var filter0 = filter[0];
var value = filter0.filter.getfilters()[0].value;
var condition = filter0.filter.getfilters()[0].condition;

}
});

Thanks,
Neelam

[NeelamMember]

Hi Peter,

Thanks for reply but I got below code to get column name on which filter was applied. But how to find the filter value applied on particular column?

var filterinfo = $(“#jqxgrid”).jqxGrid(‘getfilterinformation’);

for (i = 0; i < filterinfo.length; i++) {

var eventData = "Filter Column: " + filterinfo[i].filtercolumntext;

}

Please suggest something.

Thanks & Regards,
Neelam

[NeelamMember]

OK. No Problem.

And what about space separator?

Regards,
Neelam

[NeelamMember]

Thanks for quick reply.

I have 2 queries.

1. what about sum of cell values? can we do sum of cell values and is it also applicable to filtered values?

2. I want to show amount as space separator instead of comma(,) separator. like 30 00 000

Regards,
Neelam

[NeelamMember]

Hi,

I want summation of all cell values in amount column. also sum should be changed as per filter values. Is there any way to pin a row rather than column?

Thanks,
Neelam

[NeelamMember]

This function is called when I change value of combo box.

when change event is called, I have replace jqgrid with loader image. later on it should replace with data. which is not happening.

function accountSummary()
{
var theme = ‘energyblue’;

$(‘#jqxgrid’).html(‘‘);

var url = SITEDOMAIN+”/accounts/accountsummary”;
// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘numeroCompte’ },
{ name: ‘variation’, type: ‘float’ },
{ name: ‘variation_perc’ }
],
id: ‘id’,
url: url,
root: ‘data’

};

var dataAdapter = new $.jqx.dataAdapter(source);
$(“#jqxgrid”).jqxGrid(
{
width: 930,
source: dataAdapter,
theme: theme,
columnsresize: true,
columns: [
{ text: ‘NumeroCompte’, dataField: ‘numeroCompte’, width: 150},
{ text: ‘Variation’, dataField: ‘variation’, width: 120, cellsformat: ‘c2’ },
{ text: ‘Variation %’, dataField: ‘variation_perc’, width: 120, cellsformat: ‘c2’ }
]
});
}

Thanks,
Neelam

[NeelamMember]

Ok not an issue.

I have another problem. I want to another currency symbol rather than $. If I make a column as a float , it shows $ by default for that. How can I show another currency sign fetch from database?

Regards,
Neelam

[NeelamMember]

Hello,

I tried a dummy setup for grid which is working. with below code. same code I am using to replace a div with grid using ajax call but its not working.

headLink()->appendStylesheet($this->baseUrl().’/scripts/jqwidgets/styles/jqx.base.css’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jquery-1.7.2.min.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxcore.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxbuttons.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxscrollbar.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxmenu.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxcheckbox.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxlistbox.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxdropdownlist.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxgrid.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxgrid.selection.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxgrid.columnsresize.js’) ?>
headScript()->appendFile($this->baseUrl().’/scripts/jqwidgets/jqxdata.js’) ?>

$(document).ready(function () {

var url = SITEDOMAIN+”/dashboards/data”;
var parentsLength = $(“#jqxWidget”).parents().length;
if (parentsLength > 3) {
url = SITEDOMAIN+”/dashboards/data”;
}
// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘mth’ },
{ name: ‘total’, type: ‘int’ }
],
id: ‘id’,
url: url,
root: ‘data’
};
var dataAdapter = new $.jqx.dataAdapter(source);
$(“#jqxgrid”).jqxGrid(
{
width: 670,
source: dataAdapter,
columnsresize: true,
columns: [
{ text: ‘First Name’, dataField: ‘mth’, width: 100 },
{ text: ‘Total’, dataField: ‘total’, cellsalign: ‘right’, minwidth: 100, cellsformat: ‘c2’ }
]
});
});

Thanks,
Neelam

[Author]

Posts