This is a migrated thread and some comments may be shown as answers.

Issues with characters in field names

1 Answer 71 Views
Data Source
This is a migrated thread and some comments may be shown as answers.
Steven
Top achievements
Rank 1
Steven asked on 09 Apr 2012, 07:50 PM

I am trying to consume a json data source that returns @ and # characters in the fieldnames.   Apparently these characters are causing the kendoGrid template creation to fail.   Any workarounds (no, I can't change the data source)?

See below:

"Results": {
     "@ViewName": "WFP_MacroDemandForecast",
     "RowSet": {
         "@ColDims": "Workforce Planning Value",
         "Rows": [
             {
                 "WorkforcePlanningMeasure": {
                     "@Name": "HC Demand",
                     "@DimName": "Workforce Planning Measure",
                     "@ID": "Headcount Demand",
                     "#text": "HC Demand"
                 },
                 "Value": "0",
                 "ChangeRate": "0",
                 "BaseYear": "0",
                 "ForecastDriver": "0",
                 "_5YearGoal": "0",
                 "Year1": "0",
                 "Year2": "0",
                 "Year3": "0",
                 "Year4": "0",
                 "Year5": "0"
             },

1 Answer, 1 is accepted

Sort by
0
Steven
Top achievements
Rank 1
answered on 09 Apr 2012, 09:39 PM
Never mind...it turned out to be a browser cache issue....though I changed it, it never took effect until I reset the cache.   Lesson learned...

For those of you who are interested:

To access an element that uses @ or #, just use the standard array notation.
columns: [
    { field: "WorkforcePlanningMeasure[\"@DimName\"]", title: "Metric" },
    { field: "ChangeRate", title: "Change Rate" },
    { field: "BaseYear", title: "Base Year" },
    { field: "_5YearGoal", title: "Goal" },
    { field: "Year1", title: "Year 1" },
    { field: "Year2", title: "Year 2" },
    { field: "Year3", title: "Year 3" },
    { field: "Year4", title: "Year 4" },
    { field: "Year4", title: "Year 5" }
]


Tags
Data Source
Asked by
Steven
Top achievements
Rank 1
Answers by
Steven
Top achievements
Rank 1
Share this question
or