Difference between revisions of "User:Eave/Sandbox"
Jump to navigation
Jump to search
>Eave m (→Icons: fix mobile) |
>Eave |
||
| Line 28: | Line 28: | ||
[[File:110274 01 r05 portrait.png|150px]] | [[File:110274 01 r05 portrait.png|150px]] | ||
[[File:110260_01_r05_portrait.png|150px]] | [[File:110260_01_r05_portrait.png|150px]] | ||
| + | |||
| + | |||
| + | == Weird Cargo Query issue == | ||
| + | Happens when the WHERE clause mentions a List column name, but as the comparison value for a different field | ||
| + | |||
| + | Working: | ||
| + | {{#cargo_query:tables=SummonShowcase | ||
| + | |where=Title="5★ A\dventurer Platinum Showcase (Dec 2019)" | ||
| + | |fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video | ||
| + | |orderBy=StartDate DESC | ||
| + | |default=''There are currently no ongoing summon showcases.'' | ||
| + | }} | ||
| + | |||
| + | Not working: | ||
| + | {{#cargo_query:tables=SummonShowcase | ||
| + | |where=Title="5★ Adventurer Platinum Showcase (Dec 2019)" | ||
| + | |fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video | ||
| + | |orderBy=StartDate DESC | ||
| + | |default=''There are currently no ongoing summon showcases.'' | ||
| + | }} | ||
Revision as of 06:29, 16 July 2020
Boolean {{#if}} proof of concept using IsAffectedByTension
Void Volley (Should be TRUE)
Query result:
Error: Table Skills not found.
IF: TRUE
Abyssal Connection (Should be FALSE)
Query result:
Error: Table Skills not found.
IF: TRUE
Icons
Volk
Bad Mobile Thumbnails
Weird Cargo Query issue
Happens when the WHERE clause mentions a List column name, but as the comparison value for a different field
Working:
Error: Table SummonShowcase not found.
Not working:
Error: Table SummonShowcase not found.