I am trying to write some code to get data from the EUL tables populated by the Discoverer scheduling process and to populate a two custom tables (report runs and report run lines) so the data can be viewed from a generic BI Publisher Report in spreadsheet form.
The SQL that it generates, held in eul5_batch_queries, does not get the columns back in the same order as when viewing the results from Discoverer and the users want the way in which the data is presented to be the same. I have looked at the contents of a lot of the EUL tables and cannot see any values that determine the sequence of the columns that I could use to re-order them.
exp_formula1 on eul5_expressions is closer to the original sequence than the sequence of columns in the SQL from eul5_batch_queries but it is not identical. I have looked at the contents of many of the EUL prefixed tables but cannot see anything that looks like this. Does anyone if it is possible to replicate the original column sequence and, if so, how?
Any relevant information would be gratefully received.