topic weekly report with SQLquery tables in Discussions

weekly report with SQLquery tables

joann — Sat, 10 Jun 2023 23:26:48 GMT

I have 3 SQLQuery tables generated. Few questions:

To generate a weekly report, what’s the best way to store them, so next week once I have updated data, I can replace the data source once, and then the 3 query tables run automatically? Is it like journal, project, or dashboard?
How to combine the scripts of the 3 query tables in order to run them all at once with updated data? I saw in each table they have “source”, “modify query”, and “update from database”. Do I combine the script of any of them and save it somewhere?

Thank you for your help!

Re: weekly report with SQLquery tables

Georg — Fri, 05 Mar 2021 18:45:18 GMT

Dear @joann , perhaps here you can find some ideas on what is possible here:

The solution depends on what you would like to do with the three tables, and if they have a connection.

You can realize almost everything.

The first thing you could try, to just execute them every time by one click, is to

copy the three (table) "Source" scripts one after another into one script file,
to save that file
and execute it every time you need.

It will give you three new tables, probably run in background, and all three in parallel (depends on some settings).

So if the queries are large (and time consuming), this would be the fastest/best way I think.

Re: weekly report with SQLquery tables

joann — Thu, 04 Mar 2021 21:27:01 GMT

Thank you Georg! I'll watch the video.
I pasted "source" scripts directly from both tables and clicked run, but i received an error message start with "Unrecognized message in access or evaluation of 'Run New SQL Query' ," Is there any script i should put in between 2 scripts as bridge? Thank you!