Statistical Classification of Economic Activities in the European Community, Rev. 2.1 (NACE Rev. 2.1)

Failed to execute the [velocity] macro. Cause: [Error number 9001 in 9: Access denied in edit mode on document sdmx:Models.NACE_Rev_2_1]. Click on this message for details.
org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [##Значение переменных по умолчанию
#set($catalogId = 'SA')
#set($configurationDoc = $xwiki.getDocument("SKMS.Code.SKMSConfiguration"))
#set($configurationCatalogObject = $configurationDoc.getObjects("SKMS.Code.CatalogConfigurationClass", 'id', $catalogId))
#set($isCatalogPresent = $objecttool.isNotEmpty($configurationCatalogObject) && !$configurationCatalogObject.isEmpty())
#set ($configDocObject = $configurationDoc.getObject('SKMS.Code.SKMSConfigurationClass'))
#set ($URI_PREFIX = $configDocObject.getProperty("purlServer").value)
##Формирование URI рездела было $services.wiki.getCurrentWikiId()
#set ($domain = $URI_PREFIX+"/section/"+$services.wiki.getCurrentWikiDescriptor().getDefaultAlias())
#if ($services.wiki.getCurrentWikiId() == 'xwiki')
  #set ($domain = $URI_PREFIX+"/section/Common")
#end
#set($MetadataObj = $configurationDoc.getObject("SKMS.Code.MetadataConfigurationClass", false))
#if($MetadataObj)
  #set ($dcatTheme = $MetadataObj.getValue('dcat_theme'))
  #if ($dcatTheme)
    #foreach ($theme in $dcatTheme)
      #set ($themes = "$themes'$theme', ")
    #end
  #end
  #set ($license = $MetadataObj.getValue('license'))
  #set ($publisher = $MetadataObj.getValue('uri_publisher')+'/CIS_STAT')
#end

#set ($details = "{'namespaces':{'dcterms':'http://purl.org/dc/terms/', 'dcat': 'http://www.w3.org/ns/dcat#'},'dcterms':{'license': {'type': 'uri', 'value': '$license'}, 'publisher': {'type':'uri', 'value': '$publisher'}}, 'dcat':{'theme':['http://purl.semanticpro.org/adms/internal', 'http://purl.semanticpro.org/skos/BasicModel', 'http://purl.semanticpro.org/skos/DomainModel', 'http://purl.semanticpro.org/skos/CloseList', 'http://purl.semanticpro.org/skos/MasterData', 'http://purl.semanticpro.org/skos/NotLocalized', 'http://purl.semanticpro.org/skos/SematicWeb', 'http://purl.semanticpro.org/skos/WithCopies', 'http://purl.semanticpro.org/skos/WithoutNotations', '$domain']}}")

#set ($object = $doc.getObject('SKMS.SemanticClassifiers.Code.SemanticClassifiersClass'))
#set ($discard = $xwiki.jsx.use('SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet'))
#set ($discard = $xwiki.ssx.use('SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet'))
#if (!$object)
  #set ($messageKey = 'semanticclassifiers.sheet.description')
  #set ($messageType = 'info')
  #if ($doc.documentReference.name != 'SemanticClassifiersSheet' || $doc.documentReference.name != 'SemanticClassifiersTemplate')
    #set ($messageKey = 'semanticclassifiers.sheet.noObject')
    #set ($messageType = 'warning')
  #end
  {{$messageType}}
  $services.localization.render($messageKey)
  {{/$messageType}}
  #stop
#end
#set ($discard = $xwiki.jsfx.use('uicomponents/edit/editableProperty.js', {
  'forceSkinAction': true,
  'language': $xcontext.locale
}))
#set ($discard = $doc.use($object))
#set ($editing = $xcontext.action == 'edit')
##при создании страницы необходимо создать дочерние страницы для формирования и использования расширяемых классов конкретно под каждый справочник.
##необходимо проверить, существуют ли дочерние страницы с нужными названиями. Названия страниц для модели справочника не будут изменяться

##создание страницы с классом описания полей справочника(модель описания справочника и модель элементов справочника)
##условие, чтобы дочерние страницы не создавались в sheet или template
#set($inter = 0)
#if($doc !='SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet' or $doc!='SKMS.SemanticClassifiers.Code.SemanticClassifiersTemplate')
#set($parentPage = $xwiki.getDocument($doc))
#set($FieldPageName = 'FieldsDescription')
#set($FieldPageFullName = $parentPage.fullName.replaceAll('\.WebHome$', '') + '.' + $FieldPageName)

## Получаем страницу с описанием(если ее нет, то она автоматически создастся
#set($FieldPage = $xwiki.getDocument($FieldPageFullName))
#if ($FieldPage.isNew()) ##проверка, что это новая страница(только что созданная)
  ## Установление родителя
  $FieldPage.setParent($parentPage.fullName.replaceAll('\.WebHome$', ''))
##добавление в дочернюю страницу объекта для определения типа страницы
#set($fieldsTypeObj=$FieldPage.getObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#if($fieldsTypeObj) ##проверка, что в странице есть объект для определения типа
#set($fieldsTypeObj=$fieldsTypeObj.set('PageType','fields'))
#else ##если объекта нет, то создаем его и добавляем тип страницы "описание полей"
#set($newObj= $FieldPage.newObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#set($newObj = $newObj.set('PageType','fields'))
#end ##конец проверки объекта с типом страницы
 
##добавление 2х полей для формирования модели описания справочника и элементов справочника на страницу класса(дефолтные поля)
#set ($myinternaldoc = $FieldPage.getDocument())
#set ($myclass = $myinternaldoc.getXClass())
#set($discard=$myclass.addTextField("URI","URI",30))
#set ($discard = $myclass.addTextAreaField('ModelFieldsList', 'Модель элемента справочника', 100, 5))
#set ($discard = $myclass.addTextAreaField('DescFieldsList', 'Модель описания справочника', 100, 5))
## Сохранение документа
#set ($discard = $FieldPage.save('Добавленя поля для формирования модели справочника'))

##создание страницы конструктора и помещение в него объекта с классом полей(блоков) справочника
#set($constructorPage = $xwiki.getDocument($parentPage.fullName.replaceAll('\.WebHome$', '') + '.ConstructorPage'))
#if ($constructorPage.isNew()) ##проверка, что это новая страница(только что созданная)
$constructorPage.setParent($parentPage.fullName.replaceAll('\.WebHome$', ''))
$constructorPage.setTitle('Model constructor')

##установления объекта для определения типа страницы конструктора
#set($ConstrfieldsTypeObj=$constructorPage.getObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#if($ConstrfieldsTypeObj) ##проверка, что в странице есть объект для определения типа
#set($ConstrfieldsTypeObj=$ConstrfieldsTypeObj.set('PageType','constructor'))
#else ##если объекта нет, то создаем его и добавляем тип страницы "описание полей"
#set($newObj= $constructorPage.newObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#set($newObj = $newObj.set('PageType','constructor'))
#end ##конец проверки объекта с типом страницы
##добавляем класс конструктора для встраивания sheet
#set($constructorClass = $constructorPage.getObject('SKMS.SemanticClassifiers.Code.ClassifierConstructorClass'))
#if(!$constructorClass)
#set($discard = $constructorPage.newObject('SKMS.SemanticClassifiers.Code.ClassifierConstructorClass'))
#set($discard = $constructorPage.save())
#end
#set($fieldsObj=$constructorPage.getObject($FieldPage))
#if(!$fieldsObj) ##проверка, что в странице нет объекта для описания полей
#set($discard = $constructorPage.setDefaultLocale($services.localization.getDefaultLocale()))
#set($newObj= $constructorPage.newObject($FieldPage))
#set($fieldsObj=$constructorPage.getObject($FieldPage))
##set($discard = $fieldsObj.set("ModelFieldsList",'{"suffix_URI":{"type":"String","ru":"Английское название","en":"English name","international":"1"},"label":{"type":"String","ru":"Название","international":"0","en":"Label"},"rdf.type":{"type":"String","ru":"Тип элемента","international":"0","en":"Element type"}}'))
#set($discard = $fieldsObj.set("ModelFieldsList",'{"suffix_URI":{"type":"String","ru":"Английское название","en":"English name","international":"1"},"label":{"type":"String","ru":"Название","international":"0","en":"Label"},"rdf.type":{"type":"String","ru":"Тип элемента","international":"0","en":"Element type"},"skos.notation":{"type":"String","en":"Notation","international":"0"},"rdfs.isDefinedBy":{"type":"String","en":"Defined by","international":"0"},"rdfs.subClassOf":{"type":"String","en":"SubClass of","international":"0"},"skos.exactMatch":{"type":"String","en":"Exact match","international":"0"}}'))
##set($discard = $fieldsObj.set("DescFieldsList",'{"suffix_URI":{"type":"String","ru":"Английское название","en":"English name","international":"1"}}'))
#set($discard = $fieldsObj.set("DescFieldsList",'{"suffix_URI":{"type":"String","ru":"Английское название","en":"English name","international":"1"},"skos.notation":{"type":"String","en":"Notation","international":"0"},"skos.definition":{"type":"TextArea","en":"Definition","international":"0"},"rdfs.seeAlso":{"type":"TextArea","en":"See also","international":"0"},"skos.altLabel":{"type":"Static List","en":"Alternative name","international":"0"},"rdfs.subClassOf":{"type":"String","en":"SubClass of","international":"0"},"skos.note":{"type":"TextArea","en":"Note","international":"0"},"skos.related":{"type":"TextArea","en":"Related","international":"0"},"skos.exactMatch":{"type":"TextArea","en":"Exact match","international":"0"}}'))
#set($discard = $constructorPage.save('New Fields Object'))
#end ##конец проверки объекта описания полей
#end##конец проверки, что страница конструктора новая

#end
##-----------------------------------------------------##



##создание страницы с классом для описательного блока справочника
#set($DescPageName = 'DescriptionPage')
#set($DescPageFullName = $parentPage.fullName.replaceAll('\.WebHome$', '') + '.' + $DescPageName)

## Получаем страницу с описанием(если ее нет, то она автоматически создастся
#set($DescPage = $xwiki.getDocument($DescPageFullName))
#if ($DescPage.isNew()) ##проверка, что это новая страница(только что созданная)
  ## Установление родителя
  $DescPage.setParent($parentPage.fullName.replaceAll('\.WebHome$', ''))
##добавление в дочернюю страницу объекта для определения типа страницы
#set($DescfieldsTypeObj=$DescPage.getObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#if($DescfieldsTypeObj) ##проверка, что в странице есть объект для определения типа
#set($DescfieldsTypeObj=$DescfieldsTypeObj.set('PageType','desc'))
#else ##если объекта нет, то создаем его и добавляем тип страницы "описание полей"
#set($DescnewObj= $DescPage.newObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#set($DescnewObj = $DescnewObj.set('PageType','desc'))
#end ##конец проверки объекта с типом страницы
 

##добавление 2х полей для формирования модели описания справочника и элементов справочника на страницу класса(дефолтные поля)
#set ($myinternaldoc = $DescPage.getDocument())
#set ($myclass = $myinternaldoc.getXClass())
#set ($discard = $myclass.addTextField("URI","URI",30))
#set ($discard = $myclass.addTextField("lang","Язык",30))
##set ($discard = $myclass.addStaticListField('lang', 'Язык', 1, 0, 0, 'ru=Russian|en=Enlglish', 'select', '|')) ## !!!в будущем добавить автоматизацию установки доступных языков
#set ($discard = $myclass.addTextField("suffix_URI","Английское название",30))
#set ($discard = $myclass.addTextField('skos.notation', 'Notation', 30))
#set ($discard = $myclass.addTextAreaField('skos.definition', 'Definition', 100, 5))
#set ($discard = $myclass.addTextAreaField('rdfs.seeAlso', 'See also', 100, 5))
#set ($discard = $myclass.addTextAreaField('skos.note', 'Note', 100, 5))
#set ($discard = $myclass.addTextAreaField('skos.related', 'Related', 100, 5))
#set ($discard = $myclass.addTextAreaField('skos.exactMatch', 'Exact match', 100, 5))
#set ($discard = $myclass.addStaticListField('skos.altLabel', 'Alternative name', 1, 1, 0, '', 'input','|', '', 'allowed', 1))
#set ($discard = $myclass.addTextField('rdfs.subClassOf', 'SubClass of', 30))
## Сохранение документа
#set ($discard = $DescPage.save('Добавлено поле языка для описательного блока справочника'))
##добавляем объект описательного блока справочника
#set($descObj=$parentPage.newObject($DescPage))
#set($discard=$descObj.set('lang',$xcontext.locale.toString()))
##set($discard=$parentPage.save('Добавлена '+$xcontext.locale.toString()+' версия объекта описательного блока справочника'))
#end
##-----------------------------------------------------##


##создание страницы с классом для элементов справочника
#set($ItemPageName = 'ItemPage')
#set($ItemPageFullName = $parentPage.fullName.replaceAll('\.WebHome$', '') + '.' + $ItemPageName)

## Получаем страницу с описанием(если ее нет, то она автоматически создастся
#set($ItemPage = $xwiki.getDocument($ItemPageFullName))
#if ($ItemPage.isNew()) ##проверка, что это новая страница(только что созданная)
  ## Установление родителя
  $ItemPage.setParent($parentPage.fullName.replaceAll('\.WebHome$', ''))
##добавление в дочернюю страницу объекта для определения типа страницы
#set($ItemTypeObj=$ItemPage.getObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#if($ItemTypeObj) ##проверка, что в странице есть объект для определения типа
#set($ItemTypeObj=$ItemTypeObj.set('PageType','item'))
#else ##если объекта нет, то создаем его и добавляем тип страницы "описание полей"
#set($ItemnewObj= $ItemPage.newObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#set($ItemnewObj = $ItemnewObj.set('PageType','item'))
#end ##конец проверки объекта с типом страницы
 

##добавление 2х полей для формирования модели описания справочника и элементов справочника на страницу класса(дефолтные поля)
#set ($itemDoc = $ItemPage.getDocument())
#set ($Itemmyclass = $itemDoc.getXClass())
##set ($discard = $Itemmyclass.addStaticListField('rdf.type', 'Тип элемента', 1, 0, 0, 'skos:Concept=Концепт|skos:ConceptScheme=Концепт схемы', 'select', '|','skos:Concept')) ## тип элемента (концепт/концепт схемы)
#set ($discard = $Itemmyclass.addTextField("URI","URI",30))
#set ($discard = $Itemmyclass.addTextField("lang","Язык",30))
#set ($discard = $Itemmyclass.addTextField("rdf.type","Тип элемента",30))
##set ($discard = $Itemmyclass.addStaticListField('lang', 'Язык', 1, 0, 0, 'ru=Russian|en=Enlglish', 'select', '|')) ## !!!в будущем добавить автоматизацию установки доступных языков
#set ($discard = $Itemmyclass.addTextField("suffix_URI","Английское название",30))
#set ($discard = $Itemmyclass.addTextField("label","Название",30))
#set ($discard = $Itemmyclass.addTextField("skos.notation","Notation",30))
#set ($discard = $Itemmyclass.addTextField("rdfs.isDefinedBy","Defined by",30))
#set ($discard = $Itemmyclass.addTextField("rdfs.subClassOf","SubClass of",30))
#set ($discard = $Itemmyclass.addTextField("skos.exactMatch","Exact match",30))
## Сохранение документа
#set ($discard = $ItemPage.save('Добавлено поле языка для элементов справочника'))
##добавляем объект описательного блока справочника
#set($itemObj=$doc.newObject($ItemPage))
#set($discard=$itemObj.set('lang',$xcontext.locale.toString()))
##set($discard=$parentPage.save('Добавлен объект элемента справочника'))
#end
##-----------------------------------------------------##
#end ##(конец условия, что это не sheet или template

##отображение и редактирование объектов на странице справочника
##прежде всего необходимо получить названия объектов для отображения
##нам нужны класс элементов справочника и класс описательного блока
##foreach($child in $doc.getChildren())##цикл по дочерним страницам(1)
 ##set ($rdoc = $xwiki.getDocument($child))
##set($typeObj = $rdoc.getObject('SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass'))
#set($descPageQ = "select DISTINCT doc.fullName from Document doc, doc.object(SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass) obj where doc.fullName like '"+$doc.fullName+"%' and obj.PageType like 'desc'")
#set($descPageQuery = $services.query.xwql($descPageQ).execute())
#if($descPageQuery && $descPageQuery.size() > 0)
  #set($descriptionObjName= $xwiki.getDocument($descPageQuery[0]))
#end
#set($itemPageQ = "select DISTINCT doc.fullName from Document doc, doc.object(SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass) obj where doc.fullName like '"+$doc.fullName+"%' and obj.PageType like 'item'")
#set($itemPageQuery = $services.query.xwql($itemPageQ).execute())
#if($itemPageQuery && $itemPageQuery.size() > 0)
  #set($itemObjName= $xwiki.getDocument($itemPageQuery[0]))
#end
#set($constructorPageQ = "select DISTINCT doc.fullName from Document doc, doc.object(SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass) obj where doc.fullName like '"+$doc.fullName+"%' and obj.PageType like 'constructor'")
#set($constructorPageQuery = $services.query.xwql($constructorPageQ).execute())
#if($constructorPageQuery && $constructorPageQuery.size() > 0)
  #set($constrPage = $xwiki.getDocument($constructorPageQuery[0]))
#end
#set($fieldsPageQ = "select DISTINCT doc.fullName from Document doc, doc.object(SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass) obj where doc.fullName like '"+$doc.fullName+"%' and obj.PageType like 'fields'")
#set($fieldsPageQuery = $services.query.xwql($fieldsPageQ).execute())
#if($fieldsPageQuery && $fieldsPageQuery.size() > 0)
  #set($fieldsPageName = $xwiki.getDocument($fieldsPageQuery[0]))
#end
##end##конец цикла(1)



#set ($editing = $xcontext.action == 'edit')
#set($vdoc = $xwiki.getDocument($doc.getFullName()))
## The object to display.
##set ($xobject = $vdoc.getObject('SKMS.Models.Code.ModelsDescriptionClass'))
## Объекты для отображения
##описание
#set ($DescObject = $doc.getObject($descriptionObjName,'lang', $xcontext.locale.toString())) ##объект описания
#set($configurationDoc = $xwiki.getDocument("SKMS.Code.SKMSConfiguration"))
#set($configurationDocObject = $configurationDoc.getObject("SKMS.Code.SKMSConfigurationClass", false))
#set ($domainURI = $configurationDocObject.getProperty("defaultURIPrefix").value)
#if(!$DescObject && $doc.getTranslatedDocument($xcontext.locale.toString()).getRealLocale().toString() == $xcontext.locale.toString()) ##если объекта на текущем языке нет, то создадим его
#set($descObj=$doc.newObject($descriptionObjName))
#set($discard=$descObj.set('lang',$xcontext.locale.toString()))
#set($discard=$doc.save('Добавлена '+$xcontext.locale.toString()+' версия объекта описательного блока справочника'))
#elseif($DescObject and $xcontext.locale.toString() == $services.localization.defaultLocale.toString()) ##автоматическое формирование URI для страницы на языке по умолчанию
#if($stringtool.isBlank($DescObject.getValue("URI")) and !$stringtool.isBlank($DescObject.getValue("suffix_URI")))
#set($clean_suffix_URI = $DescObject.getValue("suffix_URI").replaceAll('[\\:*?"<>| ]',"_"))
##set($words = $clean_suffix_URI.split(" "))
##set($result = "")
##foreach($word in $words)
##  #set($result = "${result}${word.substring(0,1).toUpperCase()}${word.substring(1)}")
##end
##set($clean_suffix_URI = $result)
#if($objecttool.isNotNull($object.getValue("version")))
#set($ClassifierURI = $domainURI+"code/"+ $clean_suffix_URI+"/"+$object.getValue("version").toString()+".0")
#else
#set($ClassifierURI = $domainURI+"code/"+ $clean_suffix_URI)
#end
#set($discard = $object.set('clean_suffix_URI',$clean_suffix_URI))
#set($discard = $DescObject.set("URI",$ClassifierURI))
#set($discard = $doc.save('Обновлен URI справочника'))
#end
#elseif($DescObject and $xcontext.locale.toString() != $services.localization.defaultLocale.toString())
#set($defaultDescObject = $doc.getObject($descriptionObjName,'lang', $services.localization.defaultLocale.toString()))
#if($defaultDescObject.getValue("URI")!= $DescObject.getValue("URI") or $defaultDescObject.getValue("suffix_URI")!= $DescObject.getValue("suffix_URI"))
#set($discard = $DescObject.set("suffix_URI", $defaultDescObject.getValue("suffix_URI")))
#set($discard = $DescObject.set("URI", $defaultDescObject.getValue("URI")))
#set($discard = $doc.save('Обновлен URI справочника для '+$xcontext.locale.toString()+ ' версии'))
#end
#end
#set ($DescClass=$xwiki.getClass($descriptionObjName))
##---------##


##элементы справочника
#set ($itemObjects = $doc.getObjects($itemObjName,'lang',$xcontext.locale.toString())) ##объекты элементов справочника на текущем языке
##название полей справочника
#set($FieldsObject = $constrPage.getObject($fieldsPageName))
##set($DescObject = $constrPage.getObject($descriptionObjName))
##преобразовываем в MAP из STRING
#set($itemFields=$jsontool.fromString($FieldsObject.getValue('ModelFieldsList')))
#set($DescFiedls=$jsontool.fromString($FieldsObject.getValue('DescFieldsList')))
#set($keys = $itemFields.keySet())
##--------------------##
##первичное формирование URI элементов
#if($xcontext.locale.toString() == $services.localization.defaultLocale.toString())
#set($newuri = 0)
#foreach($item in $itemObjects)
#if($stringtool.isBlank($item.getValue('URI').toString()))
#if(($stringtool.containsIgnoreCase($item.getValue('rdf.type').toString(),"skos:Concept") || $stringtool.isBlank($item.getValue('rdf.type').toString()) || $stringtool.containsIgnoreCase($item.getValue('rdf.type').toString(),"rdfs:Class")) and !$stringtool.containsAnyIgnoreCase($item.getValue('rdf.type').toString(),"skos:ConceptScheme")) ##условие на тип элемента
#if(!$stringtool.isBlank($DescObject.getValue("URI").toString()) and !$stringtool.isBlank($item.getValue('suffix_URI').toString()))
#set($clean_uri_elem = $item.getValue("suffix_URI").replaceAll('[\\:*?"<>| ]',"_"))
##set($words1 = $clean_uri_elem.split(" "))
##set($result1 = "")
##foreach($word in $words1)
##  #set($result1 = "${result1}${word.substring(0,1).toUpperCase()}${word.substring(1)}")
###end
##set($clean_uri_elem = $result1)
#set($elemURI = $DescObject.getValue("URI") + '/'+ $clean_uri_elem)
#set($discard = $item.set('URI',$elemURI))
#set($newuri = 1)
#end
#elseif ($stringtool.containsAnyIgnoreCase($item.getValue('rdf.type'),"skos:ConceptScheme")) ##если элемент концепт схемы
#set($ClassifierLink = $item.getValue('link'))
#if(!$stringtool.isBlank($ClassifierLink))
#set($seeAlso = $xwiki.getDocument($ClassifierLink).getTranslatedDocument())
#set($descname =$ClassifierLink+'.DescriptionPage')
#set($desc = $seeAlso.getObject($descname))
#if(!$stringtool.isBlank($desc.getValue('suffix_URI')) and !$stringtool.isBlank($desc.getValue('URI')))
#set($discard = $item.set('suffix_URI',$desc.getValue('suffix_URI')))
#set($discard = $item.set('URI',$desc.getValue('URI')))
#set($newuri = 1)
#end ##конец условия на наличие ури
#end ##конец условия на наличие ссылки
#end ##конец условия на тип элемента
#end ##конец условия
#end
#if($newuri == 1)
#set($discard = $doc.save('Обновлены URI элементов'))
#end
#end
##----------------------##
#set ($itemClass=$xwiki.getClass($itemObjName))
##создание языковых версий элементов
#if($xcontext.locale.toString() != $services.localization.defaultLocale.toString() && $doc.getTranslatedDocument($xcontext.locale.toString()).getRealLocale().toString() == $xcontext.locale.toString())
#set($itemObjectsDefaultLocale = $doc.getObjects($itemObjName,'lang',$services.localization.defaultLocale.toString())) ##объекты элементов справочника на дефолтном языке

#foreach($defaultObj in $itemObjectsDefaultLocale)
##индикатор совпадения
#set($match = 0)
#if($defaultObj.getValue('URI')!='') ##языковая версия создается только при условии заполненного URI на дефолтном языке
#foreach($currentObj in $itemObjects)
#if(($stringtool.containsIgnoreCase($currentObj.getValue('rdf.type').toString(),"skos:Concept") || $stringtool.isBlank($currentObj.getValue('rdf.type').toString())) && !$stringtool.containsAnyIgnoreCase($currentObj.getValue('rdf.type').toString(),"skos:ConceptScheme"))
#if($currentObj.getValue('URI') == $defaultObj.getValue('URI')) ##если есть объект на язык. версии с одинак. URI, то не добавляем его язык. версию
#set($match = 1)

#foreach($key in $keys)
#if($itemFields[$key]["international"]=="1" and $itemFields[$key]["international"]) ##если поле непереводимое, то его значение необходимо продублировать для языковых версий
#if($currentObj.getValue($key) != $defaultObj.getValue($key)) ##если значения на разных языках не совпадают
#set($discard = $currentObj.set($key,$defaultObj.getValue($key)))
#set($inter = 1)
#end
#end
#end
#end
#end
#end
#if($match == 0) ##если не найдено объекта с URI как у объекта на дефолтном языке, то создадим егоg
#set($inter = 1)
#set($currentObj = $doc.newObject($itemObjName))
#set($discard = $currentObj.set('lang',$xcontext.locale.toString())) ##установка языка
##цикл для дублирования информации из объекта на дефолтном языке
#foreach($prop in $itemClass.properties)
#if($prop.getName() !='lang')
#set($discard = $currentObj.set($prop.getName(),$defaultObj.getValue($prop.getName())))
#end
#end
##$doc.save('Added classifiers object in '+$xcontext.locale.toString())
##$response.sendRedirect($doc.getURL('view'))
#end

#end
#end
#set($match = 0)
#end
#if($inter == 1)
  #set($discard = $doc.save('Update classifiers object in '+$xcontext.locale.toString()+' added'))
  $response.sendRedirect($doc.getURL('view'))
#end

##------##]
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:186)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:60)
 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:311)
 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:396)
 at org.xwiki.display.internal.DocumentContentAsyncExecutor.execute(DocumentContentAsyncExecutor.java:269)
 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:1407)
 at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1543)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1493)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1462)
 at com.xpn.xwiki.api.Document.displayDocument(Document.java:821)
 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:853)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:808)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:800)
 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 java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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:217)
 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.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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:853)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:808)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:800)
 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 java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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:217)
 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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:846)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:832)
 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:2569)
 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:650)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:338)
 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:108)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
 at org.eclipse.jetty.ee8.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1151)
 at org.eclipse.jetty.ee8.servlet.ServletHolder.handle(ServletHolder.java:640)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1374)
 at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:122)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:61)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:177)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.eclipse.jetty.ee8.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:175)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.eclipse.jetty.ee8.servlet.ServletHandler.doHandle(ServletHandler.java:454)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.handle(ScopedHandler.java:119)
 at org.eclipse.jetty.ee8.security.SecurityHandler.handle(SecurityHandler.java:497)
 at org.eclipse.jetty.ee8.nested.HandlerWrapper.handle(HandlerWrapper.java:108)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextHandle(ScopedHandler.java:183)
 at org.eclipse.jetty.ee8.nested.SessionHandler.doHandle(SessionHandler.java:519)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextHandle(ScopedHandler.java:181)
 at org.eclipse.jetty.ee8.nested.ContextHandler.doHandle(ContextHandler.java:881)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextScope(ScopedHandler.java:152)
 at org.eclipse.jetty.ee8.servlet.ServletHandler.doScope(ServletHandler.java:423)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextScope(ScopedHandler.java:150)
 at org.eclipse.jetty.ee8.nested.SessionHandler.doScope(SessionHandler.java:503)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextScope(ScopedHandler.java:150)
 at org.eclipse.jetty.ee8.nested.ContextHandler.doScope(ContextHandler.java:826)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.handle(ScopedHandler.java:117)
 at org.eclipse.jetty.ee8.nested.ContextHandler.handle(ContextHandler.java:1424)
 at org.eclipse.jetty.ee8.nested.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1290)
 at org.eclipse.jetty.ee8.nested.HttpChannel.dispatch(HttpChannel.java:623)
 at org.eclipse.jetty.ee8.nested.HttpChannel.handle(HttpChannel.java:460)
 at org.eclipse.jetty.ee8.nested.ContextHandler$CoreContextHandler$CoreToNestedHandler.handle(ContextHandler.java:2385)
 at org.eclipse.jetty.server.handler.ContextHandler.handle(ContextHandler.java:1060)
 at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:181)
 at org.eclipse.jetty.server.Server.handle(Server.java:182)
 at org.eclipse.jetty.server.internal.HttpChannelState$HandlerInvoker.run(HttpChannelState.java:662)
 at org.eclipse.jetty.server.internal.HttpConnection.onFillable(HttpConnection.java:418)
 at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:322)
 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:99)
 at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:478)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:441)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:293)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:201)
 at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:311)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:979)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1209)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1164)
 at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [sdmx:SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet]
 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:235)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:168)
 ... 206 more
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'save' in  class com.xpn.xwiki.api.Document threw exception com.xpn.xwiki.XWikiException: Error number 9001 in 9: Access denied in edit mode on document sdmx:Models.NACE_Rev_2_1 at sdmx:SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet[line 250, column 20]
 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.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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 ... 207 more
Caused by: com.xpn.xwiki.XWikiException: Error number 9001 in 9: Access denied in edit mode on document sdmx:Models.NACE_Rev_2_1
 at com.xpn.xwiki.api.Document.save(Document.java:2697)
 at com.xpn.xwiki.api.Document.save(Document.java:2673)
 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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)
 ... 217 moreFailed to execute the [velocity] macro. Cause: [Invalid path: 'URI.value' [select suffix_URI.value from com.xpn.xwiki.doc.XWikiDocument as doc, com.xpn.xwiki.objects.BaseObject as obj, com.xpn.xwiki.objects.StringProperty as rdf_type, com.xpn.xwiki.objects.StringProperty as suffix_URI where obj.className = 'Models.NACE_Rev_2_1.ItemPage' and doc.fullName = obj.name and rdf_type.id.id = obj.id and rdf_type.id.name = 'rdf.type' and (rdf_type.value like '%xkos:ClassificationLevel%' or rdf_type.value like '%skos:Collection%') and URI.value is not null and label.value is not null and suffix_URI.id.id = obj.id and suffix_URI.id.name = 'suffix_URI' order by xkos_depth.value]]. Click on this message for details.
org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [{{html wiki="true" clean="false"}}
#if ($doc.documentReference.name == 'SemanticClassifiersSheet' || $doc.documentReference.name == 'SemanticClassifiersTemplate')
    #set ($messageKey = 'semanticclassifiers.sheet.noObject')
    #set ($messageType = 'warning')
  {{$messageType}}
  $services.localization.render($messageKey)
  {{/$messageType}}
  #stop
#end
<div class="xform"> ## Using the xform vertical form layout.
 <h4>$services.localization.render("skms.classifiers.SemanticClassifiersSheet.text.desc")</h4>
  <dl>
#set($discard = $vdoc.use($DescObject))  ##цикл отображения полей описания
#foreach ($prop in $DescClass.properties)
  #set($fieldmap=$DescFiedls.get($prop.name))
  #if(!$editing && ($stringtool.isBlank($DescObject.getValue($prop.name)) || $objecttool.isNull($DescObject.getValue($prop.name)) || $stringtool.equalsIgnoreCase('[]',$DescObject.getValue($prop.name).toString()))) ##если поле пустое, то не выводим его при просмотре
  #else
    #if(!$stringtool.equalsIgnoreCase($prop.name, 'lang') && !$stringtool.equalsIgnoreCase($prop.name, 'URI') && !$stringtool.equalsIgnoreCase($prop.name, 'suffix_URI') && !$stringtool.equalsIgnoreCase($prop.name, 'rdf.type'))
     <dt><label>#if($fieldmap.get($xcontext.locale.toString()))$fieldmap.get($xcontext.locale.toString())#else$fieldmap.get($services.localization.defaultLocale.toString())#end</label></dt>
      #if($xcontext.locale.toString() == $services.localization.defaultLocale.toString() and $fieldmap.get("international")=="1")
        <dd>$vdoc.display($prop.getName())</dd>
      #elseif($fieldmap.get("international")=="1" and $xcontext.locale.toString() != $services.localization.defaultLocale.toString())
        <dd>$vdoc.display($prop.getName(),'view')</dd>
      #else
        <dd>$vdoc.display($prop.getName())</dd>
      #end
    #end
    #if($stringtool.equalsIgnoreCase($prop.name, 'URI'))
      <dt><label>$prop.prettyName</label></dt>
      <dd>$vdoc.display($prop.getName(),'view')</dd>
    #end
    #if($xcontext.action == 'edit')
      #if($stringtool.equalsIgnoreCase($prop.name, 'suffix_URI') || $stringtool.equalsIgnoreCase($prop.name, 'rdf.type'))
      <dt><label>#if($fieldmap.get($xcontext.locale.toString()))$fieldmap.get($xcontext.locale.toString())#else$fieldmap.get($services.localization.defaultLocale.toString())#end</label></dt>
        #if($xcontext.locale.toString() == $services.localization.defaultLocale.toString() and $fieldmap.get("international")=="1")
        <dd>$vdoc.display($prop.getName())</dd>
        #elseif($fieldmap.get("international")=="1" and $xcontext.locale.toString() != $services.localization.defaultLocale.toString())
        <dd>$vdoc.display($prop.getName(),'view')</dd>
        #else
        <dd>$vdoc.display($prop.getName())</dd>
        #end
        #if($stringtool.equalsIgnoreCase($prop.name, 'suffix_URI'))
        <div id="ChangeURI">
          <input type="hidden" value="${escapetool.xml($doc)}" id="docname"/>
          <input type="hidden" value="$escapetool.xml($itemObjName)" id="itemObjName"/>
          <input type="hidden" value="$escapetool.xml($descriptionObjName)" id="descriptionObjName"/>
          <input type="button" class="button"  id="ChangeURIButton" value="$services.localization.render("skms.classifiers.SemanticClassifiersSheet.btn.change")"/>
        </div>
        #end
      #end
    #end
  #end
#end
## Отображение класса кодлиста
#set($rdfsClassObj = $doc.getObject($itemObjName,'rdf.type','rdfs:Class'))
#if($rdfsClassObj)
    <dt><label>code list class</dt></label>
    <span id="$rdfsClassObj.getValue('suffix_URI')"></span><dd>$rdfsClassObj.display('URI','view') [[~[~[image:icon:page_white_text~]~] TTL>>||class="getTTL"]]</dd>
#end
##if($doc.getValue("SA_generation") == 1)
  #if($doc.getValue('cardExist') == 1) ##Формирование URL карточки каталога
    #set($CatalogObj = $configurationDoc.getObject("SKMS.Code.CatalogConfigurationClass", 'id', $catalogId))
    #if(!$stringtool.isBlank($CatalogObj.getProperty("catalog_url").value)) ##Заглушка на формирование при наличии в URI значения версии 1.0 или просто имени т.к. clean_suffix_URI может содержать /1.0
      #set($classifierURI = $DescObject.getValue("URI"))
      #set($suffixURI = $classifierURI)
      #set($sections = $classifierURI)
      #if($classifierURI.lastIndexOf('#')>-1)
        #set($suffixURI = $classifierURI.substring($classifierURI.lastIndexOf('#')+1))
        #set($sections = $classifierURI.substring(0, $classifierURI.lastIndexOf('#')))
      #end
      #if($suffixURI.lastIndexOf('/')>-1)
        #set($sections = $suffixURI.substring(0, $suffixURI.lastIndexOf('/')))
        #set($suffixURI = $suffixURI.substring($suffixURI.lastIndexOf('/')+1))
      #end
      #if($stringtool.compareIgnoreCase("1.0",$suffixURI)==0)
        #if($sections.lastIndexOf('/')>-1)
          #set($suffixURI = $sections.substring($sections.lastIndexOf('/')+1))
        #end
      #end
      #set($cardURI = $URI_PREFIX+"/catalog/"+$catalogId+"/card/"+$suffixURI)
      #set($catalog_url = $CatalogObj.getProperty("catalog_url").value + "#/adms/"+$escapetool.url($cardURI))
    #end
  #end
  #if($doc.getAttachmentList().size() > 0)<p>$services.localization.render("skms.classifiers.SemanticClassifiersSheet.text.rdf") [[$services.localization.render("skms.general.btn.download")>>attach:$doc.getAttachmentList()[0].getFilename()||target="_blank" class="btn btn-primary"]]#if($doc.getValue('cardExist') == 1 and $isCatalogPresent and !$stringtool.isBlank($CatalogObj.getProperty("catalog_url").value)){{/html}}{{html}} <a href="$catalog_url" target="_blank" class="btn btn-primary">$services.localization.render("skms.general.btn.catalog")</a>{{/html}}{{html wiki="true" clean="false"}}#end
</p>
  #end
##end
  <hr>
## Вывод уровней иерархического классификатора
#set($ClassificationLevelsQuery = "
  select obj.id
  from BaseObject as obj, StringProperty as typeProp
  where obj.className = '" +$itemObjName + "'
    and typeProp.id.id = obj.id
    and typeProp.id.name = 'rdf.type'
    and (typeProp.value like '%xkos:ClassificationLevel%' or typeProp.value like '%skos:Collection%')")
#set($ClassificationLevelsList = $services.query.hql($ClassificationLevelsQuery).execute())
#if($ClassificationLevelsList && $ClassificationLevelsList.size() > 0 && !$editing) ## Если есть классификационные уровни
  #set($excluded = ['lang','suffix_URI','rdf.type','rdfs.isDefinedBy','rdfs.subClassOf'])

  #set($selectParts = [])
  #set($joinParts = ["XWikiDocument as doc", "BaseObject as obj"])
  #set($whereParts = [])
  #set($discard = $whereParts.add("obj.className = '" + $itemObjName + "'"))
  #set($discard = $whereParts.add("doc.fullName = obj.name"))

  #set($allProps = [])
  #foreach($prop in $itemClass.properties)
    #set($propName = $prop.name)
    #if(!$excluded.contains($propName))
      #set($alias = $propName.replace(".", "_").replace("-", "_"))
      #set($fieldmap = $itemFields.get($prop.name))
    ## Определяем HQL-тип свойства
      #set($propertyType = $fieldmap.get("type"))
      #if($propertyType == "TextArea")
        #set($hqlPropertyClass = "LargeStringProperty")
      #else
        #set($hqlPropertyClass = "StringProperty")
      #end
      #set($discard = $selectParts.add($alias + ".value"))
      #set($discard = $joinParts.add($hqlPropertyClass + " as " + $alias))
      #set($discard = $whereParts.add($alias + ".id.id = obj.id"))
      #set($discard = $whereParts.add($alias + ".id.name = '" + $propName + "'"))
      #set($discard = $allProps.add({"name": $propName, "alias": $alias}))
    #end
  #end
## === Явно добавляем rdf.type для фильтрации ===
  #set($discard = $joinParts.add("StringProperty as rdf_type"))
  #set($discard = $whereParts.add("rdf_type.id.id = obj.id"))
  #set($discard = $whereParts.add("rdf_type.id.name = 'rdf.type'"))
  #set($discard = $whereParts.add("(rdf_type.value like '%xkos:ClassificationLevel%' or rdf_type.value like '%skos:Collection%')"))
## === Фильтрация по наличию URI и label ===
  #set($discard = $whereParts.add("URI.value is not null"))
  #set($discard = $whereParts.add("label.value is not null"))
## === Вручную добавляем в запрос суффикс URI ===
  #set($discard = $selectParts.add("suffix_URI.value"))
  #set($discard = $joinParts.add("StringProperty as suffix_URI"))
  #set($discard = $whereParts.add("suffix_URI.id.id = obj.id"))
  #set($discard = $whereParts.add("suffix_URI.id.name = 'suffix_URI'"))
## === Сборка запроса ===
  #set($hqlForClassificationLevels = "select " + $stringtool.join($selectParts, ", ") + " from " + $stringtool.join($joinParts, ", ") + " where " + $stringtool.join($whereParts, " and ") + " order by xkos_depth.value")
## === Выполнение запроса ===
  #set($results = $services.query.hql($hqlForClassificationLevels).execute())
## === Фильтруем видимые поля по непустым значениям ===
  #set($visibleProps = [])
  #foreach($i in [1..$allProps.size()])
    #set($hasValue = false)
    #if($results && $results.size() > 0)
      #foreach($row in $results)
        #set($val = $row[$i - 1])
        #if($val && !$stringtool.isBlank($val.toString()))
          #set($hasValue = true)
          #break
        #end
      #end
    #end
    #if($hasValue)
      #set($discard = $visibleProps.add($allProps[$i - 1]))
    #end
  #end
## === Таблица ===
## === Вывод Название: Значение ===
#if($results && $results.size() > 0 && $visibleProps && $visibleProps.size() > 0)
<h4>List of Classification Levels</h4>
  #foreach($row in $results)
  <dl>

    ## === 1) СНАЧАЛА ВЫВОДИМ label ===
    #foreach($prop in $visibleProps)
      #if($prop.name == "label")
        #set($value = $row[$allProps.indexOf($prop)])
        <dt><label>$!escapetool.xml($value)</label></dt>
      #end
    #end

    ## === 2) Теперь выводим остальные свойства ===
    #foreach($prop in $visibleProps)
      #if($prop.name != "skos.member" && $prop.name != "label")

        #set($fieldmap = $itemFields.get($prop.name))

        ## Название поля
        #if($prop.name == "URI")
          #set($title = "URI")
        #elseif($fieldmap.get($xcontext.locale.toString()))
          #set($title = $fieldmap.get($xcontext.locale.toString()))
        #else
          #set($title = $fieldmap.get($services.localization.defaultLocale.toString()))
        #end

        ## Значение
        #set($value = $row[$allProps.indexOf($prop)])

        <dd><strong>$title</strong>: $!escapetool.xml($value)</dd>

      #end
    #end

  </dl>
  #end
#end
#end
## Поиск дочерних страниц с элементами справочника
#set($ChildQuery = "select DISTINCT doc.fullName, doc.title from Document doc, doc.object(SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass) obj where doc.fullName like '"+$doc.fullName+"%' and obj.PageType like 'group' and doc.fullName not like '%Correspondence%' order by doc.title ASC ")
#set($GroupPages = $services.query.xwql($ChildQuery).execute())
##<h4>$services.localization.render("skms.classifiers.SemanticClassifiersSheet.text.content")</h4>
  <h5>$services.localization.render("skms.classifiers.SemanticClassifiersSheet.text.elemcomposition")</h5>
  #if(!$editing)
    <p>
    <a class="btn btn-default" data-toggle="collapse" href="#filterForm" aria-expanded="false" aria-controls="filterForm">
    Show / Hide filter
  </a>
  </p>
<div class="collapse" id="filterForm">
  <div class="well">
    <form action="$xwiki.getURL('SKMS.SemanticClassifiers.Code.FilterCodes')" method="post">
      <div class="form-group">
        <label for="labelInput">Contains in Label:</label>
        <input type="text" class="form-control" id="labelInput" name="Label"
               value="" />
      </div>
      <div class="form-group">
        <label for="notationInput">Contains in Notation:</label>
        <input type="text" class="form-control" id="notationInput" name="Notation"
               value="" />
      </div>
      <input type="hidden" name="docID" value="$escapetool.xml($doc)"/>
      <input type="hidden" name="ItemClass" value="$escapetool.xml($itemObjName)"/>
      #if($itemClass.get("sip_sdmx.hasAgencyLabel"))
      <input type="hidden" name="hasAgency" value="true"/>
      #else
      <input type="hidden" name="hasAgency" value="false"/>
      #end
      <button type="submit" class="btn btn-primary">Filter</button>
    </form>
  </div>
</div>
#end
  #set($CountQuery = "
  select count(obj.id)
  from BaseObject as obj, StringProperty as typeProp
  where obj.className = '" +$itemObjName + "'
    and typeProp.id.id = obj.id
    and typeProp.id.name = 'rdf.type'
    and typeProp.value not like '%rdfs:Class%'
    and typeProp.value not like '%xkos:ClassificationLevel%'
    and typeProp.value not like '%skos:Collection%'
    and typeProp.value not like '%xkos:ConceptAssociation%'
")

#set($countList = $services.query.hql($CountQuery).execute())
#if($countList && $countList.size() > 0 && !$editing)
  #set($count = $countList.get(0))
#else
  #set($count = 0)
#end
#if(!$editing)
  <p><strong>Total items:</strong> $count </p>
#end
#if($GroupPages && $GroupPages.size() > 0)
  #if(!$editing)
    #foreach($GroupPage in $GroupPages)
      #if($GroupPage && $GroupPage.size() >= 2)
        * [[$GroupPage[1]>>$GroupPage[0]]]
      #end
    #end
  #end
#else
#if(!$editing)
## === Настройки ===
#set($excluded = ['lang','suffix_URI','rdf.type','rdfs.isDefinedBy','rdfs.subClassOf'])
#set($selectParts = [])
#set($joinParts = ["XWikiDocument as doc", "BaseObject as obj"])
#set($whereParts = [])
#set($discard = $whereParts.add("obj.className = '" + $itemObjName + "'"))
#set($discard = $whereParts.add("doc.fullName = obj.name"))

#set($allProps = [])
#foreach($prop in $itemClass.properties)
  #set($propName = $prop.name)
  #if(!$excluded.contains($propName))
    #set($alias = $propName.replace(".", "_").replace("-", "_"))
    #set($fieldmap = $itemFields.get($prop.name))
    ## Определяем HQL-тип свойства
    #set($propertyType = $fieldmap.get("type"))
    #if($propertyType == "TextArea")
      #set($hqlPropertyClass = "LargeStringProperty")
    #else
      #set($hqlPropertyClass = "StringProperty")
    #end
    #set($discard = $selectParts.add($alias + ".value"))
    #set($discard = $joinParts.add($hqlPropertyClass + " as " + $alias))
    #set($discard = $whereParts.add($alias + ".id.id = obj.id"))
    #set($discard = $whereParts.add($alias + ".id.name = '" + $propName + "'"))
    #set($discard = $allProps.add({"name": $propName, "alias": $alias}))
  #end
#end
## === Явно добавляем rdf.type для фильтрации ===
#set($discard = $joinParts.add("StringProperty as rdf_type"))
#set($discard = $whereParts.add("rdf_type.id.id = obj.id"))
#set($discard = $whereParts.add("rdf_type.id.name = 'rdf.type'"))
#set($discard = $whereParts.add("(rdf_type.value is null or rdf_type.value not like 'rdfs:Class' or rdf_type.value not like '%xkos:ClassificationLevel%' or rdf_type.value not like '%skos:Collection%' or rdf_type.value not like '%xkos:ConceptAssociation%')"))
## === Фильтрация по наличию URI и label ===
#set($discard = $whereParts.add("URI.value is not null"))
#set($discard = $whereParts.add("label.value is not null"))
## === Вручную добавляем в запрос суффикс URI ===
#set($discard = $selectParts.add("suffix_URI.value"))
#set($discard = $joinParts.add("StringProperty as suffix_URI"))
#set($discard = $whereParts.add("suffix_URI.id.id = obj.id"))
#set($discard = $whereParts.add("suffix_URI.id.name = 'suffix_URI'"))
## === Сборка запроса ===
#set($hql = "select " + $stringtool.join($selectParts, ", ") + " from " + $stringtool.join($joinParts, ", ") + " where " + $stringtool.join($whereParts, " and "))
## === Выполнение запроса ===
#set($results = $services.query.hql($hql).execute())
## === Фильтруем видимые поля по непустым значениям ===
#set($visibleProps = [])
#foreach($i in [1..$allProps.size()])
  #set($hasValue = false)
  #if($results && $results.size() > 0)
    #foreach($row in $results)
      #set($val = $row[$i - 1])
      #if($val && !$stringtool.isBlank($val.toString()))
        #set($hasValue = true)
        #break
      #end
    #end
  #end
  #if($hasValue)
    #set($discard = $visibleProps.add($allProps[$i - 1]))
  #end
#end

## === Таблица ===
#if($results && $results.size() > 0 && $visibleProps && $visibleProps.size() > 0)
<table class="elementstable" style="width:auto;hyphens: auto;overflow-wrap: anywhere;" border="1">
  <thead>
    <tr>
      #foreach($prop in $visibleProps)
        #set($fieldmap = $itemFields.get($prop.name))
        #if($stringtool.equalsIgnoreCase($prop.name,'URI'))
          <th>$prop.name</th>
        #else
          #if($fieldmap.get($xcontext.locale.toString()))
            <th>$fieldmap.get($xcontext.locale.toString())</th>
          #else
            <th>$fieldmap.get($services.localization.defaultLocale.toString())</th>
          #end
        #end
      #end
    </tr>
  </thead>
  <tbody>
    #foreach($row in $results)
      <tr>
        #set($suffixUri = $row[$allProps.size()]) ## предполагаем, что это поле идёт после всех остальных (если понадобится)
        #foreach($i in [1..$visibleProps.size()])
          #set($prop = $visibleProps[$i - 1])
          #set($val = $row[$allProps.indexOf($prop)])
          <td>
            #if($prop.name == 'URI' && !$stringtool.isBlank($suffixUri))
              <span id="$suffixUri"></span>
            #end

            #if(($prop.name == 'sip_sdmx.hasAgencyLabel' || $prop.name == 'sip_code_agency.hasAgencyLabel'|| $prop.name == 'sip-sdmx.hasAgencyLabel') && !$stringtool.isBlank($val))
              #set($entries = $jsontool.fromString($val))
              #foreach($entry in $entries)
                #set($agencies = $entry.get('agencies'))
                #set($label   = $entry.get('label'))
                #set($line = $stringtool.join($agencies, ', '))
                **$!line**: $!label<br/>
              #end
            #elseif($prop.name == 'link' && !$stringtool.isBlank($val))
              [[$val]]
           #elseif(($prop.name == 'skos.closeMatch' || $prop.name == 'skos.broader'||$prop.name == 'skos.exactMatch' || $prop.name == 'URI') && !$stringtool.isBlank($val))
             $!val
            #else
            #set($rawXwiki = $services.rendering.parse($val,'xwiki/2.1'))
            #set($toShow = $services.rendering.render($rawXwiki,'html/5.0'))
              $toShow
            #end

            #if($prop.name == 'URI' && !$stringtool.isBlank($suffixUri))
              [[~[~[image:icon:page_white_text~]~] TTL>>||class="getTTL"]]
            #end
          </td>
        #end
      </tr>
    #end
  </tbody>
</table>
#end
#end
#end
## Вывод таблиц соответствия
#set($CorrespondenceQuery = "
  select obj.id
  from BaseObject as obj, StringProperty as typeProp
  where obj.className = '" +$itemObjName + "'
    and typeProp.id.id = obj.id
    and typeProp.id.name = 'rdf.type'
    and typeProp.value like '%xkos:Correspondence%'")
#set($CorrespondenceList = $services.query.hql($ClassificationLevelsQuery).execute())
#if($CorrespondenceList && $CorrespondenceList.size() > 0 && !$editing) ## Если есть классификационные уровни
  #set($excluded = ['lang','suffix_URI','rdf.type','rdfs.isDefinedBy','rdfs.subClassOf'])

  #set($selectParts = [])
  #set($joinParts = ["XWikiDocument as doc", "BaseObject as obj"])
  #set($whereParts = [])
  #set($discard = $whereParts.add("obj.className = '" + $itemObjName + "'"))
  #set($discard = $whereParts.add("doc.fullName = obj.name"))

  #set($allProps = [])
  #foreach($prop in $itemClass.properties)
    #set($propName = $prop.name)
    #if(!$excluded.contains($propName))
      #set($alias = $propName.replace(".", "_").replace("-", "_"))
      #set($fieldmap = $itemFields.get($prop.name))
    ## Определяем HQL-тип свойства
      #set($propertyType = $fieldmap.get("type"))
      #if($propertyType == "TextArea")
        #set($hqlPropertyClass = "LargeStringProperty")
      #else
        #set($hqlPropertyClass = "StringProperty")
      #end
      #set($discard = $selectParts.add($alias + ".value"))
      #set($discard = $joinParts.add($hqlPropertyClass + " as " + $alias))
      #set($discard = $whereParts.add($alias + ".id.id = obj.id"))
      #set($discard = $whereParts.add($alias + ".id.name = '" + $propName + "'"))
      #set($discard = $allProps.add({"name": $propName, "alias": $alias}))
    #end
  #end
## === Явно добавляем rdf.type для фильтрации ===
  #set($discard = $joinParts.add("StringProperty as rdf_type"))
  #set($discard = $whereParts.add("rdf_type.id.id = obj.id"))
  #set($discard = $whereParts.add("rdf_type.id.name = 'rdf.type'"))
  #set($discard = $whereParts.add("rdf_type.value like '%xkos:Correspondence%'"))
## === Фильтрация по наличию URI и label ===
  #set($discard = $whereParts.add("URI.value is not null"))
  #set($discard = $whereParts.add("label.value is not null"))
## === Вручную добавляем в запрос суффикс URI ===
  #set($discard = $selectParts.add("suffix_URI.value"))
  #set($discard = $joinParts.add("StringProperty as suffix_URI"))
  #set($discard = $whereParts.add("suffix_URI.id.id = obj.id"))
  #set($discard = $whereParts.add("suffix_URI.id.name = 'suffix_URI'"))
## === Сборка запроса ===
  #set($hql = "select " + $stringtool.join($selectParts, ", ") + " from " + $stringtool.join($joinParts, ", ") + " where " + $stringtool.join($whereParts, " and "))
## === Выполнение запроса ===
  #set($results = $services.query.hql($hql).execute())
## === Фильтруем видимые поля по непустым значениям ===
  #set($visibleProps = [])
  #foreach($i in [1..$allProps.size()])
    #set($hasValue = false)
    #if($results && $results.size() > 0)
      #foreach($row in $results)
        #set($val = $row[$i - 1])
        #if($val && !$stringtool.isBlank($val.toString()))
          #set($hasValue = true)
          #break
        #end
      #end
    #end
    #if($hasValue)
      #set($discard = $visibleProps.add($allProps[$i - 1]))
    #end
  #end
## === Таблица ===
## === Вывод Название: Значение ===
#if($results && $results.size() > 0 && $visibleProps && $visibleProps.size() > 0)
<hr>
<h4>Correspondence Tables</h4>
  #foreach($row in $results)
  <dl>

    ## === 1) СНАЧАЛА ВЫВОДИМ label ===
    #foreach($prop in $visibleProps)
      #if($prop.name == "label")
        #set($value = $row[$allProps.indexOf($prop)])
        <dt><label>$!escapetool.xml($value)</label></dt>
      #end
    #end

    ## === 2) Теперь выводим остальные свойства ===
    #foreach($prop in $visibleProps)
      #if($prop.name != "xkos.madeOf" && $prop.name != "label")

        #set($fieldmap = $itemFields.get($prop.name))

        ## Название поля
        #if($prop.name == "URI")
          #set($title = "URI")
        #elseif($fieldmap.get($xcontext.locale.toString()))
          #set($title = $fieldmap.get($xcontext.locale.toString()))
        #else
          #set($title = $fieldmap.get($services.localization.defaultLocale.toString()))
        #end

        ## Значение
        #set($value = $row[$allProps.indexOf($prop)])

        <dd><strong>$title</strong>: $!escapetool.xml($value)</dd>

      #end
    #end

  </dl>
  #end
#end
  #set($CountQuery = "
  select count(obj.id)
  from BaseObject as obj, StringProperty as typeProp
  where obj.className = '" +$itemObjName + "'
    and typeProp.id.id = obj.id
    and typeProp.id.name = 'rdf.type'
    and typeProp.value like '%xkos:ConceptAssociation%'
")

#set($countList = $services.query.hql($CountQuery).execute())
#if($countList && $countList.size() > 0)
  #set($count = $countList.get(0))
#else
  #set($count = 0)
#end

  <p><strong>Total items:</strong> $count </p>
#set($ChildQuery = "select DISTINCT doc.fullName, doc.title from Document doc, doc.object(SKMS.SemanticClassifiers.Code.ClassifierPageTypeClass) obj where doc.fullName like '"+$doc.fullName+"%' and obj.PageType like 'group' and doc.fullName like '%Correspondence%' order by doc.title ASC ")
#set($GroupPages = $services.query.xwql($ChildQuery).execute())
#if($GroupPages && $GroupPages.size() > 0)
  #if(!$editing)
    #foreach($GroupPage in $GroupPages)
      #if($GroupPage && $GroupPage.size() >= 2)
        * [[$GroupPage[1]>>$GroupPage[0]]]
      #end
    #end
  #end
#end
#end
##вывод полей элементов справочника
#if($xcontext.action == 'edit')
  <h5>$services.localization.render("skms.classifiers.SemanticClassifiersSheet.text.elemcontent")</h5>
#end
    #if (($xcontext.action == 'edit' && $xcontext.locale.toString()==$services.localization.defaultLocale.toString()) && ($GroupPages.size() < 1 || ($GroupPages.size() > 0 && $itemObjects.size() <1))) ##Кнопка добавить элемент в режиме редактирования
    <br/>
    <p class="text-right"><a class="actionBtn" id="addElement" href="#" >
    $services.icon.renderHTML("add")
    $services.localization.render("skms.classifiers.SemanticClassifiersSheet.btn.addelem")
    </a></p>
  #end
#foreach($item in $itemObjects)
  #set($discard = $vdoc.use($item))
  #set($elemID      = $item.getNumber())
  #if($xcontext.action == 'edit')
    #set($fieldmap=$itemFields.get("label"))
      <dt><strong>#if($fieldmap.get($xcontext.locale.toString()))$fieldmap.get($xcontext.locale.toString())#else$fieldmap.get($services.localization.defaultLocale.toString())#end</strong></dt>
      <dd><label>$vdoc.display('label')</label>
         <a class="actionBtn delElement" href="#" data-variant-id=$elemID>
          $services.icon.renderHTML("delete")
          $services.localization.render("skms.classifiers.SemanticClassifiersSheet.btn.delelem")
        </a>
      </dd>
##else
##<dt><label>$vdoc.display('label')</label></dt>
  #end
  #foreach ($prop in $itemClass.properties)
    #set($fieldmap=$itemFields.get($prop.name))
##if(!$editing && $stringtool.isBlank($item.getValue($prop.name)))
##если поле пустое, то не выводим его при просмотре
##else
    #if($editing)
      #if(!$stringtool.equalsIgnoreCase($prop.name, 'lang') &&!$stringtool.equalsIgnoreCase($prop.name, 'URI') && !$stringtool.equalsIgnoreCase($prop.name, 'label') && !$stringtool.equalsIgnoreCase($prop.name, 'suffix_URI') && !$stringtool.equalsIgnoreCase($prop.name, 'rdf.type'))
        <dd><strong>#if($fieldmap.get($xcontext.locale.toString()))$fieldmap.get($xcontext.locale.toString())#else$fieldmap.get($services.localization.defaultLocale.toString())#end</strong>:
        #if($xcontext.locale.toString() == $services.localization.defaultLocale.toString() and $fieldmap.get("international")=="1")
          $vdoc.display($prop.getName())</dd>
        #elseif($fieldmap.get("international")=="1" and $xcontext.locale.toString() != $services.localization.defaultLocale.toString())
          $vdoc.display($prop.getName(),'view')</dd>
        #else
           $vdoc.display($prop.getName())</dd>
        #end
      #end
      #if($stringtool.equalsIgnoreCase($prop.name, 'URI'))
        <dd><strong>$prop.prettyName</strong>:
          $vdoc.display($prop.getName(),"view")</dd>
      #end
      #if($xcontext.action == 'edit')
        #if($stringtool.equalsIgnoreCase($prop.name, 'suffix_URI') || $stringtool.equalsIgnoreCase($prop.name, 'rdf.type'))
          <dd><strong>#if($fieldmap.get($xcontext.locale.toString()))$fieldmap.get($xcontext.locale.toString())#else$fieldmap.get($services.localization.defaultLocale.toString())#end</strong>:
          #if($xcontext.locale.toString() == $services.localization.defaultLocale.toString() and $fieldmap.get("international")=="1")
            $vdoc.display($prop.getName())</dd>
          #elseif($fieldmap.get("international")=="1" and $xcontext.locale.toString() != $services.localization.defaultLocale.toString())
            $vdoc.display($prop.getName(),'view')</dd>
          #else
            $vdoc.display($prop.getName())</dd>
          #end
        #end
      #end
    #end
  #end
#end
  </dl>
  <input type="hidden" value="$escapetool.xml($itemObjName)" id="itemObjName"/>
  <input type="hidden" value="$xcontext.locale.toString()" id="currentLocale"/>
  <input type="hidden" value="$escapetool.xml($vdoc)" id="pageName"/>
  <div id="pageContainer"/>
</div>
{{/html}}]
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:186)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:60)
 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:311)
 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:396)
 at org.xwiki.display.internal.DocumentContentAsyncExecutor.execute(DocumentContentAsyncExecutor.java:269)
 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:1407)
 at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:1543)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1493)
 at com.xpn.xwiki.doc.XWikiDocument.displayDocument(XWikiDocument.java:1462)
 at com.xpn.xwiki.api.Document.displayDocument(Document.java:821)
 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:853)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:808)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:800)
 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 java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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:217)
 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.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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:853)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:808)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:800)
 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 java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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:217)
 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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)
 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:846)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:832)
 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:2569)
 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:650)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:338)
 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:108)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
 at org.eclipse.jetty.ee8.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1151)
 at org.eclipse.jetty.ee8.servlet.ServletHolder.handle(ServletHolder.java:640)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1374)
 at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:122)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:61)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:177)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.eclipse.jetty.ee8.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:175)
 at org.eclipse.jetty.ee8.servlet.FilterHolder.doFilter(FilterHolder.java:171)
 at org.eclipse.jetty.ee8.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1348)
 at org.eclipse.jetty.ee8.servlet.ServletHandler.doHandle(ServletHandler.java:454)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.handle(ScopedHandler.java:119)
 at org.eclipse.jetty.ee8.security.SecurityHandler.handle(SecurityHandler.java:497)
 at org.eclipse.jetty.ee8.nested.HandlerWrapper.handle(HandlerWrapper.java:108)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextHandle(ScopedHandler.java:183)
 at org.eclipse.jetty.ee8.nested.SessionHandler.doHandle(SessionHandler.java:519)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextHandle(ScopedHandler.java:181)
 at org.eclipse.jetty.ee8.nested.ContextHandler.doHandle(ContextHandler.java:881)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextScope(ScopedHandler.java:152)
 at org.eclipse.jetty.ee8.servlet.ServletHandler.doScope(ServletHandler.java:423)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextScope(ScopedHandler.java:150)
 at org.eclipse.jetty.ee8.nested.SessionHandler.doScope(SessionHandler.java:503)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.nextScope(ScopedHandler.java:150)
 at org.eclipse.jetty.ee8.nested.ContextHandler.doScope(ContextHandler.java:826)
 at org.eclipse.jetty.ee8.nested.ScopedHandler.handle(ScopedHandler.java:117)
 at org.eclipse.jetty.ee8.nested.ContextHandler.handle(ContextHandler.java:1424)
 at org.eclipse.jetty.ee8.nested.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1290)
 at org.eclipse.jetty.ee8.nested.HttpChannel.dispatch(HttpChannel.java:623)
 at org.eclipse.jetty.ee8.nested.HttpChannel.handle(HttpChannel.java:460)
 at org.eclipse.jetty.ee8.nested.ContextHandler$CoreContextHandler$CoreToNestedHandler.handle(ContextHandler.java:2385)
 at org.eclipse.jetty.server.handler.ContextHandler.handle(ContextHandler.java:1060)
 at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:181)
 at org.eclipse.jetty.server.Server.handle(Server.java:182)
 at org.eclipse.jetty.server.internal.HttpChannelState$HandlerInvoker.run(HttpChannelState.java:662)
 at org.eclipse.jetty.server.internal.HttpConnection.onFillable(HttpConnection.java:418)
 at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:322)
 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:99)
 at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:478)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:441)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:293)
 at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:201)
 at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:311)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:979)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1209)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1164)
 at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [sdmx:SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet]
 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:235)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:168)
 ... 206 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 suffix_URI.value from XWikiDocument as doc, BaseObject as obj, StringProperty as rdf_type, StringProperty as suffix_URI where obj.className = 'Models.NACE_Rev_2_1.ItemPage' and doc.fullName = obj.name and rdf_type.id.id = obj.id and rdf_type.id.name = 'rdf.type' and (rdf_type.value like '%xkos:ClassificationLevel%' or rdf_type.value like '%skos:Collection%') and URI.value is not null and label.value is not null and suffix_URI.id.id = obj.id and suffix_URI.id.name = 'suffix_URI' order by xkos_depth.value] at sdmx:SKMS.SemanticClassifiers.Code.SemanticClassifiersSheet[line 143, column 66]
 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.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.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)
 ... 207 more
Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [select suffix_URI.value from XWikiDocument as doc, BaseObject as obj, StringProperty as rdf_type, StringProperty as suffix_URI where obj.className = 'Models.NACE_Rev_2_1.ItemPage' and doc.fullName = obj.name and rdf_type.id.id = obj.id and rdf_type.id.name = 'rdf.type' and (rdf_type.value like '%xkos:ClassificationLevel%' or rdf_type.value like '%skos:Collection%') and URI.value is not null and label.value is not null and suffix_URI.id.id = obj.id and suffix_URI.id.name = 'suffix_URI' order by xkos_depth.value]
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:222)
 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:278)
 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 at java.base/java.lang.reflect.Method.invoke(Method.java:580)
 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)
 ... 217 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:207)
 ... 226 more
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: 'URI.value' [select suffix_URI.value from com.xpn.xwiki.doc.XWikiDocument as doc, com.xpn.xwiki.objects.BaseObject as obj, com.xpn.xwiki.objects.StringProperty as rdf_type, com.xpn.xwiki.objects.StringProperty as suffix_URI where obj.className = 'Models.NACE_Rev_2_1.ItemPage' and doc.fullName = obj.name and rdf_type.id.id = obj.id and rdf_type.id.name = 'rdf.type' and (rdf_type.value like '%xkos:ClassificationLevel%' or rdf_type.value like '%skos:Collection%') and URI.value is not null and label.value is not null and suffix_URI.id.id = obj.id and suffix_URI.id.name = 'suffix_URI' order by xkos_depth.value]
 at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138)
 at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
 at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
 at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:757)
 at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114)
 at org.hibernate.engine.spi.SessionDelegatorBaseImpl.createQuery(SessionDelegatorBaseImpl.java:576)
 at com.xpn.xwiki.internal.store.hibernate.legacy.LegacySessionImplementor.createQuery(LegacySessionImplementor.java:127)
 at com.xpn.xwiki.internal.store.hibernate.legacy.LegacySessionImplementor.createQuery(LegacySessionImplementor.java:48)
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.createQuery(HqlQueryExecutor.java:257)
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.lambda$execute$0(HqlQueryExecutor.java:208)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
 ... 228 more
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: 'URI.value' [select suffix_URI.value from com.xpn.xwiki.doc.XWikiDocument as doc, com.xpn.xwiki.objects.BaseObject as obj, com.xpn.xwiki.objects.StringProperty as rdf_type, com.xpn.xwiki.objects.StringProperty as suffix_URI where obj.className = 'Models.NACE_Rev_2_1.ItemPage' and doc.fullName = obj.name and rdf_type.id.id = obj.id and rdf_type.id.name = 'rdf.type' and (rdf_type.value like '%xkos:ClassificationLevel%' or rdf_type.value like '%skos:Collection%') and URI.value is not null and label.value is not null and suffix_URI.id.id = obj.id and suffix_URI.id.name = 'suffix_URI' order by xkos_depth.value]
 at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74)
 at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:282)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192)
 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144)
 at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:112)
 at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73)
 at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162)
 at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:636)
 at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:748)
 ... 235 more