Template:QuestionQuery: Difference between revisions

From Karteria DWRP Wiki
Jump to navigationJump to search
Icie (talk | contribs)
No edit summary
Tag: Reverted
Icie (talk | contribs)
No edit summary
 
(48 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><div class="question-table-wrapper">{{#ifeq: {{{1|}}}| FAQ Page | faq
<includeonly>{{#ifeq: {{{1|}}} | FAQ Page || {{#ifeq: {{{1|}}} | Topic || {{#ifeq: {{{1|}}} | Question |
  {| class="wikitable"
|{{#ifeq: {{{1|}}} | Keyword |
! 1
|QuestionQuery error: Supply FAQ Page, Topic, Keyword or Question as first parameter }}}}}}}}
! 2
{{#ifexpr: {{#ifeq: {{{1|}}} | FAQ Page | 1 | 0}} or {{#ifeq: {{{1|}}} | Topic | 1 | 0}} or {{#ifeq: {{{1|}}} | Question | 1 | 0}} or {{#ifeq: {{{1|}}} | Keyword | 1 | 0}} |
! 3
{{#cargo_query:tables=Questions|fields= _pageName = questionPage, trim(QuestionFaqPage)=faqPage,Link = questionLink, Topics__full=questionTopics,  AskedBy = questionFrom,DateAnswered=answerDate, DateAsked = askedDate, QuestionText=Question_Text, AnswerText=Answer_Text
{{#cargo_query:tables=Questions|fields= _pageName = questionPage, trim(QuestionFaqPage)=faqPage,Link = questionLink, Topics__full=questionTopics,  AskedBy = questionFrom,DateAnswered=answerDate, DateAsked = askedDate, QuestionText=Question_Text, AnswerText=Answer_Text
|where= QuestionFaqPage = 'Log - June 2025/Pre Event FAQ'  
|where= {{#ifeq: {{{1|}}}| FAQ Page | {{#arraymap: {{{2|}}}|,|xx| QuestionFaqPage = 'xx' |\s or \s}} |
|group_by= _pageName = questionPage, trim(QuestionFaqPage)=faqPage,Link = questionLink, Topics__full=questionTopics,  AskedBy = questionFrom,DateAnswered=answerDate, DateAsked = askedDate, QuestionText=Question_Text, AnswerText=Answer_Text
  {{#ifeq: {{{1|}}} | Topic | {{#arraymap: {{{2|}}}|,|xx| Topics HOLDS 'xx' |\s or \s}}|
{{#ifeq: {{{1|}}} | Question | {{#arraymap: {{{2|}}}|,|xx| _pageName = 'xx' |\s or \s}}
  |
{{#ifeq: {{{1|}}} | Keyword | {{#arraymap: {{{2|}}}|,|xx| QuestionText like '%xx%' or AnswerText like '%xx%' |\s or \s}}
}} }}
  }}
}}
|group by= Questions._pageName, Questions.QuestionFaqPage,Questions.Link, Questions.Topics__full,  Questions.AskedBy,Questions.DateAnswered, Questions.DateAsked, Questions.QuestionText, Questions.AnswerText
|format=template
|format=template
|template=QuestionQueryTableTemplate
|template=QuestionQueryTableTemplate
|delimiter=\n}}
|delimiter=\n
|}
|intro={{{!}} class="wikitable mw-collapsible {{#if: {{{Collapsible|}}}| mw-collapsed}}"
}}
! Information
| {{#ifeq: {{{1|}}} | Question | question
! Question
      {{#cargo_query:tables=Questions|fields= CONCAT('{{Question Information {{!}} questionPage = ',_pageName,'{{!}}faqPage=',trim(QuestionFaqPage),' {{!}}questionLink = ',Link,'{{!}}questionTopics=', Topics__full,'{{!}}questionFrom=', AskedBy,'{{!}}answerDate=',DateAnswered, '{{!}}askedDate=',  DateAsked,'}}')=Question_Information, QuestionText=Question_Text, AnswerText=Answer_Text
! Answer
|where= {{#arraymap: {{{2|}}}|,|x| _pageName = 'x' | new_delimiter= OR }}
| outro={{!}}}
|group_by=QuestionFaqPage,Link,Topics__full,AskedBy,QuestionText,AnswerText
| offset={{{offset|}}}
| default= ''No results''
| order by=Questions.DateAnswered desc
}}
}}
|supply FAQ Page, Topic or Question as first parameter }}}}}}</div></includeonly><noinclude>{{/doc}}</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>

Latest revision as of 04:26, 18 January 2026

No description.

Template parameters[Edit template data]

ParameterDescriptionTypeStatus
Query type1

no description

Suggested values
FAQ Page Topic Question
Unknownrequired
Value2

Limiting value for the query

Suggested values
Shifting Log - April 2025/FAQ Page
Unknownoptional