Show last authors
1 1 FAQ
2
3 #error("We're currently migrating to a new FAQ application and we're moving FAQ entries one by one to the new application. Make sure to check the [new FAQ Application>FAQ.WebHomeNew].")
4
5 In order to find the information you're looking for, you can use the search feature of your browser to search for FAQ entries displayed on this page or use the search box below.
6
7 ## ---------------------------------------------------
8 ## Let the user search for FAQs
9 ## ---------------------------------------------------
10
11 <form action="$xwiki.getURL("FAQ.FAQSearch")">
12 <table>
13 <tr>
14 <td>
15 <input type="text" name="text" value="$!request.text" size="30"/>
16 </td>
17 <td>
18 <input type="submit" value="Search FAQs"/>
19 </td>
20 </tr>
21 </table>
22 </form>
23
24 ## Compute number of FAQ entries
25 #set ($whereClauseAnsweredFaqs = "obj.name=doc.fullName and obj.name<>'XWiki.FAQClassTemplate' and obj.className='XWiki.FAQClass' and prop.id.id = obj.id and prop.id.name='answer' and prop.value <> '' order by doc.creationDate desc")
26 #set ($nbAnsweredFaqs = "select count(distinct doc) from XWikiDocument doc, BaseObject as obj, LargeStringProperty as prop where $whereClauseAnsweredFaqs")
27 #set ($whereClauseNotAnsweredFaqs = "obj.name=doc.fullName and obj.name<>'XWiki.FAQClassTemplate' and obj.className='XWiki.FAQClass' and prop.id.id = obj.id and prop.id.name='answer' and prop.value='' order by doc.creationDate desc")
28 #set ($nbNotAnsweredFaqs = "select count(distinct doc) from XWikiDocument doc, BaseObject as obj, LargeStringProperty as prop where $whereClauseNotAnsweredFaqs")
29
30 <table>
31 <tr>
32 <th align="center">$xwiki.search($nbAnsweredFaqs).get(0) Answered FAQs (latest first)</th>
33 <th align="center">$xwiki.search($nbNotAnsweredFaqs).get(0) Unanswered FAQs (latest first)</th>
34 </tr>
35 <tr>
36 <td style="border-right:1px dashed #CCC;border-bottom:1px dashed #CCC">
37 ## ---------------------------------------------------
38 ## Find the FAQ entries that have answers
39 ## ---------------------------------------------------
40 #set ($sql = ", BaseObject as obj, LargeStringProperty as prop where $whereClauseAnsweredFaqs")
41 #foreach ($item in $xwiki.searchDocuments($sql))
42 #set($bentrydoc = $xwiki.getDocument($item))
43 #set($bentryobj = $bentrydoc.getObject("XWiki.FAQClass", "language", $language, true))
44 #if ($bentryobj.getProperty("question").getValue().trim().length() == 0)
45 * [(Empty question)|$item]
46 #else
47 * [${bentrydoc.display("question","view", $bentryobj)}|$item]
48 #end
49 #end
50 </td>
51 <td style="vertical-align:top;">
52
53 ## ----------------------------------------------------
54 ## Find the FAQ entries that have no answers yet
55 ## ----------------------------------------------------
56 #set ($sql = ", BaseObject as obj, LargeStringProperty as prop where $whereClauseNotAnsweredFaqs")
57 #foreach ($item in $xwiki.searchDocuments($sql))
58 #set($bentrydoc = $xwiki.getDocument($item))
59 #set($bentryobj = $bentrydoc.getObject("XWiki.FAQClass", "language", $language, true))
60 #if ($bentryobj.getProperty("question").getValue().trim().length() == 0)
61 * [(Empty question)|$item]
62 #else
63 * [${bentrydoc.display("question","view", $bentryobj)}|$item]
64 #end
65 #end
66
67 </td>
68 </tr>
69 </table>
70
71 $context.setCacheDuration(10000)

Get Connected