Eclipse Community Forums: BIRT » Data Sets -> Generate SQL Views

Help

Home

Home » Archived » BIRT » Data Sets -> Generate SQL Views

Show: Today's Messages :: Show Polls :: Message Navigator

Data Sets -> Generate SQL Views [message #1836333]

Tue, 29 December 2020 11:21

ewr2345235 45646

Messages: 1
Registered: December 2020

Junior Member

Hello, I want to generate a Report form a very simple DataSet Query:

select * from CombinedViewOrdered
where "SAMPLE" is not null;

But the Problem is that every time I want to run the Report the ORACLE SQL View
"CombinedViewOrdered" has to be recreated (replaced)

And this View depends on another view called "CombinedView" that needs to be also recreated before I do my 'select' Query.

My Database User is allowed to create and replace views and to do selects, but NOT to execute stored procedures.

In an ORACLE SQL Development Environment I would just execute a single *.sql File that contains the statements that create the multiple views and then do the select at the end.

Now I am looking for the same way in BIRT Reporting Tool.
Basically every time when I create my Result Set with my Data Set I want that the views are replaced beforehand ( this needs to be executed by the BIRT reporting tool with the existing permissions of the Data Source)

How can I do that ?

Thanks in advance

Report message to a moderator