JourneyMaterials: Difference between revisions

Revision as of 18:12, 31 May 2025

@@ Line 1: / Line 1: @@
-<includeonly><!--  Template:JourneyMaterials  -->
+<includeonly><!-- Template:JourneyMaterials (stored-procedure version) -->
-{{#get_external_data:
+{{#get_db_data:
-  source = externaldb
+ db=externaldb                         <!-- name from LocalSettings $edgDBServers -->
-  |sql   = CALL sp_journey_components_bom({{{id|{{{1|}}}}}})
+ |sql=CALL sp_journey_components_bom({{{id|{{{1|}}}}}})   <!-- no semicolon -->
-  |data  = Level     = level,
+ |data=Level=level,
-           ItemLabel = item_label,
+        ItemLabel=item_label,
-           TotalQty  = total_qty
+        TotalQty=total_qty
-  |cache seconds = 3600
+ |cache seconds=3600                   <!-- optional -->
 }}