Template:Query atlas maps/testcases: Difference between revisions
Jump to navigation
Jump to search
KickahaOta (talk | contribs) (Trying a subst) |
KickahaOta (talk | contribs) (Corrected parameter name) |
||
| Line 3: | Line 3: | ||
===Query=== | ===Query=== | ||
<pre>{{Query atlas maps | <pre>{{Query atlas maps | ||
| | |region_name=Valdo's Rest | ||
}}</pre | }}</pre> | ||
===Result (live)=== | ===Result (live)=== | ||
{{Query atlas maps | {{Query atlas maps | ||
| | |region_name=Valdo's Rest | ||
}} | }} | ||
===Result (sandbox)=== | ===Result (sandbox)=== | ||
{{Query atlas maps/sandbox | {{Query atlas maps/sandbox | ||
| | |region_name=Valdo's Rest | ||
}} | }} | ||
| Line 24: | Line 24: | ||
AND items.drop_enabled = true | AND items.drop_enabled = true | ||
AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) | AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) | ||
AND atlas_maps.region_id = "{{#cargo_query: |tables=atlas_regions|fields=id|where=name=" | AND atlas_maps.region_id = "{{#cargo_query: |tables=atlas_regions|fields=id|where=name="Valdo's Rest"|no html}}" | ||
{{#if: |AND ()|}} | {{#if: |AND ()|}} | ||
|q_orderBy=maps.tier | |q_orderBy=maps.tier | ||
Revision as of 02:42, 29 November 2021
Basic test
Query
{{Query atlas maps
|region_name=Valdo's Rest
}}
Result (live)
| Item | Map Tier | Atlas map tier based on region | Atlas map level based on region | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Result (sandbox)
| Item | Map Tier | Atlas map tier based on region | Atlas map level based on region | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Subst (sandbox)
| Item | Map Tier | Atlas map tier based on region | Atlas map level based on region | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|