[yalineParticipant]

Hi Martin,

Thank you so much for your wonderful help.
I found out my mistake in button coding.
Now its working super cool.

Many thanks,
Yaline

[yalineParticipant]

Hi Martin,

When i choose any one filter and press send sms or send mail button it works perfectly, but more than one filter and the button not working.

How to proceed? What i am missing?
Awaiting your reply.

Thanks
Yaline

[yalineParticipant]

Hi Martin,

Thank you for your support.
1. filtering department (choose any 5 values)
2. Filter division (any one value)
3. Then click the send mail button
Now the popup won’t open.

After your reply, i started to thinking might be I missed something in button coding Martin?

Any suggestions please.

Thanks,
Yaline

[yalineParticipant]

Hi Martin,

Please check the below link
http://www.paarventhan.co.in/sample/text_local/check7.php
try filter 2 column (eg: DEpartment, then division), the button is not working

Please help me.

Thanks
Yaline

[yalineParticipant]

Martin, is it may be i am using dynamic data?
Trying for hours in many diffenent ways, couldnt fix it.

[yalineParticipant]

Hello Martin,

Thanks for your reply.
Sorry i couldnt respond immediately as held up with some other work.

The example you showed working fine. What if you have & and ‘ in data
E.g: Product Name has “Jasmine & Lotus Tea” and “Jasmin’s Tea”. In that case, filter not working
i also try to change filtertype: ‘checkedlist’ option, but still the same Martin

Thanks
Yaline

[yalineParticipant]

Hi,
Can anyone help me please.
The script works sometimes and not.
Also i have special characters (&,’,-) in my row data.
Any suggestion. Awaiting reply to procees.

Thanks
Yaline

[yalineParticipant]

Dear sir,

When i include ” localdata: data”, my datas are getting loaded. Please confirm, if i am going in the right path. Thanks

var source =
{
localdata: data,//////////////// This line
datatype: “json”,
datafields: [
{ name: ‘productID’, type: ‘string’ },
{ name: ‘price’, type: ‘float’ }
],

//url: ‘data_pivotgrid_cell_values_alignment.php’,
//cache: false,
};

[yalineParticipant]

Dear Sir,
I want to use a data source from PHP-MySQL with the new pivot grid,but its not loading the data.
My dtas is getting displayed in the alert box. Please find below my coding. Please advice me.

$(document).ready(function() {
ObtenerDatos();
});

function ObtenerDatos() {
var url = “data.php”;
$.ajax({
type: “POST”,
url: url,
success: function(data) {
BindPivot(data);
}
});
}

function BindPivot(data)
{
alert(data); //my data is getting displayed in the alert box
var source =
{
datatype: “json”,
datafields: [
{ name: ‘productID’, type: ‘string’ },
{ name: ‘price’, type: ‘float’ }
],

};

var dataAdapter = new $.jqx.dataAdapter(source);
dataAdapter.dataBind();

// create a pivot data source from the dataAdapter
var pivotDataSource = new $.jqx.pivot(
dataAdapter,
{

pivotValuesOnRows: false,
rows: [{ dataField: ‘productID’, width: 190 }],
columns: [],
values: [
{ dataField: ‘price’, width: 200, ‘function’: ‘min’, text: ‘cells left alignment’, formatSettings: { align: ‘left’, prefix: ”, decimalPlaces: 2, } },
{ dataField: ‘price’, width: 200, ‘function’: ‘max’, text: ‘cells center alignment’, formatSettings: { align: ‘center’, prefix: ”, decimalPlaces: 2 } },
{ dataField: ‘price’, width: 200, ‘function’: ‘average’, text: ‘cells right alignment’, formatSettings: { align: ‘right’, prefix: ”, decimalPlaces: 2 } }
]
});

// create a pivot grid
$(‘#divPivotGrid’).jqxPivotGrid(
{
source: pivotDataSource,
treeStyleRows: false,
autoResize: false,
multipleSelectionEnabled: true
});

}

[Author]

Posts