Hi Team,
Currently, I get 'data' to be shown on flexmonster grid as a json response, as below:
I have the 'slice' as below:
{
"rows": [
{ "uniqueName": "ColumnA", "caption":"Column A" },
{ "uniqueName": "ColumnB","caption":"Column B" }
],
"expands": { "expandAll": true }
}
Now in the grid, I am able to view data for the 2 columns. 'Column A' and 'Column B' (with spaces)are shown up on the grid by default and 'ColumnC' and 'ColumnD' are unchecked column fields in the grid, and the user has to manually include these two columns to view all 4 columns.
Issue 1- How can I have caption for all the JSON keys in the data.
Any solution other than, having to include all the columns in the slice 'rows:[]' object for all the individual reports. As I do have a number of reports with varying numbers of columns returned in the json data.
Is there any way I can have a common .json file, with a list of all the columns(as keys) and corresponding caption(as value) and show values form this json file as the column names for the grid data.
Issue 2- Including the columns in the rows:[] object.
All the columns in the rows[] are displayed in the grid by default. How do I selectively show up the columns in the grid?
In the above example, I get to see Column A and Column B in the grid by default. I want only column A to be displayed and then check/uncheck the other columns from the fields toolbar menu.
Thanks in advance!!!
Hello, Kumar,
Thank you for reaching out to us.
mapping
key which is a property of dataSource
object. The mapping
value has to have the following structure:{
"ColumnA": { caption: "Column A" },
"ColumnB": { caption: "Column B" }
}
Please note, that in case of using mapping
datatype has to be set within the object presented above.
Please, find out an example by following the link below: https://jsfiddle.net/flexmonster/n54z1cf0/.
rows
array is used to set fields you want to be opened by default. If you want to leave the specific field hidden don’t include it into the rows
array.
We sure hope it helps.
Please, let us know if the solution works for you.
Feel free to contact us in case of additional questions.
Kind regards,
Illia