Using data-order and JSON data source

dknowles

Hi All

Has anyone combined using the data-order feature with a JSON data source, as I want to remove the building numbers and just sort on the building names, but still display the building number in the visible table.

e.g. give me in effect <td data-order="Norse Ave, 100"> 100 Norse Ave</td> but getting the data from a JSON source as the data is on a different server.

JSON

{
"data": [
{
"DT_Row_Id": "11017",
"locationName": "100 Norse Ave ",
"locationLinks": "<a href='EditLocation.asp?LocationID=11017'><i class='loc-Edit'></i></a>  <a id='l11017' class='TrashCanLocation' LocationID='11017' LocationName='"100 Norse '><i class='loc-Remove'></i></a>",
"addr1": "",
"addr2": "Norse Road",

  }

  ,{
  "DT_Row_Id": "10639",
  "locationName": "102 Norse Road",
  "locationLinks": "<a href='EditLocation.asp?LocationID=10639'><i class='loc-Edit'></i></a>&nbsp;&nbsp;<a id='l10639' class='TrashCanLocation' LocationID='10639' LocationName='"102 Norse '><i class='loc-Remove'></i></a>",

  "addr1": "",
  "addr2": "Norse Road",

  }

]
}

Cheers David