Nested JSON in wj flex grid column

Nested JSON in wj flex grid column

Posted by: mail2ravindar on 11 November 2017, 7:59 am EST

• 

  mail2ravindar

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 November 2017, 7:59 am EST

  Could you please suggest how can I display contactNm in wijmoflex grid by below nested json object.

  {
  
  “fileMetadataSearch”: [
  
  {
  
  “_id”: “59646b98eaed56a35621882b”,
  
  “frequency”: {
  
  “frequencyType”: “WEEKLY”
  
  },
  
  “notification”: {
  
  “contactNm”: “Tom”,
  
  “emailAddress”: “tom@gmail.com”
  
  }
  
  }]

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 5:38 am EST

  Hi,
  
  For the JSON data :

  {  
     "fileMetadataSearch":[  
        {  
           "_id":"59646b98eaed56a35621882b",
           "frequency":{  
              "frequencyType":"WEEKLY"
           },
           "notification":{  
              "contactNm":"Tom",
              "emailAddress":"tom@gmail.com"
           }
        }
     ]
  }
  

  You need to use the following code snippet for the same:

  <wj-flex-grid items-source="fileMetadataSearch" >
  	<wj-flex-grid-column binding="notification.contactNm" header="Name"></wj-flex-grid-column>
  </wj-flex-grid>
  

  ~Manish

• 

  mail2ravindar

  • Post Options:
  • Link
    Copy

  Posted 14 November 2017, 7:00 am EST

  Thanks Manish, i have one more value out of fileMetadataSearch, as shown below.Then how can I access that value (Successrate).

  {
  
  “fileMetadataSearch”:[
  
  {
  
  “_id”:“59646b98eaed56a35621882b”,
  
  “frequency”:{
  
  “frequencyType”:“WEEKLY”
  
  },
  
  “notification”:{
  
  “contactNm”:“Tom”,
  
  “emailAddress":"tom@gmail.com”
  
  }
  
  }
  
  ],
  
  “successRate”: 1
  
  }

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 15 November 2017, 2:00 am EST

  Hi,
  
  The JSON data should be in the following format since fileMetadataSearch is itemsSource for FlexGrid.

  	"fileMetadataSearch": [
  		{
  			"_id": "59646b98eaed56a35621882b",
  			"frequency": {
  				"frequencyType": "WEEKLY"
  			},
  			"notification": {
  				"contactNm": "Tom",
  				"emailAddress": "tom@gmail.com"
  			},
  			"successRate": 1
  		},
  		{...}
  	]
  

  The data should be in nested object format as shown above.

  ~Manish

• 

  mail2ravindar

  • Post Options:
  • Link
    Copy

  Posted 15 November 2017, 2:25 am EST

  Thanks Manish