Hello community,I am facing the most interesting issue while trying to export values to the Excel. And I am confused to solve it as well. It exports empty table in Excel. I do have two input variables which should be used in filter.I debugged in a few ways:
1. Checked if values which I want to pass is correct. Which is correct, and passing by without any issues
2. Checked if my aggregate is returning the values. Aggregate is returning the values. I tested with SQL query, the same result inside the test values.
3. Tried to export the table without any input variables. It works and exports not empty values.
How I can solve this simply issue?
Hi Charos,
Your screenshot of variables in use shows month 2024 and year 3. It definitely should be opposite.
Hi @Charos Abdukayumova,
Can you share the screenshot of RecordlistToExcel?
Can you make sure you have selected all the checkbox against the columns which you need in your excel.
I am sharing a sample screen shot for your reference, In my case I am using simple Advance SQL:
Regards,
Manish Jawla
Hi Charos Abdukayumova,
Check out here the steps to export, you migh have missed something.
https://success.outsystems.com/documentation/how_to_guides/data/how_to_export_entity_data_to_excel/
Try also to set hardcoded the year and month for test.
Use also the system action logmessage to log on service center general tab at runtime your variables might not with the correct values for some reason before the aggregate.
Hope that it helps you
Thank you for quick response
I do have selected items
And I do follow the documentation. Issue is the aggregate is returning empty list despite sending value and testing it inside
As you can see it is empty
But the same values inside the aggregate while testing returning some items
Thank you,Such a small mistake =)