[jqdevMember]

Ok thanks, I’ll use 2.4 version.

Regards,
jqdev

[jqdevMember]

below are included files.

[jqdevMember]

Hi,

Thanks. above code is working for 2.4.2 version.

Is it possible for 2.2 version?

This example shows how to create a Grid from JSON string.

$(document).ready(function () {
var theme = ”;

var data = [{ “CompanyName”: “132456000”, “ContactName”: “Maria Anders”, “ContactTitle”: “Sales Representative”, “Address”: “Obere Str. 57”, “City”: “Berlin”, “Country”: “Germany” }, { “CompanyName”: “4651300”, “ContactName”: “Ana Trujillo”, “ContactTitle”: “Owner”, “Address”: “Avda. de la Constitucin 2222”, “City”: “Mxico D.F.”, “Country”: “Mexico” }, { “CompanyName”: “123789000”, “ContactName”: “Antonio Moreno”, “ContactTitle”: “Owner”, “Address”: “Mataderos 2312”, “City”: “Mxico D.F.”, “Country”: “Mexico” }, { “CompanyName”: “Around the Horn”, “ContactName”: “Thomas Hardy”, “ContactTitle”: “Sales Representative”, “Address”: “120 Hanover Sq.”, “City”: “London”, “Country”: “UK” }, { “CompanyName”: “Berglunds snabbkp”, “ContactName”: “Christina Berglund”, “ContactTitle”: “Order Administrator”, “Address”: “Berguvsvgen 8”, “City”: “Lule”, “Country”: “Sweden” }];

// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘CompanyName’, type: ‘string’ },
{ name: ‘ContactName’ },
{ name: ‘ContactTitle’ },
{ name: ‘Address’ },
{ name: ‘City’ },
{ name: ‘Country’ }
],
localdata: data
};
var dataAdapter = new $.jqx.dataAdapter(source);

$(“#jqxgrid”).jqxGrid(
{
width: 670,
source: dataAdapter,
theme: theme,
columnsresize: true,
filterable:true,
columns: [
{ text: ‘Company Name’, datafield: ‘CompanyName’, width: 250 },
{ text: ‘Contact Name’, datafield: ‘ContactName’, width: 150 },
{ text: ‘Contact Title’, datafield: ‘ContactTitle’, width: 180 },
{ text: ‘City’, datafield: ‘City’, width: 120 },
{ text: ‘Country’, datafield: ‘Country’, width: 120 }
]
});
});

[jqdevMember]

Thanks for reply but still no difference.

Regards,
jqdev

[jqdevMember]

Hello,

Please check below code in which I have changed company name as numeric for first 3 rows. because of which it shows ‘LESS THAN’ operator. If first row is alphabetic it shows ‘CONTAINS’ operator.

I am using 2.2 version and also checked for 2.4.2 version but problem is same.

Also added the type as string for company name.

This example shows how to create a Grid from JSON string.

$(document).ready(function () {
var theme = ”;

var data = [{ “CompanyName”: “132456000”, “ContactName”: “Maria Anders”, “ContactTitle”: “Sales Representative”, “Address”: “Obere Str. 57”, “City”: “Berlin”, “Country”: “Germany” }, { “CompanyName”: “4651300”, “ContactName”: “Ana Trujillo”, “ContactTitle”: “Owner”, “Address”: “Avda. de la Constitucin 2222”, “City”: “Mxico D.F.”, “Country”: “Mexico” }, { “CompanyName”: “123789000”, “ContactName”: “Antonio Moreno”, “ContactTitle”: “Owner”, “Address”: “Mataderos 2312”, “City”: “Mxico D.F.”, “Country”: “Mexico” }, { “CompanyName”: “Around the Horn”, “ContactName”: “Thomas Hardy”, “ContactTitle”: “Sales Representative”, “Address”: “120 Hanover Sq.”, “City”: “London”, “Country”: “UK” }, { “CompanyName”: “Berglunds snabbkp”, “ContactName”: “Christina Berglund”, “ContactTitle”: “Order Administrator”, “Address”: “Berguvsvgen 8”, “City”: “Lule”, “Country”: “Sweden” }, { “CompanyName”: “Blauer See Delikatessen”, “ContactName”: “Hanna Moos”, “ContactTitle”: “Sales Representative”, “Address”: “Forsterstr. 57”, “City”: “Mannheim”, “Country”: “Germany” }, { “CompanyName”: “Blondesddsl pre et fils”, “ContactName”: “Frdrique Citeaux”, “ContactTitle”: “Marketing Manager”, “Address”: “24, place Klber”, “City”: “Strasbourg”, “Country”: “France” }, { “CompanyName”: “Blido Comidas preparadas”, “ContactName”: “Martn Sommer”, “ContactTitle”: “Owner”, “Address”: “C\/ Araquil, 67”, “City”: “Madrid”, “Country”: “Spain” }, { “CompanyName”: “Bon app'”, “ContactName”: “Laurence Lebihan”, “ContactTitle”: “Owner”, “Address”: “12, rue des Bouchers”, “City”: “Marseille”, “Country”: “France” }, { “CompanyName”: “Bottom-Dollar Markets”, “ContactName”: “Elizabeth Lincoln”, “ContactTitle”: “Accounting Manager”, “Address”: “23 Tsawassen Blvd.”, “City”: “Tsawassen”, “Country”: “Canada” }, { “CompanyName”: “B’s Beverages”, “ContactName”: “Victoria Ashworth”, “ContactTitle”: “Sales Representative”, “Address”: “Fauntleroy Circus”, “City”: “London”, “Country”: “UK” }, { “CompanyName”: “Cactus Comidas para llevar”, “ContactName”: “Patricio Simpson”, “ContactTitle”: “Sales Agent”, “Address”: “Cerrito 333”, “City”: “Buenos Aires”, “Country”: “Argentina” }, { “CompanyName”: “Centro comercial Moctezuma”, “ContactName”: “Francisco Chang”, “ContactTitle”: “Marketing Manager”, “Address”: “Sierras de Granada 9993”, “City”: “Mxico D.F.”, “Country”: “Mexico” }, { “CompanyName”: “Chop-suey Chinese”, “ContactName”: “Yang Wang”, “ContactTitle”: “Owner”, “Address”: “Hauptstr. 29”, “City”: “Bern”, “Country”: “Switzerland” }, { “CompanyName”: “Comrcio Mineiro”, “ContactName”: “Pedro Afonso”, “ContactTitle”: “Sales Associate”, “Address”: “Av. dos Lusadas, 23”, “City”: “Sao Paulo”, “Country”: “Brazil” }, { “CompanyName”: “Consolidated Holdings”, “ContactName”: “Elizabeth Brown”, “ContactTitle”: “Sales Representative”, “Address”: “Berkeley Gardens 12 Brewery”, “City”: “London”, “Country”: “UK” }, { “CompanyName”: “Drachenblut Delikatessen”, “ContactName”: “Sven Ottlieb”, “ContactTitle”: “Order Administrator”, “Address”: “Walserweg 21”, “City”: “Aachen”, “Country”: “Germany” }, { “CompanyName”: “Du monde entier”, “ContactName”: “Janine Labrune”, “ContactTitle”: “Owner”, “Address”: “67, rue des Cinquante Otages”, “City”: “Nantes”, “Country”: “France” }, { “CompanyName”: “Eastern Connection”, “ContactName”: “Ann Devon”, “ContactTitle”: “Sales Agent”, “Address”: “35 King George”, “City”: “London”, “Country”: “UK” }, { “CompanyName”: “Ernst Handel”, “ContactName”: “Roland Mendel”, “ContactTitle”: “Sales Manager”, “Address”: “Kirchgasse 6”, “City”: “Graz”, “Country”: “Austria”}];

// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘CompanyName’ , type: ‘String’ },
{ name: ‘ContactName’ },
{ name: ‘ContactTitle’ },
{ name: ‘Address’ },
{ name: ‘City’ },
{ name: ‘Country’ }
],
localdata: data
};
var dataAdapter = new $.jqx.dataAdapter(source);

$(“#jqxgrid”).jqxGrid(
{
width: 670,
source: dataAdapter,
theme: theme,
columnsresize: true,
filterable:true,
columns: [
{ text: ‘Company Name’, datafield: ‘CompanyName’, width: 250 },
{ text: ‘Contact Name’, datafield: ‘ContactName’, width: 150 },
{ text: ‘Contact Title’, datafield: ‘ContactTitle’, width: 180 },
{ text: ‘City’, datafield: ‘City’, width: 120 },
{ text: ‘Country’, datafield: ‘Country’, width: 120 }
]
});
});

[jqdevMember]

Hi,

Yes I have tried by defining datatype to data field.

var source =
{
datatype: “json”,
datafields: [
{ name: ‘checkAll’ },
{ name: ‘numeroCompte’, type:’string’ },
{ name: ‘intituleCompte’ },
{ name: ‘current’, type:’int’ },
{ name: ‘previous’, type:’int’ },
{ name: ‘variation’, type:’int’ },
{ name: ‘variation_perc’ }
],
id: ‘id’,
url: url,
root: ‘data’
};

[jqdevMember]

Please let me know to make it work.

[Author]

Posts