JourneyMaterials: Difference between revisions

Revision as of 13:59, 1 June 2025

Error: No "from / join on" parameter specified.

@@ Line 1: / Line 1: @@
-<includeonly><!-- Template:JourneyMaterials (stored-procedure version) -->
 {{#get_db_data:
-  db=externaldb                         <!-- name from LocalSettings $edgDBServers -->
+  db=externaldb
-  |sql=CALL sp_journey_components_bom({{{id|{{{1|}}}}}})   <!-- no semicolon -->
+  |sql=CALL sp_journey_components_bom(4)
-  |data=Level=level,
+  |data=Level=level, Item=item_label, Qty=total_qty
-        ItemLabel=item_label,
+ |debug=true         <!-- shows raw SQL + first rows -->
-         TotalQty=total_qty
+  |cache=no           <!-- disable cache while testing -->
-  |cache seconds=3600                   <!-- optional -->
 }}
 <div class="materials-container" style="max-height:600px;overflow-y:auto;">