Editing User:Stevium/sandbox2

==All neighbors with filters==
{{Filter/Header|id=neighbor-list|type=neighbors}}
{{Filter
|column = 4
|all = true
|mode = contains
|label = Galaxy:
|1 = [[File:Hexia Icon.png|30px|link=|class=day-invert-image]]
|query1 = Hexia
|2 = [[File:Taffeh Icon.png|30px|link=|class=day-invert-image]]
|query2 = Taffeh
|3 = [[File:Norvan Icon.png|30px|link=|class=day-invert-image]]
|query3 = Norvan
}}
{{Filter
|column = 5
|all = true
|label = Pronouns:
|1 = He/Him
|2 = She/Her
}}
{{Filter/Footer}}
{{#invoke:Bucket|get|neighbors
|select = page_name, birthday, role, galaxy, pronouns, loves, likes, dislikes
|where = {{{where|}}}
|filter = {{{filter|}}}
|order by = page_name

|format = userformat
|show resultsHeader = false
|header = <!--
--><table id="neighbor-list" class="wikitable sortable"><!--
--><tr><!--
--><th class="unsortable">Icon</th><!--
--><th>Name</th><!--
--><th>Role</th><!--
--><th>Galaxy</th><!--
--><th>Pronouns</th><!--
--><th>Birthday</th><!--
--><th>Loves</th><!--
--><th>Likes</th><!--
--><th>Dislikes</th><!--
--></tr>
|userformat = <!--
--><tr><!--
--><td>{{Item|size=50|%page_name%|notext=1}}</td><!--
--><td>[[%page_name%]]</td><!--
--><td>%role%</td><!--
--><td><nowiki>{{#if:%galaxy%|{{Item|%galaxy%|invert=Day}}}}</nowiki></td><!--
--><td>%pronouns%</td><!--
--><td>%birthday%</td><!--
--><td><nowiki>{{Item List|%loves%}}</nowiki></td><!--
--><td><nowiki>{{List|%likes%}}</nowiki></td><!--
--><td><nowiki>{{List|%dislikes%}}</nowiki></td><!--
--></tr>
|footer = </table>
}}

==Select neighbors==
===By loves===
{{#invoke:Bucket|get|neighbors
|select = page_name, real_name, birthday, role, galaxy, loves, likes, dislikes
|where = (loves="Caterpillar Fungus Herbal Remedy")
|order by = page_name

|format = userformat
|resultsHeader = '''%TOTALRESULTS%''' [[neighbor]]%S% loves {{Item|Caterpillar Fungus Herbal Remedy}}:
|header = <!--
--><table id="{{{id|}}}" class="wikitable sortable"><!--
--><tr><!--
--><th class="unsortable">Icon</th><!--
--><th>Name</th><!--
--><th>Real Name</th><!--
--><th>Birthday</th><!--
--><th>Role</th><!--
--><th>Galaxy</th><!--
--><th>Loves</th><!--
--><th>Likes</th><!--
--><th>Dislikes</th><!--
--></tr>
|userformat = <!--
--><tr><!--
--><td>{{Item|size=50|%page_name%|notext=1}}</td><!--
--><td>[[%page_name%]]</td><!--
--><td>%real_name%</td><!--
--><td>%birthday%</td><!--
--><td>%role%</td><!--
--><td><nowiki>{{#if:%galaxy%|{{Item|%galaxy%}}}}</nowiki></td><!--
--><td><nowiki>{{Item List|%loves%}}</nowiki></td><!--
--><td><nowiki>{{List|%likes%}}</nowiki></td><!--
--><td><nowiki>{{List|%dislikes%}}</nowiki></td><!--
--></tr>
|footer = </table>
}}

===By birthday===
{{#invoke:Bucket|get|neighbors
|select = page_name, real_name, birthday, role, galaxy, loves, likes, dislikes
|filter = (birthday CONTAINS "July")
|order by = page_name

|format = userformat
|resultsHeader = '''%TOTALRESULTS%''' [[neighbor]]%S% celebrate their birthday in July:
|header = <!--
--><table id="{{{id|}}}" class="wikitable sortable"><!--
--><tr><!--
--><th class="unsortable">Icon</th><!--
--><th>Name</th><!--
--><th>Real Name</th><!--
--><th>Birthday</th><!--
--><th>Role</th><!--
--><th>Galaxy</th><!--
--><th>Loves</th><!--
--><th>Likes</th><!--
--><th>Dislikes</th><!--
--></tr>
|userformat = <!--
--><tr><!--
--><td>{{Item|size=50|%page_name%|notext=1}}</td><!--
--><td>[[%page_name%]]</td><!--
--><td>%real_name%</td><!--
--><td>%birthday%</td><!--
--><td>%role%</td><!--
--><td><nowiki>{{#if:%galaxy%|{{Item|%galaxy%}}}}</nowiki></td><!--
--><td><nowiki>{{Item List|%loves%}}</nowiki></td><!--
--><td><nowiki>{{List|%likes%}}</nowiki></td><!--
--><td><nowiki>{{List|%dislikes%}}</nowiki></td><!--
--></tr>
|footer = </table>
}}
File Pages	==Summary====Licensing=={{Fairuse}}{{File\|}}
Dynamic Page List	¦²«»²{¦}²«»«/»«!----»
Array in DPL	¹^2{}^2^2{¹}^2
Parser Functions	{{#if:\|\|}} {{#if:<condition>\|<result if true>\|<result if false>}} {{#ifeq:\|\|\|}} {{#ifeq:<text1>\|<text2>\|<result if text1=text2>\|<result if text1≠text2>}} {{#expr:}} {{#expr:<mathematical expression>}} {{#switch:\|\|#default=}} {{#switch:<text1>\|<text2>=<result if text1=text2>\|<text3>=<result if text1=text3>\|#default=<result if no valid match>}} {{#replace:\|\|}} {{#replace:<text1>\|<plain text to find in text1>\|<plain text to insert in place of the text found>}} {{#titleparts:}} {{#replace:<page name>}} {{#tag:\|}} {{#tag:<name of html tag>\|<content inside html tag>}}
Markup	{{}}\|[][[]][[Category:]]#REDIRECT [[]] [[Category:Redirect Pages]]<code></code><includeonly></includeonly><noinclude></noinclude><nowiki></nowiki><!----><br>§
Notices	{{Stub\|}}{{Stub Dialogue}}{{Upcoming}}{{Under Construction}}{{Placeholder\|}}
Magic Words	{{!}}{{formatnum:}}{{lc:}}{{uc:}}{{PAGENAME}}{{FULLPAGENAME}}{{ROOTPAGENAME}}{{BASEPAGENAME}}{{SUBPAGENAME}}{{DISPLAYTITLE:\|noreplace}}__TOC____NOTOC____EXPECTUNUSEDCATEGORY____HIDDENCAT__
HTML Entities	— ,