Using a TEMPORARY table as an ARRAY

Using a TEMPORARY table as an ARRAY

Hi Guy's,

Since in memory Record Lists (also known as Arrays) are missing out on query functionality (order by / grouping / filtering / search etc.),
hereby a tip for those who would'd like to Import and MAP a CSV / Excel file  without storing it directly into the designated table e.g. to give the user a
choice to process only a part of the import file.

Using an advanced query it's possible to create a temporary table that you can do your queries on as if the values are already in the table.
You can either declare a separate structure or use the existing ORDER entity as a result. (I advise using the existing order entity)


Note that the TEMP table will vanish as soon as you disconnect your session.