Difference between revisions of "User: Bgrenon"

Revision as of 15:45, March 31, 2022

No results

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `IpName` AS `IpName`,`Version` AS `Version`,`Container` AS `Container`,`LastPublish` AS `LastPublish`,`LastPublish__precision` AS `LastPublish__precision` FROM `cargo__RNElements` WHERE LastPublish between date_sub(now(),INTERVAL 1 WEEK) and now () ORDER BY `IpName`,`Version`,`Container`,`LastPublish` LIMIT 100 Function: CargoSQLQuery::run Error: 1630 FUNCTION supersite_wiki.now does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual (127.0.0.1)

Error: The SQL function "CURDATE()" is not allowed.

Error: The SQL function "YEARWEEK()" is not allowed.

@@ Line 1: / Line 1: @@
+<tabber>
+Last 24 hours=
 {{#cargo_query:
-     tables=Article,MintyDocsManual,Service
+tables=RNElements
-     |join on=Article.Manual=MintyDocsManual.Manual,MintyDocsManual.ServiceId=Service.Id
+|fields=IpName,Version,Container,LastPublish
-     |fields=Article._pageName,Service.Name,Service.Id
+|where=DATEDIFF(LastPublish,NOW()) >= -1
-     |where=MintyDocsManual.ServiceId IS NOT NULL AND Article._pageNamespace="0" AND MintyDocsManual._pageNamespace="0"
+|limit=500
-     |default=
+|format=dynamic table
-     |limit=10000
+|merge similar cells=yes
-     |format=gantt
+}}
+|-|
+Last week=
+{{#cargo_query:
+tables=RNElements
+|fields=IpName,Version,Container,LastPublish
+|where=DATEDIFF(LastPublish,NOW()) >= -7
+|limit=500
+|format=dynamic table
+}}
+|-|
+Last 30 days=
+{{#cargo_query:
+tables=RNElements
+|fields=IpName,Version,Container,LastPublish
+|where=DATEDIFF(LastPublish,NOW()) >= -30
+|limit=500
+|format=dynamic table
+}}
+</tabber>
+{{#cargo_query:
+tables=RNElements
+|fields=IpName,Version,Container,LastPublish
+|where=LastPublish between date_sub(now(),INTERVAL 1 WEEK) and now ()
+}}
+{{#cargo_query:
+tables=RNElements
+|fields=IpName,Version,Container,LastPublish
+|where=LastPublish >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY AND LastPublish < curdate() - INTERVAL DAYOFWEEK(curdate())-1 DAY
+}}
+{{#cargo_query:
+tables=RNElements
+|fields=IpName,Version,Container,LastPublish
+|where=YEARWEEK(LastPublish) = YEARWEEK(NOW() - INTERVAL 1 WEEK)
 }}