logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Alain  
#1 Posted : Friday, August 28, 2020 3:01:54 PM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 15
France

Hello

How to launch a request before the execution of another?
I want to launch a query, so that my second query will find the results of the first in one?
How to do?
Another possibility: can we execute a request first, which would fill a table for me?

Thanks for your help
epf  
#2 Posted : Sunday, August 30, 2020 7:45:06 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
There are several ways to do that but you have to understand the execution steps/the object models as it requires C# code...

Execution steps are described at https://sealreport.org/Reports#lineExecution

So using the report models 'Pre Load Script', 'Post Load Script' or 'Final Script' you can use the result of one model to fill up another model.
Just make sure to set the 'Execution Set' property to sequence the model generations.

Report tasks can also be used to copy data between models if the are executed at the step 'Models generated, before rendering'.

Good luck.
Users browsing this topic
Similar Topics
Set maximum query time (Reports)
by scott9677 1/5/2024 6:46:19 PM(UTC)
create dynamic reports using a sql query as an input parameter? (General Discussions/Other)
by Androoda50 12/21/2022 12:52:00 PM(UTC)
Query on SEAL Capabilities (General Discussions/Other)
by Benbabu 12/19/2019 4:36:38 AM(UTC)
Query Table in Init script directly (Reports)
by artificer 8/26/2019 4:30:35 PM(UTC)
How to specify the parent table to query when configuring joins (Reports)
by scott9677 5/10/2019 2:57:16 PM(UTC)
Report parametrization and using a query as part of a parameter (Reports)
by EntropiaFox 2/20/2019 8:38:16 PM(UTC)
Using restriction values in a subquery (Reports)
by lvg 8/10/2016 1:57:16 PM(UTC)
Performance query (General Discussions/Other)
by Sathish 10/27/2015 12:41:48 PM(UTC)
Jquery is undefined error (Installation)
by Asad 10/13/2015 6:19:39 PM(UTC)
Restriction Based on Dimension Table Query (Reports)
by sealfan 9/11/2015 4:33:49 PM(UTC)
Capabilities question - can I paste in a SQL query and get a CSV report out? (General Discussions/Other)
by EDB 4/21/2015 4:09:56 PM(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.