Template:JourneyMaterialsDebug - Revision history

Operator at 18:25, 31 May 2025

2025-05-31T18:25:40Z

← Older revision		Revision as of 14:25, 31 May 2025
Line 1:		Line 1:
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=~~data_journey_task_components~~		\|from=data_journey_objectives
	\|join on=data_journey_tasks.id=data_journey_task_components.task_id~~,data_journey_objectives.id~~=data_journey_tasks.~~objective_id~~		\|join on=data_journey_tasks.objective_id=data_journey_objectives.id,data_journey_task_components.task_id=data_journey_tasks.id
	\|data=JourneyID=data_journey_objectives.journey_id,ResourceID=data_journey_task_components.resource_id,Qty=data_journey_task_components.qty		\|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
	}}

	~~Journey 4 needs these resources:~~
	~~{{#for_external_table:\|~~
	~~- {{{ResourceID}}} x{{{Qty}}}~~
	}}		}}

Operator at 18:23, 31 May 2025

2025-05-31T18:23:34Z

← Older revision		Revision as of 14:23, 31 May 2025
Line 1:		Line 1:
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=~~journey_task_components~~		\|from=data_journey_task_components
	\|join on=data_journey_tasks.id=~~journey_task_components~~.task_id,data_journey_objectives.id=data_journey_tasks.objective_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=~~journey_task_components~~.resource_id,Qty=~~journey_task_components~~.qty		\|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
	}}		}}

Operator at 18:22, 31 May 2025

2025-05-31T18:22:14Z

@@ Line 1: / Line 1: @@
 {{#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
   |where=data_journey_objectives.journey_id=4
 }}
-<!-- Get components for those tasks -->
+Journey 4 needs these resources:
 {{#for_external_table:|
-{{#external_value:all}}<br/>
+- {{{ResourceID}}} x{{{Qty}}}
 }}

Operator at 18:16, 31 May 2025

2025-05-31T18:16:10Z

← Older revision		Revision as of 14:16, 31 May 2025
Line 1:		Line 1:
	<includeonly><!-- ~~Find~~ actual ~~column names~~ -->		<includeonly><!-- Discover actual columns in journey tables -->
	<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">		<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">
	<h3>~~Finding Actual Column Names~~</h3>		<h3>Discovering Table Columns</h3>

	<h4>1. ~~All Journey Task Components~~:</h4>		<h4>1. Simple select all from task components (first row):</h4>
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=data_journey_task_components		\|from=data_journey_task_components
	\|~~data~~=~~task_id~~=~~task_id,component_name~~=~~component_name~~		\|limit=1
	\|limit=5		}}
			{{#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
			\|from=data_journey_tasks
			\|join on=data_journey_objectives.id=data_journey_tasks.objective_id
			\|where=data_journey_objectives.journey_id=4
			\|limit=3
	}}		}}
			<strong>Tasks:</strong><br/>
	{{#for_external_table:\|		{{#for_external_table:\|
	~~Task ID:~~ {{~~{task_id}}}, Component~~: ~~{{{component_name}~~}}<br/>		{{#external_value:all}}<br/>
	}}		}}

	<~~h4>2. Components~~ for ~~Tasks in Journey {{{id\|{{{1\|}}}}}}:</h4~~>		<!-- Get components for those tasks -->
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=data_journey_task_components		\|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		\|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=4
	\|~~where~~=~~data_journey_objectives.journey_id={~~{{id\|{{~~{1\|}}}}~~}}		\|limit=5
			}}
			<strong>Components:</strong><br/>
			{{#for_external_table:\|
			{{#external_value:all}}<br/>
	}}		}}
	~~Components needed for this journey: {{#for_external_table:\|{{{component}}} \| }}~~

	<h4>3. ~~Check if any components match recipe view items~~:</h4>		<h4>3. Sample Recipe View Data:</h4>
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=vw_recipe_inputs_by_level		\|from=vw_recipe_inputs_by_level
	\|~~data=root_item~~=root_item~~,internal_name~~=~~internal_name~~		\|where=root_item='Water_Recovery_System'
	~~\|where=root_item IN ('Advanced_SurvivalFabricator_Placeable','T5DeepDesertShieldWallComponent',~~'~~T2MachineComponent~~')		\|limit=5
	\|limit=10
	}}		}}
	{{#for_external_table:\|		{{#for_external_table:\|
	Root: {{{root_item}}}, ~~Internal~~: {{{internal_name}}}<br/>		Root: {{{root_item}}}, Level: {{{level}}}, Item: {{{item_label}}} ({{{internal_name}}}), Qty: {{{total_qty}}}<br/>
	}}		}}

	</div>		</div>
	</includeonly><noinclude>		</includeonly><noinclude>
	This ~~finds~~ the actual column ~~names in the tables~~.		This discovers the actual column structure.

	Usage: <nowiki>{{~~JourneyMaterialsDebug3~~\|id=4}}</nowiki>		Usage: <nowiki>{{JourneyMaterialsDebug4\|id=4}}</nowiki>
	</noinclude>		</noinclude>

Operator at 18:00, 31 May 2025

2025-05-31T18:00:28Z

← Older revision		Revision as of 14:00, 31 May 2025
Line 1:		Line 1:
	<includeonly><!-- ~~Debug version 2 - find correct columns~~ -->		<includeonly><!-- Find actual column names -->
	<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">		<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">
	<h3>Finding ~~Correct~~ Column Names</h3>		<h3>Finding Actual Column Names</h3>

	<h4>1. Journey ~~Objectives Columns:</h4>~~		<h4>1. All Journey Task Components:</h4>
	~~{{#get_external_data:source=externaldb~~
	~~\|from=data_journey_objectives~~
	~~\|data=id=id,journey_id=journey_id,objective_name=objective_name,description=description~~
	~~\|where=journey_id={{{id\|{{{1\|}}}}}}~~
	~~\|limit=1~~
	}}
	~~{{#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		{{#get_external_data:source=externaldb
	\|from=data_journey_task_components		\|from=data_journey_task_components
	\|data=task_id=task_id,~~item_name~~=~~item_name,quantity=quantity~~		\|data=task_id=task_id,component_name=component_name
	\|limit=5		\|limit=5
	}}		}}
	{{#for_external_table:\|		{{#for_external_table:\|
	Task: {{{task_id}}}, ~~Item~~: {{{~~item_name}}}, Qty: {{{quantity~~}}}<br/>		Task ID: {{{task_id}}}, Component: {{{component_name}}}<br/>
	}}		}}

	<h4>4. Components for Journey {{{id\|{{{1\|}}}}}}:</h4>		<h4>2. Components for Tasks in Journey {{{id\|{{{1\|}}}}}}:</h4>
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=data_journey_task_components		\|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		\|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~~		\|data=component=data_journey_task_components.component_name
	\|where=data_journey_objectives.journey_id={{{id\|{{{1\|}}}}}}		\|where=data_journey_objectives.journey_id={{{id\|{{{1\|}}}}}}
	}}		}}
	~~Items~~ needed: {{#for_external_table:\|{{{~~item_name~~}}} ~~(x{{{quantity}}})~~ \| }}		Components needed for this journey: {{#for_external_table:\|{{{component}}} \| }}

	<h4>5. ~~Sample data from~~ recipe view:</h4>		<h4>3. Check if any components match recipe view items:</h4>
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=vw_recipe_inputs_by_level		\|from=vw_recipe_inputs_by_level
	\|data=root_item=root_item,~~item_label~~=~~item_label~~,~~level=level~~,~~total_qty=total_qty~~		\|data=root_item=root_item,internal_name=internal_name
	\|limit=5		\|where=root_item IN ('Advanced_SurvivalFabricator_Placeable','T5DeepDesertShieldWallComponent','T2MachineComponent')
			\|limit=10
	}}		}}
	{{#for_external_table:\|		{{#for_external_table:\|
	{{{root_item}}} ~~→ Level {{{level}}}~~: {{{~~item_label}}} x{{{total_qty~~}}}<br/>		Root: {{{root_item}}}, Internal: {{{internal_name}}}<br/>
	}}		}}

	</div>		</div>
	</includeonly><noinclude>		</includeonly><noinclude>
	This finds the ~~correct~~ column names ~~for~~ the ~~journey materials query~~.		This finds the actual column names in the tables.

	Usage: <nowiki>{{~~JourneyMaterialsDebug2~~\|id=4}}</nowiki>		Usage: <nowiki>{{JourneyMaterialsDebug3\|id=4}}</nowiki>
	</noinclude>		</noinclude>

Operator at 17:57, 31 May 2025

2025-05-31T17:57:46Z

← Older revision		Revision as of 13:57, 31 May 2025
Line 1:		Line 1:
	<includeonly><!-- Debug version ~~to test the query~~ -->		<includeonly><!-- Debug version 2 - find correct columns -->
	<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">		<div style="background: #333; border: 2px solid yellow; padding: 15px; color: white;">
	<h3>~~Debug Info for Journey {{{id\|{{{1\|}}}}}}~~</h3>		<h3>Finding Correct Column Names</h3>

	<h4>1. ~~Testing Basic Query (no joins)~~:</h4>		<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=journey_id=journey_id,objective_name=~~name~~		\|data=id=id,journey_id=journey_id,objective_name=objective_name,description=description
	\|where=journey_id={{{id\|{{{1\|}}}}}}		\|where=journey_id={{{id\|{{{1\|}}}}}}
			\|limit=1
	}}		}}
	{{#for_external_table:\|		{{#for_external_table:\|
	Journey {{{journey_id}}}: {{{objective_name}}}<br/>		ID: {{{id}}}, Journey: {{{journey_id}}}, Name: {{{objective_name}}}, Desc: {{{description}}}<br/>
	}}		}}

	<h4>2. ~~Testing~~ Task Components:</h4>		<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		{{#get_external_data:source=externaldb
	\|from=data_journey_task_components		\|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		\|join on=data_journey_tasks.id=data_journey_task_components.task_id,data_journey_objectives.id=data_journey_tasks.objective_id
	\|data=~~component_name~~=data_journey_task_components.~~component_name~~		\|data=item_name=data_journey_task_components.item_name,quantity=data_journey_task_components.quantity
	\|where=data_journey_objectives.journey_id={{{id\|{{{1\|}}}}}}		\|where=data_journey_objectives.journey_id={{{id\|{{{1\|}}}}}}
	~~\|limit=5~~
	}}		}}
	~~Components~~: {{#for_external_table:\|{{{~~component_name~~}}} \| }}		Items needed: {{#for_external_table:\|{{{item_name}}} (x{{{quantity}}}) \| }}

	<h4>3. ~~Testing if~~ view ~~exists (simple select)~~:</h4>		<h4>5. Sample data from recipe view:</h4>
	{{#get_external_data:source=externaldb		{{#get_external_data:source=externaldb
	\|from=vw_recipe_inputs_by_level		\|from=vw_recipe_inputs_by_level
	\|data=root_item=root_item,level=level		\|data=root_item=root_item,item_label=item_label,level=level,total_qty=total_qty
	\|limit=3		\|limit=5
			}}
			{{#for_external_table:\|
			{{{root_item}}} → Level {{{level}}}: {{{item_label}}} x{{{total_qty}}}<br/>
	}}		}}
	~~{{#for_external_table:\|Level {{{level}}} - {{{root_item}}}<br/>}}~~

	</div>		</div>
	</includeonly><noinclude>		</includeonly><noinclude>
	This ~~template helps debug~~ the materials query.		This finds the correct column names for the journey materials query.

	Usage: <nowiki>{{~~JourneyMaterialsDebug~~\|id=4}}</nowiki>		Usage: <nowiki>{{JourneyMaterialsDebug2\|id=4}}</nowiki>
	</noinclude>		</noinclude>

Operator: Created page with "

Debug Info for Journey {{{id|{{{1|}}}}}}

1. Testing Basic Query (no joins):
{{#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}}}
}}..."

2025-05-31T17:53:36Z

Created page with "<includeonly> <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/> }}..."

New page

<includeonly>
<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/>
}}

<h4>2. Testing Task Components:</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_name=data_journey_task_components.component_name
|where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}}
|limit=5
}}
Components: {{#for_external_table:|{{{component_name}}} | }}

<h4>3. Testing if view exists (simple select):</h4>
{{#get_external_data:source=externaldb
|from=vw_recipe_inputs_by_level
|data=root_item=root_item,level=level
|limit=3
}}
{{#for_external_table:|Level {{{level}}} - {{{root_item}}}<br/>}}

</div>
</includeonly><noinclude>
This template helps debug the materials query.

Usage: <nowiki>{{JourneyMaterialsDebug|id=4}}</nowiki>
</noinclude>