JourneyMaterials: Difference between revisions

Revision as of 15:31, 1 June 2025

The query SELECT level,item_label,total_qty FROM `data_journey_materials` WHERE journey_id = ORDER BY level, item_label is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY level, item_label' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT level,item_label,total_qty FROM `data_journey_materials` WHERE journey_id = ORDER BY level, item_label ).

</includeonly>Template:Documentation

@@ Line 1: / Line 1: @@
-<includeonly><!-- Template:JourneyMaterials (stored-procedure version) -->
+{{#get_external_data:
-{{#get_db_data:
+  source = externaldb
-db=externaldb
+  |from  = data_journey_materials
-|sql=CALL sp_journey_components_bom({{{id|{{{1|}}}}}})
+  |data  = Level=level, ItemLabel=item_label, TotalQty=total_qty
-|data=Level=level,
+  |where = journey_id = {{{id|{{{1|}}}}}}
-       ItemLabel=item_label,
+  |order by = level, item_label
-       TotalQty=total_qty
-|cache seconds=3600
-|debug=true
-|cache=no
 }}
 <div class="materials-container" style="max-height:600px;overflow-y:auto;">

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

Revision as of 15:31, 1 June 2025