Cornelia de lange syndrome

org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [#template('tiles.vm')

#set($w-servicesArray = [])

#getWaihonaPediaServicesPublic($w-servicesArray)

#set($discard = $xwiki.ssx.use('WaihonaCode.healthTopicsSheet'))

#set($discard = $services.localization.use('document', 'WaihonaCode.ATEPublic.ATEPublicTranslations') )

#set ($discard = $services.localization.use('document', 'WaihonaCode.themeRoomTranslations') )

##set($discard = $services.localization.use('document', 'WaihonaCode.publicInfo.infoTranslations') )

#set($healthTopicClassName = 'WaihonaCode.healthTopicsClass')

#if( $services.wiki.getAll() > 1)

  #set($thisServerIsFarm = true)

  #foreach ($wiki in $services.wiki.getAll())

    #set ($discard = $selectedWikis.add($wiki))

    ## Note

  #end

  #set($wikiName = '')

#else

  #set($thisServerIsFarm = false)

  #foreach ($wiki in $services.wiki.getAll() )

    #set($wikiName = $wiki.id)

  #end

#end

#if($doc.getObject($healthTopicClassName))

  #set ($discard = $doc.use($healthTopicClassName))

  #set ($discard = $services.localization.use('document', 'WaihonaCode.healthTopicsTranslations'))

  #set ($diseaseClassName = 'WaihonaCode.diseaseClass')

  #set ($diseaseTagClassName = 'WaihonaCode.ATEPublic.diseaseTagClass')

  #set ($parentKey = $doc.getObject($healthTopicClassName).getProperty('parent').getValue() )

  #set ($parentTopicQuery = "from doc.object(WaihonaCode.healthTopicsClass) as topic where topic.key = :thisParentKey " )

  #set ($subTopicQuery = "from doc.object(WaihonaCode.healthTopicsClass) as topic where topic.parent = :thistopic and topic.parent <> '' order by topic.orderInTopic" )

  #set($diseaseTopicKey = '#')

  #if($parentKey && $parentKey != '' )

    #getDiseaseKey($parentKey,$diseaseTopicKey)

    #showButtonParent($parentKey)

  #else ## We are on a topic that has no parent, thus it should have a diseaseTag

    #set($diseaseKey = $doc.getObject($diseaseTagClassName).getProperty('diseaseKey').getValue() )

    #set($diseaseTopicKey = $doc.getObject($healthTopicClassName).getProperty('key').getValue() )

  #end

  #showButtonTopicTree($diseaseTopicKey)

  #set($diseaseSpaceArray =[])

  #getDiseaseSpaceDocRefs($diseaseKey $diseaseSpaceArray)



  {{html clean=false wiki="true"}}

  #if(!$request.showDetails)

    #showTopicFormShort()

    #showButtonTopicDetails()

  #else

    #showTopicFormDetails()

    #showButtonTopicShort()

  #end

  {{/html}}



{{pageNavigation/}}



#else

{{warning}}

This page does not have a object of $healthTopicClassName !. This probably means you are looking at the sheet that display's pages of $healthTopicClassName)



This sheet will show a WaihonaPedia Topic

* It will do this by showing a link-button to the **Parent-topic** of the topic you are viewing

* Below it will show the description of the topic

** It will also list the relevant properties of the topic (Dimensions, Order with Parent, ...)

** Below these properties it will show a list of sub-topics (if registered for this topic already)

** Above this list it will offer a button to add new sub-topic

** Each row in the list will have a EDIT and DELETE option

{{/warning}}

#end

#macro(showButtonTopicTree $diseaseTopicKey)

  #set($topicTreeLabel = $services.localization.render('waihonapedia.topics.tree'))

  #set($topicTagClassName = 'WaihonaCode.pageTopicTagClass')

  #set($topicTreeDocRefQuery = "from doc.object($topicTagClassName) as ttag where ttag.topicType = '1' and ttag.topicKey = :diseaseTopicKey and doc.fullName not in (select distinct obj2.name from BaseObject as obj2 where obj2.className = 'WaihonaCode.diseaseClass')")

  #set($topicTreeDocRefList = $services.query.xwql($topicTreeDocRefQuery).bindValue("diseaseTopicKey", $diseaseTopicKey ).addFilter("unique").execute() )

  #foreach($topicTreeDocRef in $topicTreeDocRefList)

    ##* [[$topicTreeDocRef]]

    {{showBreadCrumbNavigation parentPageRef="$topicTreeDocRef" linkPageRef="$topicTreeDocRef" linkQueryParams="showCompleteTree=1" linkIcon='th-list' showGenericLabel='true' alternativeLabel="$topicTreeLabel" /}}

  #end

#end

#macro(getDiseaseSpaceDocRefs $diseaseKey $diseaseSpaceArray)

  #set( $diseaseQueryDef = "from doc.object($diseaseClassName) as dis where dis.key = :key")

  #set($diseaseDocRefList =  $services.query.xwql($diseaseQueryDef).bindValue("key", $diseaseKey ).addFilter("unique").execute())

  #foreach($diseaseDocRef in $diseaseDocRefList)

    #set($diseaseDoc = $xwiki.getDocument($diseaseDocRef))

    ## Get Information Articles space

    #if($diseaseDoc.getObject($diseaseClassName).getProperty('publicationspace').getValue() &&

        $diseaseDoc.getObject($diseaseClassName).getProperty('publicationspace').getValue() != '' )

      #set($publicationSpace = $xwiki.getDocument($diseaseDoc.getObject($diseaseClassName).getProperty('publicationspace').getValue()).getSpace() )

    #else

      #set($publicationSpace = "${diseaseDoc.getSpace()}.library" )

    #end

    ## Evaluate where we want to store new theme rooms and publications based on disease preferences $webName

    #if($diseaseDoc.getObject($diseaseClassName).getProperty('workshopspace').getValue())

      #set($thisThemeroomDoc = $xwiki.getDocument($diseaseDoc.getObject($diseaseClassName).getProperty('workshopspace').getValue()) )

      #set($themeRoomSpace =  $thisThemeroomDoc.getSpace())

    #else

      #set($themeRoomSpace = "WaihonaPediaThemes.${diseaseDoc.getObject($diseaseClassName).getProperty('abbreviation').getValue()}")

    #end

  #end

  #set($spaceList = $stringtool.split($publicationSpace, '.'))

  #set($publicationSpaceArray = [])

  #foreach($spaceString in $spaceList)

    #set($discard = $publicationSpaceArray.add($spaceString))

  #end

  #set($diseaseSpaceObject = {})

  #set($discard = $diseaseSpaceObject.put('service-name', 'information'))

  #set($discard = $diseaseSpaceObject.put('publicationSpaceArray', $publicationSpaceArray))

  #set($discard = $diseaseSpaceArray.add($diseaseSpaceObject))

  #set($diseaseSpaceObject = {})

  #set($discard = $diseaseSpaceObject.put('service-name', 'stories')) ##public stories can be put iin same space

  #set($discard = $diseaseSpaceObject.put('publicationSpaceArray', $publicationSpaceArray))

  #set($discard = $diseaseSpaceArray.add($diseaseSpaceObject))

  ##Themerooms

  #set($spaceList = $stringtool.split($themeRoomSpace, '.'))

  #set($themeRoomSpaceArray = [])

  #foreach($spaceString in $spaceList)

    #set($discard = $themeRoomSpaceArray.add($spaceString))

  #end

  #set($diseaseSpaceObject = {})

  #set($discard = $diseaseSpaceObject.put('service-name', 'workshop'))

  #set($discard = $diseaseSpaceObject.put('publicationSpaceArray', $themeRoomSpaceArray))

  #set($discard = $diseaseSpaceArray.add($diseaseSpaceObject))

#end

#macro(getDiseaseKey $parentKey,$diseaseKey,$diseaseTopicKey)

  #set($topicDocRefList = $services.query.xwql($parentTopicQuery).bindValue('thisParentKey', $parentKey).addFilter('unique').execute() )

  #foreach($topicDocRef in $topicDocRefList) ## one level up parent

    #set ($thisParentKey = $xwiki.getDocument($topicDocRef).getObject($healthTopicClassName).getProperty('parent').getValue() )

    #if($thisParentKey && $thisParentKey != '' )

      #getDiseaseKey($thisParentKey, $diseaseKey)

    #else ## we have the topic without a parent

      #set($diseaseKey = $xwiki.getDocument($topicDocRef).getObject($diseaseTagClassName).getProperty('diseaseKey').getValue() )

      #set($diseaseTopicKey = $xwiki.getDocument($topicDocRef).getObject($healthTopicClassName).getProperty('key').getValue() )

    #end

  #end

#end

#macro(showButtonParent $topicKey)

  #set($topicDocRefList = $services.query.xwql($parentTopicQuery).bindValue('thisParentKey', $topicKey).addFilter('unique').execute() )

  #foreach($topicDocRef in $topicDocRefList)

    #set($parentDoc = $xwiki.getDocument($topicDocRef) )

    #set($btnLabel = $services.localization.render('WaihonaCode.healthDimensionClass.back',[$parentDoc.getTranslatedDocument().getPlainTitle()] ))

    {{showBreadCrumbNavigation parentPageRef="$topicDocRef" showGenericLabel='false' alternativeLabel="$btnLabel" linkIcon='arrow-up' /}}

  #end

#end

#macro(showTopicFormShort)

(% class="xform" %)

(((

  #if($context.action == 'edit')

  ; <label for="WaihonaCode.healthTopicsClass_0_topictitle">$escapetool.xml($doc.displayPrettyName('topictitle', false, false))</label>

  : $doc.display('topictitle')

  #end

  ; <label for="WaihonaCode.healthTopicsClass_0_description">$escapetool.xml($doc.displayPrettyName('description', false, false))</label>

  : $doc.display('description')

  #if($context.action == 'view')

    #set($plainTitle = "'" + $doc.getTranslatedDocument().getPlainTitle() + "'")

    #set($thisTopicKey = $doc.getObject($healthTopicClassName).getProperty('key').getValue() )

    #showTable('subTopic',$thisTopicKey)

    #showTable('recommendations',$thisTopicKey)

    #showTable('commons',$thisTopicKey)

    #showTable('information',$thisTopicKey,$diseaseKey,$diseaseSpaceArray)

    #showTable('answers',$thisTopicKey,$diseaseKey,$diseaseSpaceArray)

    #showTable('stories',$thisTopicKey,$diseaseKey,$diseaseSpaceArray)

    #showTable('workshop',$thisTopicKey,$diseaseKey,$diseaseSpaceArray)

    ##showSubTopicsTree($thisTopicKey)

  #end

)))

#end

#macro(showTopicFormDetails)

(% class="xform" %)

(((

  #if($context.action == 'edit')

  ; <label for="WaihonaCode.healthTopicsClass_0_topictitle">$escapetool.xml($doc.displayPrettyName('topictitle', false, false))</label>

  : $doc.display('topictitle')

  #end

  ; <label for="WaihonaCode.healthTopicsClass_0_description">$escapetool.xml($doc.displayPrettyName('description', false, false))</label>

  : $doc.display('description')

  ; <label for="WaihonaCode.healthTopicsClass_0_recommendation">$escapetool.xml($doc.displayPrettyName('recommendation', false, false))</label>

  : $doc.display('recommendation')

  ; <label for="WaihonaCode.healthTopicsClass_0_dimension">$escapetool.xml($doc.displayPrettyName('dimension', false, false))</label>

  : $doc.display('dimension')

  ; <label for="WaihonaCode.healthTopicsClass_0_commons">$escapetool.xml($doc.displayPrettyName('commons', false, false))</label>

  : $doc.display('commons')

  ; <label for="WaihonaCode.healthTopicsClass_0_bodydimension">$escapetool.xml($doc.displayPrettyName('bodyDimension', false, false))</label>

  : $doc.display('bodyDimension')

  ; <label for="WaihonaCode.healthTopicsClass_0_guidelineDimension">$escapetool.xml($doc.displayPrettyName('guidelineDimension', false, false))</label>

  : $doc.display('guidelineDimension')

  ; <label for="WaihonaCode.healthTopicsClass_0_parent">$escapetool.xml($doc.displayPrettyName('parent', false, false))</label>

  : $doc.display('parent')

  ; <label for="WaihonaCode.healthTopicsClass_0_orderInTopic">$escapetool.xml($doc.displayPrettyName('orderInTopic', false, false))</label>

  : $doc.display('orderInTopic')

  ; <label for="WaihonaCode.healthTopicsClass_0_key">$escapetool.xml($doc.displayPrettyName('key', false, false))</label>

  : $doc.display('key')

  ; <label for="WaihonaCode.healthTopicsClass_0_reference">$escapetool.xml($doc.displayPrettyName('reference', false, false))</label>

  : $doc.display('reference')

)))

#end

#macro(showButtonTopicDetails)

  #set($thatLabel=$services.localization.render('waihonapedia.topics.show.details') )

  ##[[Show all detail properties of the topic>>||queryString="showDetails=true"]]

  {{showBreadCrumbNavigation parentPageRef="$doc" linkPageRef="$doc" linkQueryParams="showDetails=true" linkIcon='plus-square' showGenericLabel='true' alternativeLabel="$thatLabel" /}}

#end

#macro(showButtonTopicShort)

  #set($thatLabel=$services.localization.render('waihonapedia.topics.hide.details') )

  {{showBreadCrumbNavigation parentPageRef="$doc" linkIcon='minus-square' showGenericLabel='true' alternativeLabel="$thatLabel" /}}

#end

#macro(showTable,$type,$thisKey, $diseaseKey, $diseaseSpaceArray)

  #if($type == 'subTopic')

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', 'subTopic') )

    #set($discard = $thisTableObject.put('header', $services.localization.render('WaihonaCode.healthTopicsClass.show.subTopics',["$plainTitle"]) ))

    #getSubTopicsTable($thisKey, $thisTableObject)

  #elseif($type == 'recommendations')

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', 'recommendations') )

    #set($discard = $thisTableObject.put('header', $services.localization.render('info.public.topic.has.recommendations') ))

    #getRecommendationsTable($thisKey, $thisTableObject)

  #elseif($type == 'commons')

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', 'commons') )

    #set($discard = $thisTableObject.put('header', $services.localization.render('info.public.topic.has.commons') ))

    #getCommonsTable($thisKey, $thisTableObject)

  #elseif($type == 'information')

    #foreach($serviceObject in $w-servicesArray)

      #if($serviceObject.name == $type)

        #set($listGroupCounter = 0)

        #set($pagesFoundList = [])

        #set($thisServiceObject = $serviceObject)

        #countServiceEntityWithTopic($thisKey, $serviceObject, $listGroupCounter, $pagesFoundList)

      #end

    #end

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', $thisServiceObject.id) )

    #set($discard = $thisTableObject.put('header', $services.localization.render($thisServiceObject.label-key) ))

    #getTable($thisKey,$diseaseKey,$diseaseSpaceArray,$thisServiceObject,$pagesFoundList,$thisTableObject)

  #elseif($type == 'stories')

    #foreach($serviceObject in $w-servicesArray)

      #if($serviceObject.name == $type)

        #set($listGroupCounter = 0)

        #set($pagesFoundList = [])

        #set($thisServiceObject = $serviceObject)

        #countServiceEntityWithTopic($thisKey, $serviceObject, $listGroupCounter, $pagesFoundList)

      #end

    #end

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', $thisServiceObject.id) )

    #set($discard = $thisTableObject.put('header', $services.localization.render($thisServiceObject.label-key) ))

    #getTable($thisKey,$diseaseKey,$diseaseSpaceArray,$thisServiceObject,$pagesFoundList,$thisTableObject)

  #elseif($type == 'answers')

    #foreach($serviceObject in $w-servicesArray)

      #if($serviceObject.name == $type)

        #set($listGroupCounter = 0)

        #set($pagesFoundList = [])

        #set($thisServiceObject = $serviceObject)

        #countServiceEntityWithTopic($thisKey, $serviceObject, $listGroupCounter, $pagesFoundList)

      #end

    #end

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', $thisServiceObject.id) )

    #set($discard = $thisTableObject.put('header', $services.localization.render($thisServiceObject.label-key) ))

    #getTable($thisKey,$diseaseKey,$diseaseSpaceArray,$thisServiceObject,$pagesFoundList,$thisTableObject)

  #elseif($type == 'workshop')

    #foreach($serviceObject in $w-servicesArray)

      #if($serviceObject.name == $type)

        #set($listGroupCounter = 0)

        #set($pagesFoundList = [])

        #set($thisServiceObject = $serviceObject)

        #countServiceEntityWithTopic($thisKey, $serviceObject, $listGroupCounter, $pagesFoundList)

      #end

    #end

    #set($thisTableObject = {})

    #set($discard = $thisTableObject.put('id', $thisServiceObject.id) )

    #set($discard = $thisTableObject.put('header', $services.localization.render($thisServiceObject.label-key) ))

    #getTable($thisKey,$diseaseKey,$diseaseSpaceArray,$thisServiceObject,$pagesFoundList,$thisTableObject)

  #end

  #displayTable($thisTableObject)

#end

#macro(displayTable $thisTableObject)

  ##if($thisTableObject.linesArray.size() > 0)

  <div class='topic-table'>

    <div class='table-header'>

      ##<p>$thisTableObject</p>

      <div class='table-header-text'><a id="${thisTableObject.id}"><h2>$thisTableObject.header</h2></a></div>

      ##<p>$thisTableObject.id == 't5' && $thisTableObject.linesArray.size() > 0</p>

      #if($thisTableObject.id == 't5' && $thisTableObject.linesArray.size() > 0 ) ##Themerooms can have only 1 line, if 1 line then we should not add a button to create a new one

        <div class='table-add-button'> </div>

      #else

        <div class='table-add-button'>

          <a href="${thisTableObject.buttonObject.url}" class='btn btn-default'>$thisTableObject.buttonObject.label <span class="fa fa-plus"></span></a>

        </div>

      #end

    </div>

    <table  class="table table-striped" style="width:100%">

      <thead>

        <tr>

          #foreach($headerColumn in $thisTableObject.headerArray)

            <th class="${headerColumn}">$services.localization.render("healthtopics.livetable.$headerColumn")</th>

          #end

          <th class="forDeleteButton">$services.localization.render("healthdimension.livetable._actions.delete")</th>

        </tr>

      </thead>

      <tbody>

      #set($headerArray = $thisTableObject.headerArray)

      #foreach($lineArray in $thisTableObject.linesArray)

        <tr>

          #if($thisTableObject.headerArray.size() == 1)

            <td class="${headerArray[0]}">[[$lineArray[0]>>$lineArray[1]]]</td>

            <td class='forDeleteButton'><a href="$lineArray[2]" title="$services.localization.render('WaihonaCode.healthTopicsClass.delete')"><span  class ="fa fa-trash"></span></a></td>

          #else

            <td class="${headerArray[0]}">$lineArray[0]</td>

            <td class="${headerArray[1]}">[[$lineArray[1]>>$lineArray[2]]]</td>

            <td class='forDeleteButton'><a href="$lineArray[3]" title="$services.localization.render('WaihonaCode.healthTopicsClass.delete')"><span  class ="fa fa-trash"></span></a></td>

          #end

        </tr>

      #end

      </tbody>

    </table>

  </div>

  ##end

#end

#macro(getTable $thisKey,$diseaseKey,$diseaseSpaceArray,$serviceObject,$pagesFoundList,$thisTableObject)

  #showAddButton($thisKey,$diseaseKey,$diseaseSpaceArray,$pagesFoundList, $thisTableObject, $serviceObject.name)

  #set($headerArray =[])

  #if($serviceObject.id != 't5')

    #set($discard = $headerArray.add('index')) ##possible we could change this in creation date to show

  #end

  #set($discard = $headerArray.add('title'))

  #set($discard = $thisTableObject.put('headerArray', $headerArray))

  #set($linesArray = [])

  ##Lines in Table = $pagesFoundList.size()

  ##if($serviceObject.id != 't3')

  #foreach($pageFoundDocRef in $pagesFoundList)

    #set($pageFoundDoc = $xwiki.getDocument($pageFoundDocRef) )

    #set($lineArray = [])

    #if($serviceObject.id != 't5')

      #set($discard = $lineArray.add($velocityCount) ) ##possible we could change this in creation date to show

    #end

    #set($discard = $lineArray.add($pageFoundDoc.getTranslatedDocument().getTitle() ) )

    #set($discard = $lineArray.add($pageFoundDocRef) )

    #set($discard = $lineArray.add($pageFoundDoc.getURL('delete') ))

    #set($discard = $linesArray.add($lineArray))

  #end

#*

  #else

    found: $pagesFoundList

  #end

*#

  #set($discard = $thisTableObject.put('linesArray', $linesArray ) )

#end

#macro(getSubTopicsTable $thisKey, $thisTableObject)

  #showAddButton($thisKey,'',[],[], $thisTableObject, 'subTopic')

  #set($subTopicDocRefList = $services.query.xwql($subTopicQuery).bindValue('thistopic', $thisKey).addFilter('unique').execute() )

  #set($headerArray =[])

  #set($discard = $headerArray.add('orderInTopic'))

  #set($discard = $headerArray.add('title'))

  #set($discard = $thisTableObject.put('headerArray', $headerArray))

  #set($linesArray = [])

  #foreach($subTopicDocRef in $subTopicDocRefList)

    #set($thisSubTopicDoc = $xwiki.getDocument($subTopicDocRef) )

    #set($lineArray = [])

    #if($thisSubTopicDoc.getObject($healthTopicClassName).getProperty('recommendation').getValue() != 1 &&

        $thisSubTopicDoc.getObject($healthTopicClassName).getProperty('commons').getValue() != 1 )

      ##set($thisSubTopicKey = $thisSubTopicDoc.getObject($healthTopicClassName).getProperty('key').getValue() )

      #set($discard = $lineArray.add($thisSubTopicDoc.getObject($healthTopicClassName).getProperty('orderInTopic').getValue() ))

      #set($discard = $lineArray.add($thisSubTopicDoc.getTranslatedDocument().getTitle() ) )

      #set($discard = $lineArray.add($subTopicDocRef) )

      #set($discard = $lineArray.add($thisSubTopicDoc.getURL('delete') ))

      #set($discard = $linesArray.add($lineArray))

    #end

  #end

  #set($discard = $thisTableObject.put('linesArray', $linesArray ) )

#end

#macro(getRecommendationsTable $thisKey, $thisTableObject)

  #showAddButton($thisKey,'',[],[], $thisTableObject, 'recommendation')

  #set($subTopicDocRefList = $services.query.xwql($subTopicQuery).bindValue('thistopic', $thisKey).addFilter('unique').execute() )

  #set($headerArray =[])

  #set($discard = $headerArray.add('orderInTopic'))

  #set($discard = $headerArray.add('title'))

  #set($discard = $thisTableObject.put('headerArray', $headerArray))

  #set($linesArray = [])

  #foreach($subTopicDocRef in $subTopicDocRefList)

    #set($thisSubTopicDoc = $xwiki.getDocument($subTopicDocRef) )

    #set($lineArray = [])

    #if($thisSubTopicDoc.getObject($healthTopicClassName).getProperty('recommendation').getValue() == 1 )

      ##set($thisSubTopicKey = $thisSubTopicDoc.getObject($healthTopicClassName).getProperty('key').getValue() )

      #set($discard = $lineArray.add($thisSubTopicDoc.getObject($healthTopicClassName).getProperty('orderInTopic').getValue() ))

      #set($discard = $lineArray.add($thisSubTopicDoc.getTranslatedDocument().getTitle() ) )

      #set($discard = $lineArray.add($subTopicDocRef) )

      #set($discard = $lineArray.add($thisSubTopicDoc.getURL('delete') ))

      #set($discard = $linesArray.add($lineArray))

    #end

  #end

  #set($discard = $thisTableObject.put('linesArray', $linesArray ) )

#end

#macro(getCommonsTable $thisKey, $thisTableObject)

  #showAddButton($thisKey,'',[],[], $thisTableObject, 'commons')

  #set($subTopicDocRefList = $services.query.xwql($subTopicQuery).bindValue('thistopic', $thisKey).addFilter('unique').execute() )

  #set($headerArray =[])

  #set($discard = $headerArray.add('orderInTopic'))

  #set($discard = $headerArray.add('title'))

  #set($discard = $thisTableObject.put('headerArray', $headerArray))

  #set($linesArray = [])

  #foreach($subTopicDocRef in $subTopicDocRefList)

    #set($thisSubTopicDoc = $xwiki.getDocument($subTopicDocRef) )

    #set($lineArray = [])

    #if($thisSubTopicDoc.getObject($healthTopicClassName).getProperty('commons').getValue() == 1 )

      ##set($thisSubTopicKey = $thisSubTopicDoc.getObject($healthTopicClassName).getProperty('key').getValue() )

      #set($discard = $lineArray.add($thisSubTopicDoc.getObject($healthTopicClassName).getProperty('orderInTopic').getValue() ))

      #set($discard = $lineArray.add($thisSubTopicDoc.getTranslatedDocument().getTitle() ) )

      #set($discard = $lineArray.add($subTopicDocRef) )

      #set($discard = $lineArray.add($thisSubTopicDoc.getURL('delete') ))

      #set($discard = $linesArray.add($lineArray))

    #end

  #end

  #set($discard = $thisTableObject.put('linesArray', $linesArray ) )

#end

#macro(showAddButton $thisTopicKey,$diseaseKey,$diseaseSpaceArray,$pagesFoundList, $thisTableObject,$topicType)

  #set($buttonServiceObject = {})

  #foreach($thisServiceObject in $w-servicesArray)

    #if($thisServiceObject.name == $topicType)

      #set($buttonServiceObject = $thisServiceObject)

    #end

  #end

  #if($buttonServiceObject.name)

    #if($buttonServiceObject.name == 'answers') ##ATEPublic has a shared database acros diseases

      ## the following lines are copied form ATEPublic database page

      #set($ATEPublicCodePrefix = 'WaihonaCode.ATEPublic.ATEPublic')

      #set($ATEPublicClassName = "${ATEPublicCodePrefix}Class")

      #set($ATEPublicTemplateName = "${ATEPublicCodePrefix}Template")

      #set($diseaseQueryDef = "from doc.object($diseaseClassName) as dis where doc.fullName <> 'WaihonaCode.diseaseTemplate' order by dis.abbreviation")

      #set($ATELatestQueryDef = "from doc.object($ATEPublicClassName) as ate where doc.fullName <> '$ATEPublicTemplateName' and ate.questionID like 'ATE%' order by ate.questionID desc")

      #set($latestCreatedQuestionList = $services.query.xwql($ATELatestQueryDef).setLimit(1).execute() )

      #if($latestCreatedQuestionList.size() == 0)

        #set($newSeqString = $stringtool.leftPad(1, 6, '0') )

      #else

        #set($latestCreatedQuestionID = $xwiki.getDocument($latestCreatedQuestionList[0]).getObject($ATEPublicClassName).getProperty('questionID').getValue() )

        #set($latestSequenceString = $stringtool.stripStart($latestCreatedQuestionID,'ATE') )

        #set($latestSequenceNum = $numbertool.toNumber($latestSequenceString))

        #set($newSeqNum = $latestSequenceNum + 1)

        #set($newSeqString = $stringtool.leftPad($newSeqNum, 6, '0') )

      #end

      #set($newPageName = "ATE${newSeqString}")

      #set($queryString = "template=WaihonaCode.ATEPublic.ATEPublicTemplate&tmpDiseaseKey=${diseaseKey}&tmpTopicKey=${thisTopicKey}")

      #set($toBeCreatedPublicationReference = $services.model.createDocumentReference("$wikiName",['ATEPublic'],$newPageName))

      #set($newPublicationURL =  $xwiki.getURL($toBeCreatedPublicationReference,'edit', $queryString))

      ##$newPageName $newPublicationURL

      #set($buttonObject = {} )

      #set($discard = $buttonObject.put('url', $newPublicationURL ))

      #set($discard = $buttonObject.put('label', $services.localization.render('WaihonaCode.diseaseClass.community.answers')) )

      #set($discard = $thisTableObject.put('buttonObject', $buttonObject ))

    #else ##Disease will have 'locations' for articles, stories and/or themerooms

      ## in each topictree the top-topic page has an object specifying the disease it belongs to

      #foreach($spaceObject in $diseaseSpaceArray)

        #if($spaceObject.service-name == $buttonServiceObject.name)

          #set($discard = $buttonServiceObject.put('pageSpaceArray', $spaceObject.publicationSpaceArray))

        #end

      #end

      #set($numberOfSiblings = $pagesFoundList.size() )

      #set($newPageNumber = $numberOfSiblings + 1 )

      #set($newPageSuffix = $numbertool.format('000', $newPageNumber))

      #set($newPageName = "${thisTopicKey}${buttonServiceObject.id}${newPageSuffix}" )

      #set($toBeCreatedPublicationReference = $services.model.createDocumentReference("$wikiName",$buttonServiceObject.pageSpaceArray,$newPageName))

      #if($xwiki.exists($toBeCreatedPublicationReference) )## Check if not exist

        #foreach($counter in [1..99]) ## We will try 99 times

          #set($newPageNumber = $newPageNumber + $counter)

          #set($newPageSuffix = $numbertool.format('000', $newPageNumber))

          #set($newPageName = "${thisTopicKey}${buttonServiceObject.id}${newPageSuffix}" )

          #set($toBeCreatedPublicationReference = $services.model.createDocumentReference("$wikiName",$buttonServiceObject.pageSpaceArray,$newPageName))

          #if($xwiki.exists($toBeCreatedPublicationReference) ) ## Check if not exist

            #break ##the loop

          #end

        #end

      #end

      #if($buttonServiceObject.name == 'information')

        #set($queryString = 'template=Templates.waiPublication&sheet=WaihonaCode.publicationSheet&topickey=' + $thisTopicKey)

      #elseif($buttonServiceObject.name == 'stories')

        ## we have templates for diffent languages

        #set($baseTemplateSpace = 'waihonaBase.storyTemplates')

        #set($languageTemplate = $baseTemplateSpace + "." + $context.language + ".topic")

        #set($queryString = "template=${languageTemplate}&sheet=WaihonaCode.publicationSheet&topickey=${thisTopicKey}")

      #elseif($buttonServiceObject.name == 'workshop')

        #set($templateDocRef = 'WaihonaCode.themeRoomTemplate')

        #set($queryString = "template=${templateDocRef}&topickey=${thisTopicKey}")

      #else

        #set($queryString = 'topickey=' + $thisTopicKey)

      #end

      #set($newPublicationURL =  $xwiki.getURL($toBeCreatedPublicationReference,'edit', $queryString))

      #set($buttonObject = {} )

      #set($discard = $buttonObject.put('url', $newPublicationURL ))

      #if($buttonServiceObject.name == 'workshop' )

        #set($discard = $buttonObject.put('label', $services.localization.render('waihonapedia.healthtopics.create.themeroom')) )

      #elseif($buttonServiceObject.name == 'information' )

        #set($discard = $buttonObject.put('label', $services.localization.render('WaihonaCode.diseaseClass.community.information')) )

      #elseif($buttonServiceObject.name == 'answers' )

        #set($discard = $buttonObject.put('label', $services.localization.render('WaihonaCode.diseaseClass.community.answers')) )

      #elseif($buttonServiceObject.name == 'stories' )

        #set($discard = $buttonObject.put('label', $services.localization.render('waihonapedia.story.title')) )

      #else

        #set($discard = $buttonObject.put('label', $services.localization.render('solr.field.wai.doccontent')) )

      #end

      #set($discard = $thisTableObject.put('buttonObject', $buttonObject ))

    #end

  #else

    #set($siblingDocRefQueryDef = "from doc.object($healthTopicClassName) as topic where topic.parent = :thisParentKey and topic.parent <> '' order by topic.orderInTopic" )

    #set($siblingDocRefList = $services.query.xwql($siblingDocRefQueryDef).bindValue('thisParentKey', $thisTopicKey).addFilter('unique').execute() )

    #set($numberOfSiblings = $siblingDocRefList.size() )

    #set($newSubTopicNumber = $numberOfSiblings + 1 )

    #set($newSubTopicOrder = $newSubTopicNumber * 10 )

    #set($newSubTopicSuffix = $numbertool.format('000', $newSubTopicNumber))

    #set($newTopicDocName = "${thisTopicKey}${newSubTopicSuffix}" )

#set($queryString="topickey=${newTopicDocName}&propParent=${thisTopicKey}&orderInTopic=$newSubTopicOrder&template=WaihonaCode.healthTopicsTemplate&sheet=WaihonaCode.healthTopicSubTopSheet#if($topicType)&topicType=${topicType}#end")

    #set($newSubTopicDocRef = $services.model.createDocumentReference("$wikiName",["${doc.space}"],$newTopicDocName))

    #set($newSubTopicDoc = $xwiki.getDocument($newSubTopicDocRef) )

    #set($newSubTopicDocURL = $newSubTopicDoc.getURL('edit', $queryString) )

    #set($buttonObject = {} )

    #set($discard = $buttonObject.put('url', $newSubTopicDocURL ))

    #set($discard = $buttonObject.put('label', $services.localization.render("WaihonaCode.healthTopicsClass.add.${topicType}",['']) ))

    #set($discard = $thisTableObject.put('buttonObject', $buttonObject ))

  #end

#end

#macro(showSubTopicsTree $thisKey)

  #set($subTopicDocRefList = $services.query.xwql($subTopicQuery).bindValue('thistopic', $thisKey).addFilter('unique').execute() )

  #set($headerArray =[])

  #set($discard = $headerArray.add('orderInTopic'))

  #set($discard = $headerArray.add('title'))



  {{tree icons=false}}

  {{html}}

  #foreach($subTopicDocRef in $subTopicDocRefList)

      #set($thisSubTopicDoc = $xwiki.getDocument($subTopicDocRef) )

      #set($thisSubTopicKey = $thisSubTopicDoc.getObject($healthTopicClassName).getProperty('key').getValue() )

      #set($thisSubTopicOrder = $thisSubTopicDoc.getObject($healthTopicClassName).getProperty('orderInTopic').getValue() )

      #set($deleteURL = $thisSubTopicDoc.getURL('delete') )

        <ul>

          <li>

            <div><a href="$xwiki.getURL($subTopicDocRef)">$thisSubTopicDoc.getTranslatedDocument().getTitle()</a>&emsp;<a href="$deleteURL" title="$services.localization.render('WaihonaCode.healthTopicsClass.delete')"><span  class ="fa fa-trash"></span></a></div>

          </li>

        </ul>

    #end

    {{/html}}

   {{/tree}}



#end]
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:135)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:51)
 at org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:279)
 at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:182)
 at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:58)
 at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:309)
 at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
 at org.xwiki.rendering.internal.transformation.DefaultTransformationManager.performTransformations(DefaultTransformationManager.java:88)
 at org.xwiki.display.internal.DocumentContentAsyncExecutor.executeInCurrentExecutionContext(DocumentContentAsyncExecutor.java:395)
 at org.xwiki.display.internal.DocumentContentAsyncExecutor.execute(DocumentContentAsyncExecutor.java:268)
 at org.xwiki.display.internal.DocumentContentAsyncRenderer.execute(DocumentContentAsyncRenderer.java:112)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:157)
 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:290)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:125)
 at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:67)
 at org.xwiki.display.internal.DocumentContentDisplayer.display(DocumentContentDisplayer.java:43)
 at org.xwiki.display.internal.DefaultDocumentDisplayer.display(DefaultDocumentDisplayer.java:96)
 at org.xwiki.display.internal.DefaultDocumentDisplayer.display(DefaultDocumentDisplayer.java:39)
 at org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:245)
 at org.xwiki.sheet.internal.SheetDocumentDisplayer.applySheet(SheetDocumentDisplayer.java:225)
 at org.xwiki.sheet.internal.SheetDocumentDisplayer.maybeDisplayWithSheet(SheetDocumentDisplayer.java:180)
 at org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:111)
 at org.xwiki.sheet.internal.SheetDocumentDisplayer.display(SheetDocumentDisplayer.java:52)
 at org.xwiki.display.internal.ConfiguredDocumentDisplayer.display(ConfiguredDocumentDisplayer.java:68)
 at org.xwiki.display.internal.ConfiguredDocumentDisplayer.display(ConfiguredDocumentDisplayer.java:42)
 at com.xpn.xwiki.doc.XWikiDocument.display(XWikiDocument.java:1355)
 at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1492)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1441)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1410)
 at com.xpn.xwiki.api.Document.displayDocument(Document.java:786)
 at jdk.internal.reflect.GeneratedMethodAccessor504.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)
 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)
 at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:242)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.xwiki.velocity.internal.directive.TryCatchDirective.render(TryCatchDirective.java:86)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:328)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:792)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:747)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:739)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)
 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)
 at jdk.internal.reflect.GeneratedMethodAccessor266.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:328)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:792)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:747)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:739)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)
 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)
 at jdk.internal.reflect.GeneratedMethodAccessor266.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:328)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:95)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:222)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:177)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:138)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)
 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)
 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)
 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:843)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:805)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:785)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:771)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:91)
 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:85)
 at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2563)
 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:651)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:339)
 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:114)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:232)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:122)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:61)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1651)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [xwiki:WaihonaCode.healthTopicsSheet]
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:289)
 at com.xpn.xwiki.render.DefaultVelocityManager.evaluate(DefaultVelocityManager.java:328)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:127)
 ... 193 more
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'execute' in  class org.xwiki.query.internal.ScriptQuery threw exception org.xwiki.query.QueryException: Exception while executing query. Query statement = [ select doc.fullName from XWikiDocument as doc , BaseObject as dis , com.xpn.xwiki.objects.StringProperty as dis_key1 where ( dis_key1.value = :key ) and doc.fullName=dis.name and dis.className='WaihonaCode.diseaseClass' and dis_key1.id.id=dis.id and dis_key1.id.name='key' ] at xwiki:WaihonaCode.healthTopicsSheet[line 79, column 118]
 at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:308)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)
 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)
 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)
 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)
 at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:242)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)
 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)
 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)
 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)
 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)
 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)
 at org.apache.velocity.Template.merge(Template.java:358)
 at org.apache.velocity.Template.merge(Template.java:262)
 at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:280)
 ... 195 more
Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [ select doc.fullName from XWikiDocument as doc , BaseObject as dis , com.xpn.xwiki.objects.StringProperty as dis_key1 where ( dis_key1.value = :key ) and doc.fullName=dis.name and dis.className='WaihonaCode.diseaseClass' and dis_key1.id.id=dis.id and dis_key1.id.name='key' ]
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:184)
 at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
 at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306)
 at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:117)
 at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
 at org.xwiki.query.internal.SecureQueryExecutorManager.execute(SecureQueryExecutorManager.java:67)
 at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306)
 at org.xwiki.query.internal.ScriptQuery.execute(ScriptQuery.java:276)
 at jdk.internal.reflect.GeneratedMethodAccessor288.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)
 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)
 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)
 ... 210 more
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:835)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:902)
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:169)
 ... 223 more
Caused by: java.lang.NullPointerException