|
|
| (4 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| <includeonly><!-- Debug version 2 - find correct columns -->
| |
| <div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">
| |
| <h3>Finding Correct Column Names</h3>
| |
|
| |
| <h4>1. Journey Objectives Columns:</h4>
| |
| {{#get_external_data:source=externaldb | | {{#get_external_data:source=externaldb |
| |from=data_journey_objectives | | |from=data_journey_objectives |
| |data=id=id,journey_id=journey_id,objective_name=objective_name,description=description | | |join on=data_journey_tasks.objective_id=data_journey_objectives.id,data_journey_task_components.task_id=data_journey_tasks.id |
| |where=journey_id={{{id|{{{1|}}}}}} | | |data=JourneyID=data_journey_objectives.journey_id,ResourceID=data_journey_task_components.resource_id,Qty=data_journey_task_components.qty |
| |limit=1
| | |where=data_journey_objectives.journey_id=4 |
| }} | | }} |
| {{#for_external_table:|
| |
| ID: {{{id}}}, Journey: {{{journey_id}}}, Name: {{{objective_name}}}, Desc: {{{description}}}<br/>
| |
| }}
| |
|
| |
| <h4>2. Journey Tasks for this Journey:</h4>
| |
| {{#get_external_data:source=externaldb
| |
| |from=data_journey_tasks
| |
| |join on=data_journey_objectives.id=data_journey_tasks.objective_id
| |
| |data=task_id=data_journey_tasks.id,task_name=data_journey_tasks.task_name,objective_id=data_journey_tasks.objective_id
| |
| |where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}}
| |
| |limit=3
| |
| }}
| |
| {{#for_external_table:|
| |
| Task ID: {{{task_id}}}, Name: {{{task_name}}}, Objective: {{{objective_id}}}<br/>
| |
| }}
| |
|
| |
| <h4>3. Task Components (what items are needed):</h4>
| |
| {{#get_external_data:source=externaldb
| |
| |from=data_journey_task_components
| |
| |data=task_id=task_id,item_name=item_name,quantity=quantity
| |
| |limit=5
| |
| }}
| |
| {{#for_external_table:|
| |
| Task: {{{task_id}}}, Item: {{{item_name}}}, Qty: {{{quantity}}}<br/>
| |
| }}
| |
|
| |
| <h4>4. Components for 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=item_name=data_journey_task_components.item_name,quantity=data_journey_task_components.quantity
| |
| |where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}}
| |
| }}
| |
| Items needed: {{#for_external_table:|{{{item_name}}} (x{{{quantity}}}) | }}
| |
|
| |
| <h4>5. Sample data from recipe view:</h4>
| |
| {{#get_external_data:source=externaldb
| |
| |from=vw_recipe_inputs_by_level
| |
| |data=root_item=root_item,item_label=item_label,level=level,total_qty=total_qty
| |
| |limit=5
| |
| }}
| |
| {{#for_external_table:|
| |
| {{{root_item}}} → Level {{{level}}}: {{{item_label}}} x{{{total_qty}}}<br/>
| |
| }}
| |
|
| |
| </div>
| |
| </includeonly><noinclude>
| |
| This finds the correct column names for the journey materials query.
| |
|
| |
| Usage: <nowiki>{{JourneyMaterialsDebug2|id=4}}</nowiki>
| |
| </noinclude>
| |
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
).
