Changes between Version 8 and Version 9 of AdvancedDatabaseDevelopment

Timestamp:

02/20/26 05:44:53 (4 days ago)

Author:

221181

Comment:

--

AdvancedDatabaseDevelopment

@@ -183 +183 @@
 FOR EACH ROW EXECUTE FUNCTION stock_management.log_price_change();
 }}}
+
+Извештај кој ги прикажува сите промени на цените во лог табелата заедно со информациите за корисникот, производот, старата и новата цена и датумот.
+
+{{{#!sql
+SELECT 
+    changed_at   AS "When",
+    changed_by   AS "Who",
+    product_name AS "Product",
+    old_price    AS "Old Price",
+    new_price    AS "New Price"
+FROM stock_management.product_price_log
+ORDER BY changed_at DESC;
+}}}