Changes between Version 13 and Version 14 of AdvancedReports

Timestamp:

02/28/23 13:30:16 (19 months ago)

Author:

201065

Comment:

--

AdvancedReports

@@ -6 +6 @@
 (select a.articlename from project.articles a
     left join project.invoicedarticles i2 on i2.articleid=a.articleid
-    where i2.price*i2.quantity=max(ba.totalPrice)
+    where i2.price*i2.quantity=max(ba.totalPrice) and i2.invoiceid = min(ti.invoiceid)
     limit 1) as topArticleName,
 (select i2.price  from project.articles a
     left join project.invoicedarticles i2 on i2.articleid=a.articleid
-    where i2.price*i2.quantity=max(ba.totalPrice)
+    where i2.price*i2.quantity=max(ba.totalPrice) and i2.invoiceid = min(ti.invoiceid)
     limit 1) as topArticlePrice,
 (select i2.quantity from project.articles a
     left join project.invoicedarticles i2 on i2.articleid=a.articleid
-    where i2.price*i2.quantity=max(ba.totalPrice)
+    where i2.price*i2.quantity=max(ba.totalPrice) and i2.invoiceid = min(ti.invoiceid)
     limit 1) as topArticleQuantity,
 max(ba.totalPrice) as topArticleTotalPrice from project.workers w