Test-ParserFunctions-in-ExternalData: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 33: | Line 33: | ||
====ExternalData without wiki table markup==== | ====ExternalData without wiki table markup==== | ||
{{#for_external_table: Wiki User "{{{WikiUsername}}}" is {{{Role}}} "{{{Name}}}", who is a {{#ifeq: "{{{Role}}}" | "Manager" | volunteer | non-volunteer ({{{Role}}} != Manager).<p>}} }} | {{#for_external_table: {{ #if: {{{Role|}}} | Role is defined and non-empty | Role is undefined or empty}}. {{ #ifeq: {{{Role|+}}} | {{{Role|-}}} | Role is defined | Role is undefined }}. Wiki User "{{{WikiUsername}}}" is {{{Role}}} "{{{Name}}}", who is a {{#ifeq: "{{{Role}}}" | "Manager" | volunteer | non-volunteer ({{{Role}}} != Manager).<p>}} }} | ||
Revision as of 23:42, 22 May 2020
TEST
Current Roster
Test Ifeq & Ifexist Outside ExternalData call, with no variables:
Test Ifeq: Result is.... Mharrit1 = Mharrit1
Test IfExist: Result is.... Mharrit1 User Page Exists
Test ifexist in an ExternalData call:
{{#get_web_data:
url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQ79_XSVSyq0np8gtz-vCd-Fdcz5D_HqxheK7HOSPjuxocT0_XKMHvnSgKFIlyMnAoGuN214VqjkmU5/pub?gid=1533673129&single=true&output=csv |format=CSV with header |data=Name=Name, Email=BestEmail, Role=Primary Role, FirstName=FirstName, LastName=LastName, NickName=NickName, WikiUsername=WikiUsername
}}
| Name | Wiki User Page | Role | Test
{{#for_external_table: |
|---|---|---|---|
| {{{Name}}} | [[User:{{{WikiUsername}}}| {{{WikiUsername}}} Userpage ]] | {{{Role}}} | NO User Page
}} |
ExternalData without wiki table markup
{{#for_external_table: Role is undefined or empty. Role is undefined. Wiki User "{{{WikiUsername}}}" is {{{Role}}} "{{{Name}}}", who is a non-volunteer ({{{Role}}} != Manager).
}}
Use Display External Table
| Name | Role | BestEmail | WikiUsername
{{#display_external_table:template=ManagerData|data=Name=Name, Role=Role, Email=Email, WikiUsername=WikiUsername }} |
|---|
ManagerData Template:
|-
| {{{Role}}}
| {{{FirstName}}}
| {{{LastName}}}
| User:{{{WikiUsername}}} (Page not created)
([[special:Contributions/{{{WikiUsername}}} | {{{FirstName}}}'s Wiki Contributions]])
| send email