Hello,
I'm downloading an excel file, but it's not downloading int the proper column order. The proper order comes when Getting the Data from the external DataBase.
However when downloading the file is not downloading in that order, it is doing a field name Alphabetical order it seems.
I'm using RecordListToExcel.
I'd appreciate any input into how to go about ordering the field names of the file so it downloads properly. Thanks.
Ed
Hi,
So you can create one structure as per your MySQL external DB and map values from your DB and pass it into excel to record list.
First Image is the image that you are passing in the record to excel correct so instead of aggregate you can create one structure and pass that structure in the local value and map the value with your aggregate and pass that local var of record list type in your record to excel list.
Thanks
Ruchi
Whatever the sequence of your entity in DB on that sequence excel will download.
Below I am attaching OML please look into it. Hope that will help you.
And if you want to arrange order according to your sequence you can create one structure of that order and pass it to excel this is also a second way you can do it.
Need for more help you can share your OML if possible.
Hello @Ruchi Dubey, I'm actually getting the data from a MySQL external database. The first image shows how the Database is actually structured, however the Entity shows a different order, but I cant get to sort it out. Thanks.
Hi @Ruchi Dubey,
Thank you for the directions, it worked like a charmed.
It works perfectly now! The only thing I was missing was adding the file type (.xlsx) š