Clarification in JSON Foramt

[aravindtrueMember]

Hi,

If I have a JSON format like the below,

var data = ‘[
{
“CompanyName”: “Alfreds Futterkiste”,
“ContactName”: “Maria Anders”,
“ContactTitle”: “Sales Representative”,
“Address”: “Obere Str. 57”,
“City”: “Berlin”,
“Country”: “Germany”
}
]’;

var source =
{
datatype: “json”,
datafields: [
{ name: ‘CompanyName’ },
{ name: ‘ContactName’ },
{ name: ‘ContactTitle’ },
{ name: ‘Address’ },
{ name: ‘City’ },
{ name: ‘Country’ }
],
localdata: data
};

How do I source when I have a JSON format like this,

var data = ‘[
{
“CompanyName”: “Alfreds Futterkiste”,
“ContactName”: “Maria Anders”,
“ContactTitle”: {
“old”: “Sales Representative”,
“new”: “Sales Executive”
},
“Address”: “Obere Str. 57”,
“City”: “Berlin”,
“Country”: “Germany”
}
]’;

Whether I have to something like this,

var source =
{
datatype: “json”,
datafields: [
{ name: ‘CompanyName’ },
{ name: ‘ContactName’ },
{ name: ‘ContactTitle.old’ },
{ name: ‘Address’ },
{ name: ‘City’ },
{ name: ‘Country’ }
],
localdata: data
};

I tried, it isn’t working.

Regards,
Aravind

[Peter StoevKeymaster]

Hi Aravind,

The name should be CompanyTitle. The “map” should be set to “CompanyTitle>old”.

var source =
{
datatype: “json”,
datafields: [ 
  { name: 'CompanyName' },
  { name: 'ContactName' },
  { name: 'ContactTitle', map: 'ContactTitle>old'},
  { name: 'Address' },
  { name: 'City' },
  { name: 'Country' }
]

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[aravindtrueMember]

Thanks a lot. It is working perfect.

Regards,
Aravind

[aravindtrueMember]

I have got a small problem, if I have the following source format

var source =
{
datatype: “json”,
datafields: [
{ name: ‘CompanyName’ },
{ name: ‘ContactName’ },
{ name: ‘ContactTitle’, map: ‘ContactTitle>old’},
{ name: ‘ContactTitle’, map: ‘ContactTitle>new’},
{ name: ‘Address’ },
{ name: ‘City’ },
{ name: ‘Country’ }
],
localdata: data
}

var cols = [
{text: ‘Company Name’, datafield: ‘CompanyName’},
{text: ‘Contact Name’, datafield: ‘ContactName’},
{text: ‘New Contact Name’, datafield: ‘ContactTitle’},
{text: ‘Old Contact Name’, datafield: ‘ContactTitle’},
{text: ‘Address’, datafield: ‘Address’},
{text: ‘City’, datafield: ‘City’},
{text: ‘Country’, datafield: ‘Country’},
]

The ‘ContactTitle’ is overridden with new one. Is there way to display two columns with same datafield?

[Peter StoevKeymaster]

Hi aravindtrue,

Each column is required to have an unique datafield.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[aravindtrueMember]

Yeah, fixed that in a different way.

Thanks a lot for the quick response.

[Author]

Posts