JourneyMaterialsDebug: Difference between revisions
From Dune Awakening DB
Created page with "<includeonly><!-- Debug version to test the query --> <div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;"> <h3>Debug Info for Journey {{{id|{{{1|}}}}}}</h3> <h4>1. Testing Basic Query (no joins):</h4> {{#get_external_data:source=externaldb |from=data_journey_objectives |data=journey_id=journey_id,objective_name=name |where=journey_id={{{id|{{{1|}}}}}} }} {{#for_external_table:| Journey {{{journey_id}}}: {{{objective_name}}}<br/> }}..." |
mNo edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#get_external_data:source=externaldb | {{#get_external_data:source=externaldb | ||
|from=data_journey_objectives | |from=data_journey_objectives | ||
|data=journey_id= | |join on=data_journey_tasks.objective_id=data_journey_objectives.id,data_journey_task_components.task_id=data_journey_tasks.id | ||
|where=journey_id= | |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 | |||
}} | }} | ||
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 ).