In my project I have different values that are displayed on their own tables. For the calculation of these values, I use, as example, the following SQL query:
Example 1
SELECT
SUM(asservate.Speichervolumen) AS SUM(Speichervolumen),
vorgangsverwaltung.Eingangsdatum
FROM asservate
INNER JOIN vorgangsverwaltung ON asservate.Vorgangsnummer = vorgangsverwaltung.Vorgangsnummer
Example 2
SELECT
Eingangsdatum,
AVG(to_days(Bearbeitungende) -to_days(Bearbeitungsbeginn)) AS Bearbeitungszeit
FROM vorgangsverwaltung
WHERE (Bearbeitungende IS NOT NULL) AND (Bearbeitungsbeginn IS NOT NULL)
There are several tables with similar values, which are all displayed on a separate query into a separate table. To have a look on these values, it is necessary to make a click on the table in the menu of the application.
Now, I´m looking for a way, to show these values permanently somewhere on the page, without the need for a click at the corresponding table.
