M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Occasional Contributor
Posts: 16
Registered: ‎02-14-2019
Accepted Solution

Data grid query and export a list

[ Edited ]

Hi community,

 

 

Can a list be exported to a excel ?

 

 

I currently have a data grid from the search that gives the result for a query . 

 

Is it possible to have this data grid show up on load of the app?

 

Also can this data grid window be refreshed as an action to show updated result for the query (search criteria)?

Highlighted
Contributor
Posts: 75
Registered: ‎02-19-2019

Re: Export to Excel

[ Edited ]

There is no reporting capabilities in Workflows within MAE Desktop app But I have done list data to export excel different way. 

 

This is procedure the way I have done this task.

 

  1. I’m catching the filter parameters value through JavaScript and sending all parameters to my ASP.NET application as a query string.

 

ExportToExcel = function (){
var ASSET_ID=document.getElementById("ASSET_ID").value.split(' ').join('_');
var NAME=document.getElementById("NAME").value.split(' ').join('_');
var ASSET_TYPE_NAME = document.getElementById("ASSET_TYPE_NAME").value.split(' ').join('_');
var TOWNLAND = document.getElementById("TOWNLAND").value.split(' ').join('_');
var ASSET_FOLIO_NUMBER=document.getElementById("ASSET_FOLIO_NUMBER").value.split(' ').join('_');
var FLAGGED_NOTE=document.getElementById("FLAGGED_NOTE").value.split(' ').join('_');

SC.Media.downloadAndOpen("http://localhost:82/default.aspx?ASSET_ID="+ASSET_ID +"&NAME="+NAME+"&ASSET_TYPE_NAME="+ASSET_TYPE_NAME+"&TOWNLAND="+TOWNLAND+"&ASSET_FOLIO_NUMBER="+ASSET_FOLIO_NUMBER+"&FLAGGED_NOTE="+FLAGGED_NOTE);

}

 

 

  1. From ASP.NET application I’m catching all parameters and generating query to pull out data from database.
  2. After getting all data from database, I’m converting data to Excel file in my ASP.NET application.
  3. From M.APP application catching the excel file and showing to the end user .
  4. Mainly I use 2 application to generate the excel file but End user will not see the backend application.

ExportToExcel.png

Happy programming !

Highlighted
Contributor
Posts: 75
Registered: ‎02-19-2019

Re: Export to Excel

[ Edited ]

Sorry, I could not publish here asp.net c# code here because of different application/technology but If you need any help or have any query, please feel free to get in touch with me. I will send my code privatlely. Thanks !

Happy coding !