Actions

Template

JourneyMaterialsDebug: Difference between revisions

From Dune Awakening DB

← Older edit
VisualWikitext
mNo edit summary
mNo edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><!-- Find actual column names -->
<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">
<h3>Finding Actual Column Names</h3>
<h4>1. All Journey Task Components:</h4>
{{#get_external_data:source=externaldb
{{#get_external_data:source=externaldb
  |from=data_journey_task_components
  |from=data_journey_objectives
  |data=task_id=task_id,component_name=component_name
|join on=data_journey_tasks.objective_id=data_journey_objectives.id,data_journey_task_components.task_id=data_journey_tasks.id
  |limit=5
  |data=JourneyID=data_journey_objectives.journey_id,ResourceID=data_journey_task_components.resource_id,Qty=data_journey_task_components.qty
  |where=data_journey_objectives.journey_id=4
}}
}}
{{#for_external_table:|
Task ID: {{{task_id}}}, Component: {{{component_name}}}<br/>
}}
<h4>2. Components for Tasks in Journey {{{id|{{{1|}}}}}}:</h4>
{{#get_external_data:source=externaldb
|from=data_journey_task_components
|join on=data_journey_tasks.id=data_journey_task_components.task_id,data_journey_objectives.id=data_journey_tasks.objective_id
|data=component=data_journey_task_components.component_name
|where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}}
}}
Components needed for this journey: {{#for_external_table:|{{{component}}} | }}
<h4>3. Check if any components match recipe view items:</h4>
{{#get_external_data:source=externaldb
|from=vw_recipe_inputs_by_level
|data=root_item=root_item,internal_name=internal_name
|where=root_item IN ('Advanced_SurvivalFabricator_Placeable','T5DeepDesertShieldWallComponent','T2MachineComponent')
|limit=10
}}
{{#for_external_table:|
Root: {{{root_item}}}, Internal: {{{internal_name}}}<br/>
}}
</div>
</includeonly><noinclude>
This finds the actual column names in the tables.
Usage: <nowiki>{{JourneyMaterialsDebug3|id=4}}</nowiki>
</noinclude>

Latest revision as of 14:25, 31 May 2025

The query SELECT data_journey_objectives.journey_id,data_journey_task_components.resource_id,data_journey_task_components.qty FROM `data_journey_task_components` JOIN `data_journey_objectives` ON ((data_journey_tasks.objective_id = data_journey_objectives.id)) JOIN `data_journey_tasks` ON ((data_journey_task_components.task_id = data_journey_tasks.id)) WHERE data_journey_objectives.journey_id=4 is invalid (Error 1054: Unknown column 'data_journey_tasks.objective_id' in 'ON' Function: EDConnectorRdbms::fetch Query: SELECT data_journey_objectives.journey_id,data_journey_task_components.resource_id,data_journey_task_components.qty FROM `data_journey_task_components` JOIN `data_journey_objectives` ON ((data_journey_tasks.objective_id = data_journey_objectives.id)) JOIN `data_journey_tasks` ON ((data_journey_task_components.task_id = data_journey_tasks.id)) WHERE data_journey_objectives.journey_id=4 ).

Retrieved from "https://dunedb.com/index.php?title=Template:JourneyMaterialsDebug&oldid=802"