A wish to put forward for future enhancements on the export tables a couple of ideas on the where clause.
1. allow the table to be referenced in the where clause with an alias such that where clause can include a join back to the table being exported
eg. I wish to select the latest data from thetable for an id. So I click thetable from the table list and in the where clause I enter a clause that references back to the base table through an alias of 'a'
select * from thetable a
where a.effectivedate = (
select max(b.effectivedate)
from thetable b
where b.id = a.id
)
2. Extend the interface/OSF files to be able to specify a where clause per table (or existing global where clause)
1. allow the table to be referenced in the where clause with an alias such that where clause can include a join back to the table being exported
eg. I wish to select the latest data from thetable for an id. So I click thetable from the table list and in the where clause I enter a clause that references back to the base table through an alias of 'a'
select * from thetable a
where a.effectivedate = (
select max(b.effectivedate)
from thetable b
where b.id = a.id
)
2. Extend the interface/OSF files to be able to specify a where clause per table (or existing global where clause)
