20 – Change fields

#set( $sql = ", BaseObject as obj, DateProperty as prop0, StringProperty as prop1
  where
    obj.name = doc.fullName and
    obj.className = '${objectSpace}.${objectClass}' and
    obj.name <> '${objectSpace}.${objectTemplate}' and
    prop0.id.id = obj.id and
    prop1.id.id = obj.id and
    prop0.name = 'end' and
    prop1.name = 'status' and
    prop1.value <> lower(prop1.value)
  order by prop0.value desc" )
##
#set( $itemFound = $xwiki.searchDocuments($sql) )
#set( $itemSortNo = $itemFound.size() )
$itemSortNo
#if( $itemSortNo > 0 )
 #set( $counter = 0 )
 #foreach( $item in $itemFound )
   #set( $itemDoc = $xwiki.getDocument($item) )
   #set( $itemObj = $itemDoc.getObject("${objectSpace}.${objectClass}") )
   #set( $discard = $itemObj.set("status",$itemDoc.getValue("status").toLowerCase()) )
* $itemDoc.getValue("status").toLowerCase()
   #set( $counter = $counter + 1 )
   #if( $counter > 50 )
     #break
   #else
      $itemDoc.save()
   #end
 #end
#end

## include reference="Talks.Environment" excludeFirstHeading="true"
#set( $sql = ", BaseObject as obj, DateProperty as prop0, StringProperty as prop1
  where
    obj.name = doc.fullName and
    obj.className = '${objectSpace}.${objectClass}' and
    obj.name <> '${objectSpace}.${objectTemplate}' and
    prop0.id.id = obj.id and
    prop1.id.id = obj.id and
    prop0.name = 'date' and
    prop1.name = 'category' and
    prop1.value <> lower(prop1.value)
  order by prop0.value desc" )
##
#set( $talkFound = $xwiki.searchDocuments($sql) )
#set( $talkSortNo = $talkFound.size() )
$talkSortNo
#if( $talkSortNo > 0 )
 #set( $counter = 0 )
 #foreach( $talk in $talkFound )
   #set( $talkDoc = $xwiki.getDocument($talk) )
   #set( $talkObj = $talkDoc.getObject("${objectSpace}.${objectClass}") )
   #set( $discard = $talkObj.set("category",$talkObj.category.toLowerCase()) )
* $talkObj.category
   #set( $counter = $counter + 1 )
   #if( $counter > 50 )
     #break
   #else
      $talkDoc.save()
   #end
 #end
#end