Actions

Template

JourneyMaterialsDebug: Difference between revisions

From Dune Awakening DB

← Older editNewer edit →
VisualWikitext
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><!-- Discover actual columns in journey tables -->
<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">
<h3>Discovering Table Columns</h3>
<h4>1. Simple select all from task components (first row):</h4>
{{#get_external_data:source=externaldb
|from=data_journey_task_components
|limit=1
}}
{{#for_external_table:|
{{#external_value:all}}
}}
<h4>2. Journey 4 Data Chain Test:</h4>
<!-- First, get objectives for journey 4 -->
{{#get_external_data:source=externaldb
|from=data_journey_objectives
|where=journey_id=4
|limit=2
}}
<strong>Objectives:</strong><br/>
{{#for_external_table:|
{{#external_value:all}}<br/>
}}
<!-- Get tasks for those objectives -->
{{#get_external_data:source=externaldb
{{#get_external_data:source=externaldb
  |from=data_journey_tasks
  |from=journey_task_components
  |join on=data_journey_objectives.id=data_journey_tasks.objective_id
  |join on=data_journey_tasks.id=journey_task_components.task_id,data_journey_objectives.id=data_journey_tasks.objective_id
|data=JourneyID=data_journey_objectives.journey_id,ResourceID=journey_task_components.resource_id,Qty=journey_task_components.qty
  |where=data_journey_objectives.journey_id=4
  |where=data_journey_objectives.journey_id=4
|limit=3
}}
<strong>Tasks:</strong><br/>
{{#for_external_table:|
{{#external_value:all}}<br/>
}}
}}


<!-- Get components for those tasks -->
Journey 4 needs these resources:
{{#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
|where=data_journey_objectives.journey_id=4
|limit=5
}}
<strong>Components:</strong><br/>
{{#for_external_table:|
{{#for_external_table:|
{{#external_value:all}}<br/>
- {{{ResourceID}}} x{{{Qty}}}
}}
}}
<h4>3. Sample Recipe View Data:</h4>
{{#get_external_data:source=externaldb
|from=vw_recipe_inputs_by_level
|where=root_item='Water_Recovery_System'
|limit=5
}}
{{#for_external_table:|
Root: {{{root_item}}}, Level: {{{level}}}, Item: {{{item_label}}} ({{{internal_name}}}), Qty: {{{total_qty}}}<br/>
}}
</div>
</includeonly><noinclude>
This discovers the actual column structure.
Usage: <nowiki>{{JourneyMaterialsDebug4|id=4}}</nowiki>
</noinclude>

Revision as of 14:22, 31 May 2025

The query SELECT data_journey_objectives.journey_id,journey_task_components.resource_id,journey_task_components.qty FROM `data_journey_objectives` JOIN `journey_task_components` ON ((data_journey_tasks.id = journey_task_components.task_id)) JOIN `data_journey_tasks` ON ((data_journey_objectives.id = data_journey_tasks.objective_id)) WHERE data_journey_objectives.journey_id=4 is invalid (Error 1146: Table 'dunedbco_ddb.journey_task_components' doesn't exist Function: EDConnectorRdbms::fetch Query: SELECT data_journey_objectives.journey_id,journey_task_components.resource_id,journey_task_components.qty FROM `data_journey_objectives` JOIN `journey_task_components` ON ((data_journey_tasks.id = journey_task_components.task_id)) JOIN `data_journey_tasks` ON ((data_journey_objectives.id = data_journey_tasks.objective_id)) WHERE data_journey_objectives.journey_id=4 ).

Journey 4 needs these resources:

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