I am trying to get a temporary table data by executing a stored procedure. This stored procedure is responsible to create a temporary table, insert some hard cored values (id and name as fields) and then dropping the temporary table. Before dropping Inam using select all statement so to get my data before dropping the table. But somehow I got the data which is similar to this,
{
{ id = 1, name = Abc },
{ id = 1, name = Pqr },
{ id = 1, name = Uvw },
{ id = 1, name = Xyz },
{ id = 1, name = Ijk }
}
It looks like 2D list of map. can anyone help me in binding the data to excel using Export DataStoreEntity to Excel and Execute Stored Procedure smart services.
Discussion posts and replies are publicly visible
You'll need to use the Export DSE to Excel node prior to dropping the temporary table. Assuming the temporary table looks like what you're wanting, that should be sufficient.
How to create a DSE for a Temporary table which we created using stored procedure execution?
Instead of dropping and recreating the table why not just create it once and map the CDT and just truncate and re-insert the data?
I think Neelesh asking the same question how to map a temporary table with DSE. If you are saying to create a normal table then how he will manage session specific transactions.
Not possible to map a DSE to a temp table AFAIK.
I would simply add a column for the username in the table and use that as a filter for the export. Delete the data linked to the user after the export.
Of course this approach would depend on the amount of users in the system as well as the quantity of data we are talking about but it is pretty much the only approach I can think of that could work.