JourneyMaterials: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly><!-- Template:JourneyMaterials ( | <includeonly><!-- Template:JourneyMaterials (fixed join order) --> | ||
{{#get_external_data: | |||
{{#get_external_data:source=externaldb | source = externaldb | ||
|from = data_journey_objectives | |||
|join on = data_journey_tasks.objective_id = data_journey_objectives.id; | |||
data_journey_task_components.task_id = data_journey_tasks.id; | |||
vw_recipe_inputs_by_level.root_item = data_journey_task_components.component_name | |||
|data = Level = vw_recipe_inputs_by_level.level, | |||
ItemLabel = vw_recipe_inputs_by_level.item_label, | |||
TotalQty = vw_recipe_inputs_by_level.total_qty, | |||
RootItem = vw_recipe_inputs_by_level.root_item | |||
|where = data_journey_objectives.journey_id = {{{id|{{{1|}}}}}} | |||
|group by = vw_recipe_inputs_by_level.root_item, | |||
vw_recipe_inputs_by_level.level, | |||
vw_recipe_inputs_by_level.item_label, | |||
vw_recipe_inputs_by_level.total_qty | |||
|order by = vw_recipe_inputs_by_level.root_item, | |||
vw_recipe_inputs_by_level.level, | |||
vw_recipe_inputs_by_level.item_label | |||
|cache = yes | |||
}} | }} | ||
<div class="materials-container"> | <div class="materials-container"> | ||