JourneyMaterialsDebug: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{#get_external_data:source=externaldb | {{#get_external_data:source=externaldb | ||
|from= | |from=data_journey_task_components | ||
|join on=data_journey_tasks.id= | |join on=data_journey_tasks.id=data_journey_task_components.task_id,data_journey_objectives.id=data_journey_tasks.objective_id | ||
|data=JourneyID=data_journey_objectives.journey_id,ResourceID= | |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 | |where=data_journey_objectives.journey_id=4 | ||
}} | }} | ||
Revision as of 14:23, 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_objectives` JOIN `data_journey_task_components` ON ((data_journey_tasks.id = data_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 1054: Unknown column 'data_journey_tasks.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_objectives` JOIN `data_journey_task_components` ON ((data_journey_tasks.id = data_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: