Changes between Version 1 and Version 2 of ImportantUseCase3

Timestamp:

02/14/23 19:40:08 (17 months ago)

Author:

201065

Comment:

--

ImportantUseCase3

@@ -22 +22 @@
 select articlename, price, quantity, orderid, imageurl from orderedarticles o
 left join articles a on a.articleid=o.articleid
-where articlestatus='Delivered' and locationid=3
+where articlestatus='DELIVERED' and locationid=3
 }}}
 
@@ -54 +54 @@
 {{{#!sql
 update orderedarticles 
-set articlestatus='Processed'
+set articlestatus='PROCESSED'
 where oarticleid=3
 }}}
@@ -64 +64 @@
 {{{#!sql
 update orders 
-set status='Processed'
+set status='PROCESSED'
 where orderid=3
 }}}