Export all records in same order as in UI

Hi team,


I face an issue. When I try to export data, i get different order than what's on UI. Completed_Export query is same as in preparation.

I tried binding ListAppendAll in above ss directly to the query in preparation but is only return 11 records even if max record property is blank.


Any suggestions?


Thanks

Hi Angel,

Use sort  in aggreagate and bind with direct RecordlistTOExcel and download.

It will give you same result.


Regards

Rahul Sahu

Rahul Sahu wrote:

Hi Angel,

Use sort  in aggreagate and bind with direct RecordlistTOExcel and download.

It will give you same result.


Regards

Rahul Sahu

 Hi Rahul,


I need the names of header in excel to be different. How can I achieve that?



 

Angel Saxena wrote:

Rahul Sahu wrote:

Hi Angel,

Use sort  in aggreagate and bind with direct RecordlistTOExcel and download.

It will give you same result.


Regards

Rahul Sahu

 Hi Rahul,


I need the names of header in excel to be different. How can I achieve that?



 

 

Then youo need to create a structue with colimn name you want and bind data with it.

You Need to to check sort condition or Use adavnce sql with your structure and use this list for download.


see demo

https://rahul-sahu.outsystemscloud.com/DownLoadDemo/PersonData.aspx?_ts=637309546956931341


hope this will help you.

Regards

Rahul Sahu

Rahul Sahu wrote:

Angel Saxena wrote:

Rahul Sahu wrote:

Hi Angel,

Use sort  in aggreagate and bind with direct RecordlistTOExcel and download.

It will give you same result.


Regards

Rahul Sahu

 Hi Rahul,


I need the names of header in excel to be different. How can I achieve that?



 

 

Then youo need to create a structue with colimn name you want and bind data with it.

You Need to to check sort condition or Use adavnce sql with your structure and use this list for download.


Regards

Rahul Sahu

 

 This is what I am doing now. But it comes to be different for some rows which has same data.


Hi Selva,

I have attached a demo and oml file in above post.plese look into it.


Regards

Rahul Sahu

Rahul Sahu wrote:

Hi Selva,

I have attached a demo and oml file in above post.plese look into it.


Regards

Rahul Sahu

 

 Hi Rahul, thanks for the OML.

Tried recreating the scenario. I made Line count to table records to 5. Now this will only give me 5 records although there are 11 records. It should have exported all.


Thanks

Hi Selva,

In this situtaion you are trying to download data of Current table widget data instead of aggregate data.

See below image

In excel file 7 records inculding Header and total record are 6 


Regards

Rahul sahu

Rahul Sahu wrote:

Hi Selva,

In this situtaion you are trying to download data of Current table widget data instead of aggregate data.

See below image

In excel file 7 records inculding Header and total record are 6 


Regards

Rahul sahu

 

 Hey Rahul,


How can I import all 10 records even if I have Line count set to 5 in table records widget. ?

Hi Selva,

Can you share your oml.?
If you can see my oml i will show data from aggregate and same aggreagte i use for download.


Regards

Rahul

Angel Saxena wrote:

Rahul Sahu wrote:

Hi Selva,

I have attached a demo and oml file in above post.plese look into it.


Regards

Rahul Sahu

 

 Hi Rahul, thanks for the OML.

Tried recreating the scenario. I made Line count to table records to 5. Now this will only give me 5 records although there are 11 records. It should have exported all.


Thanks

 This is the OML you shared. It has 11 records now.I made line count of table to 5. Can you make updates to show how I can download all 11?

 

Angel Saxena wrote:

Angel Saxena wrote:

Rahul Sahu wrote:

Hi Selva,

I have attached a demo and oml file in above post.plese look into it.


Regards

Rahul Sahu

 

 Hi Rahul, thanks for the OML.

Tried recreating the scenario. I made Line count to table records to 5. Now this will only give me 5 records although there are 11 records. It should have exported all.


Thanks

 This is the OML you shared. It has 11 records now.I made line count of table to 5. Can you make updates to show how I can download all 11?

 

 

 Hi Find update oml.


Cheers