User:Teamtoto/Sandbox: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 25: | Line 25: | ||
|where = F.Old="1" AND IsVisible="1" | |where = F.Old="1" AND IsVisible="1" | ||
}}--> | }}--> | ||
<table class="wikitable"> | |||
<tr> | |||
<th>Blueprint</th> | |||
<th>Body Parts</th> | |||
</tr> | |||
{{#invoke:CargoQuery|main | {{#invoke:CargoQuery|main | ||
|table=Anatomies=A | |||
|fields=Name=blueprint | |||
|one_to_many=(CONCAT("<li> [[List of Body Parts#", | |||
BaseType, "{{!}}", | |||
COALESCE(CONCAT(Laterality, " "), ""), | |||
Type, "]]", | |||
(CASE | |||
WHEN childType <> "" | |||
THEN CONCAT("<ul><li>", | |||
childType, " (", | |||
"", | |||
childBaseType, ")</ul>") | |||
ELSE "" | |||
END)))=bodyparts | |||
|one_to_many_group=blueprint | |||
|one_to_many_sep= | |||
| template=Anatomy Table Row | |||
| delimiter = </br> | |||
| limit = 1000 | |||
}} | |||
</table> | |||
<!--{{#invoke:CargoQuery|main | |||
|table=Anatomies=A | |table=Anatomies=A | ||
|fields=Name | |fields=Name | ||
|one_to_many=Type | |one_to_many=(CONCAT("<li> [[List of Body Parts#", BaseType, "!", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]"))=A | ||
|one_to_many_group=Name | |one_to_many_group=Name | ||
|one_to_many_sep= | |one_to_many_sep= | ||
|format = table | | format = table | ||
| limit = 1000 | | limit = 1000 | ||
}} | }}--> | ||
TODO: concat laterality and include child stuff, format it prettier? | TODO: concat laterality and include child stuff, format it prettier? |