Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Thomas Mortagne
Deleted attachments management is not very efficient (mostly for the
reasons described in http://jira.xwiki.org/browse/XWIKI-8910.), AFAIK
when you display it it's loaded in memory with it's whole history so
if you have several versions it might take quite some memory.

On Tue, Sep 16, 2014 at 10:14 AM, Moens Patrick
 wrote:
> Between 50-70 mo
>
> But its before trying to deleted them. It's when I open the deleted 
> attachments page.
>
> -Original Message-
> From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
> Sent: mardi 16 septembre 2014 10:11
> To: XWiki Users
> Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments
>
> Well the one you tries should me enough for most use case.
>
> How big is the attachment you are trying to delete ? Your issue might be 
> related to http://jira.xwiki.org/browse/XWIKI-8910.
>
> On Tue, Sep 16, 2014 at 9:59 AM, Moens Patrick 
>  wrote:
>> Thanks Thomas,
>>
>> I'll look that because we have made some test with those JAVAOPTS parameters 
>> for massive import :
>>
>>
>> -Xms3072m
>> -Xmx3072m
>> -XX:MaxPermSize=256M
>>
>> Seems not good , I f you have any idea to optimize memory  tuning for
>> Xwiki 6.1 on solaris (tomcat oracle) with around 100-150 concurent
>> users
>>
>>
>> I'll try with those one  :
>> -d64
>> -Xms1536m
>> -Xmx1536m
>> -XX:MaxPermSize=200M
>> -XX:+UseConcMarkSweepGC
>> -Dfile.encoding=utf-8
>> -Dxwiki.data.dir=/opt/curia/wikidgt/data/
>> -Doracle.net.tns_admin=${TNS_ADMIN}
>>
>>
>>
>> -Original Message-
>> From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas
>> Mortagne
>> Sent: mardi 16 septembre 2014 9:43
>> To: XWiki Users
>> Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments
>>
>> The issue is " java.lang.OutOfMemoryError: Java heap space". Hard to say 
>> what exactly is the cause, you might want to look at 
>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.
>>
>> On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick 
>>  wrote:
>>> Hello ,
>>>
>>> I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
>>> oracle).
>>>
>>> When I try to see the deleted attachments from the 'xwiki list of documents 
>>> ', I got this error (see bellow).
>>>
>>> There is just 2 deleted doc in the table;
>>>
>>> I tried to save the page with admin account (who has programming rights), 
>>> still  the same.
>>>
>>> Any idea?
>>>
>>> BR
>>>
>>> Patrick
>>>
>>>
>>>
>>>
>>> Failed to execute the [velocity] macro
>>> org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
>>> Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
>>>   {{warning}}This document requires programming rights and needs to
>>> be saved by an administrator of this Wiki{{/warning}} #else
>>> #set($dateFormat = '  d, HH:mm')
>>> #if(!$request.list)
>>> $xwiki.ssx.use('XWiki.DeletedAttachments')##
>>> $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ##
>>> #set($columns = ['datt.filename', 'datt.docName', 'datt.date',
>>> 'datt.deleter', 'actions']) #set($columnProperties = {
>>> 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
>>> 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
>>> 'datt.date'  : { 'type' : 'date', 'filterable' : false },
>>> 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
>>> 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' 
>>> : false }
>>>   })##
>>> #set($options = {
>>> 'url'   : "$xwiki.getURL('XWiki.DeletedAttachments', 
>>> 'view', 'list=1&xpage=plain&outputSyntax=plain')",
>>>'callback'  : 'XWiki.index.trash.attachments.displayEntry',
>>> 'translationPrefix' : 'platform.index.trashAttachments.'
>>>   })##
>>> ##
>>> ##
>>> #

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Between 50-70 mo

But its before trying to deleted them. It's when I open the deleted attachments 
page.

-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: mardi 16 septembre 2014 10:11
To: XWiki Users
Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

Well the one you tries should me enough for most use case.

How big is the attachment you are trying to delete ? Your issue might be 
related to http://jira.xwiki.org/browse/XWIKI-8910.

On Tue, Sep 16, 2014 at 9:59 AM, Moens Patrick  
wrote:
> Thanks Thomas,
>
> I'll look that because we have made some test with those JAVAOPTS parameters 
> for massive import :
>
>
> -Xms3072m
> -Xmx3072m
> -XX:MaxPermSize=256M
>
> Seems not good , I f you have any idea to optimize memory  tuning for 
> Xwiki 6.1 on solaris (tomcat oracle) with around 100-150 concurent 
> users
>
>
> I'll try with those one  :
> -d64
> -Xms1536m
> -Xmx1536m
> -XX:MaxPermSize=200M
> -XX:+UseConcMarkSweepGC
> -Dfile.encoding=utf-8
> -Dxwiki.data.dir=/opt/curia/wikidgt/data/
> -Doracle.net.tns_admin=${TNS_ADMIN}
>
>
>
> -Original Message-
> From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas 
> Mortagne
> Sent: mardi 16 septembre 2014 9:43
> To: XWiki Users
> Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments
>
> The issue is " java.lang.OutOfMemoryError: Java heap space". Hard to say what 
> exactly is the cause, you might want to look at 
> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.
>
> On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick 
>  wrote:
>> Hello ,
>>
>> I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
>> oracle).
>>
>> When I try to see the deleted attachments from the 'xwiki list of documents 
>> ', I got this error (see bellow).
>>
>> There is just 2 deleted doc in the table;
>>
>> I tried to save the page with admin account (who has programming rights), 
>> still  the same.
>>
>> Any idea?
>>
>> BR
>>
>> Patrick
>>
>>
>>
>>
>> Failed to execute the [velocity] macro
>> org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
>> Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
>>   {{warning}}This document requires programming rights and needs to 
>> be saved by an administrator of this Wiki{{/warning}} #else 
>> #set($dateFormat = '  d, HH:mm')
>> #if(!$request.list)
>> $xwiki.ssx.use('XWiki.DeletedAttachments')##
>> $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ## 
>> #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
>> 'datt.deleter', 'actions']) #set($columnProperties = {
>> 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
>> 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
>> 'datt.date'  : { 'type' : 'date', 'filterable' : false },
>> 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
>> 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
>> false }
>>   })##
>> #set($options = {
>> 'url'   : "$xwiki.getURL('XWiki.DeletedAttachments', 'view', 
>> 'list=1&xpage=plain&outputSyntax=plain')",
>>'callback'  : 'XWiki.index.trash.attachments.displayEntry',
>> 'translationPrefix' : 'platform.index.trashAttachments.'
>>   })##
>> ##
>> ##
>> ##
>> {{html wiki="true" clean="false"}}
>> 
>> #livetable('attachmentTrash' $columns $columnProperties $options) 
>>  {{/html}}
>>
>> {{html wiki="true" clean="false"}}
>> 
>>
>>   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
>> DeletedAttachment as datt').execute().get(0))
>>   #if($deletedAttachments == 0)
>>
>>
>> {{info}}$services.localization.render('platform.index.trashAttachment
>> s
>> Empty'){{/info}}
>>
>>   #else
>>   #macro(displayDeletedAttachment $id)
>> #set($datt = $xwiki.getDeletedAttachment("$id"))
>> #set($originalAt

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Thomas Mortagne
Well the one you tries should me enough for most use case.

How big is the attachment you are trying to delete ? Your issue might
be related to http://jira.xwiki.org/browse/XWIKI-8910.

On Tue, Sep 16, 2014 at 9:59 AM, Moens Patrick
 wrote:
> Thanks Thomas,
>
> I'll look that because we have made some test with those JAVAOPTS parameters 
> for massive import :
>
>
> -Xms3072m
> -Xmx3072m
> -XX:MaxPermSize=256M
>
> Seems not good , I f you have any idea to optimize memory  tuning for Xwiki 
> 6.1 on solaris (tomcat oracle) with around 100-150 concurent users
>
>
> I'll try with those one  :
> -d64
> -Xms1536m
> -Xmx1536m
> -XX:MaxPermSize=200M
> -XX:+UseConcMarkSweepGC
> -Dfile.encoding=utf-8
> -Dxwiki.data.dir=/opt/curia/wikidgt/data/
> -Doracle.net.tns_admin=${TNS_ADMIN}
>
>
>
> -Original Message-
> From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
> Sent: mardi 16 septembre 2014 9:43
> To: XWiki Users
> Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments
>
> The issue is " java.lang.OutOfMemoryError: Java heap space". Hard to say what 
> exactly is the cause, you might want to look at 
> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.
>
> On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick 
>  wrote:
>> Hello ,
>>
>> I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
>> oracle).
>>
>> When I try to see the deleted attachments from the 'xwiki list of documents 
>> ', I got this error (see bellow).
>>
>> There is just 2 deleted doc in the table;
>>
>> I tried to save the page with admin account (who has programming rights), 
>> still  the same.
>>
>> Any idea?
>>
>> BR
>>
>> Patrick
>>
>>
>>
>>
>> Failed to execute the [velocity] macro
>> org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
>> Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
>>   {{warning}}This document requires programming rights and needs to be
>> saved by an administrator of this Wiki{{/warning}} #else
>> #set($dateFormat = '  d, HH:mm')
>> #if(!$request.list)
>> $xwiki.ssx.use('XWiki.DeletedAttachments')##
>> $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ##
>> #set($columns = ['datt.filename', 'datt.docName', 'datt.date',
>> 'datt.deleter', 'actions']) #set($columnProperties = {
>> 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
>> 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
>> 'datt.date'  : { 'type' : 'date', 'filterable' : false },
>> 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
>> 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
>> false }
>>   })##
>> #set($options = {
>> 'url'   : "$xwiki.getURL('XWiki.DeletedAttachments', 'view', 
>> 'list=1&xpage=plain&outputSyntax=plain')",
>>'callback'  : 'XWiki.index.trash.attachments.displayEntry',
>> 'translationPrefix' : 'platform.index.trashAttachments.'
>>   })##
>> ##
>> ##
>> ##
>> {{html wiki="true" clean="false"}}
>> 
>> #livetable('attachmentTrash' $columns $columnProperties $options)
>>  {{/html}}
>>
>> {{html wiki="true" clean="false"}}
>> 
>>
>>   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
>> DeletedAttachment as datt').execute().get(0))
>>   #if($deletedAttachments == 0)
>>
>>
>> {{info}}$services.localization.render('platform.index.trashAttachments
>> Empty'){{/info}}
>>
>>   #else
>>   #macro(displayDeletedAttachment $id)
>> #set($datt = $xwiki.getDeletedAttachment("$id"))
>> #set($originalAttachment = $datt.getAttachment())
>> #set($originalDocument = $xwiki.getDocument($datt.docName))
>> 
>>   > href="$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
>>  $originalAttachment.version, "rid=${datt.id}").replaceAll('&', 
>> '&')

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Thanks Thomas,

I'll look that because we have made some test with those JAVAOPTS parameters 
for massive import :


-Xms3072m
-Xmx3072m
-XX:MaxPermSize=256M

Seems not good , I f you have any idea to optimize memory  tuning for Xwiki 6.1 
on solaris (tomcat oracle) with around 100-150 concurent users


I'll try with those one  :
-d64
-Xms1536m
-Xmx1536m
-XX:MaxPermSize=200M
-XX:+UseConcMarkSweepGC
-Dfile.encoding=utf-8
-Dxwiki.data.dir=/opt/curia/wikidgt/data/
-Doracle.net.tns_admin=${TNS_ADMIN}



-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: mardi 16 septembre 2014 9:43
To: XWiki Users
Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

The issue is " java.lang.OutOfMemoryError: Java heap space". Hard to say what 
exactly is the cause, you might want to look at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick  
wrote:
> Hello ,
>
> I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
> oracle).
>
> When I try to see the deleted attachments from the 'xwiki list of documents 
> ', I got this error (see bellow).
>
> There is just 2 deleted doc in the table;
>
> I tried to save the page with admin account (who has programming rights), 
> still  the same.
>
> Any idea?
>
> BR
>
> Patrick
>
>
>
>
> Failed to execute the [velocity] macro
> org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
> Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
>   {{warning}}This document requires programming rights and needs to be 
> saved by an administrator of this Wiki{{/warning}} #else 
> #set($dateFormat = '  d, HH:mm')
> #if(!$request.list)
> $xwiki.ssx.use('XWiki.DeletedAttachments')##
> $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ## 
> #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
> 'datt.deleter', 'actions']) #set($columnProperties = {
> 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
> 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
> 'datt.date'  : { 'type' : 'date', 'filterable' : false },
> 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
> 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
> false }
>   })##
> #set($options = {
> 'url'   : "$xwiki.getURL('XWiki.DeletedAttachments', 'view', 
> 'list=1&xpage=plain&outputSyntax=plain')",
>'callback'  : 'XWiki.index.trash.attachments.displayEntry',
> 'translationPrefix' : 'platform.index.trashAttachments.'
>   })##
> ##
> ##
> ##
> {{html wiki="true" clean="false"}}
> 
> #livetable('attachmentTrash' $columns $columnProperties $options) 
>  {{/html}}
>
> {{html wiki="true" clean="false"}}
> 
>
>   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
> DeletedAttachment as datt').execute().get(0))
>   #if($deletedAttachments == 0)
>
> 
> {{info}}$services.localization.render('platform.index.trashAttachments
> Empty'){{/info}}
>
>   #else
>   #macro(displayDeletedAttachment $id)
> #set($datt = $xwiki.getDeletedAttachment("$id"))
> #set($originalAttachment = $datt.getAttachment())
> #set($originalDocument = $xwiki.getDocument($datt.docName))
> 
>href="$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
>  $originalAttachment.version, "rid=${datt.id}").replaceAll('&', 
> '&')">$escapetool.xml($datt.filename)
>href="$originalDocument.getURL()">$escapetool.xml($originalDocument.plainTitle)
>  ($escapetool.xml(${originalDocument.fullName}))
>   $xwiki.formatDate($datt.getDate(), $dateFormat)
>   $xwiki.getUserName($datt.getDeleter())
>   
> #if($datt.canDelete())
> class="tool delete" 
> title="$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')">$services.localization.render('platform.index.trashAttachmentsDeleteText')
> #end
>   
> 
>   #end
> ##
>   #if("$!{request.view}" == '&#

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Thanks Thomas,

I'll look that because we have made some test with those JAVAOPTS parameters 
for massive import :

-Xms3072m
-Xmx3072m
-XX:MaxPermSize=256M

Seems not good :)


I'll try with those one  :




-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: mardi 16 septembre 2014 9:43
To: XWiki Users
Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

The issue is " java.lang.OutOfMemoryError: Java heap space". Hard to say what 
exactly is the cause, you might want to look at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick  
wrote:
> Hello ,
>
> I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
> oracle).
>
> When I try to see the deleted attachments from the 'xwiki list of documents 
> ', I got this error (see bellow).
>
> There is just 2 deleted doc in the table;
>
> I tried to save the page with admin account (who has programming rights), 
> still  the same.
>
> Any idea?
>
> BR
>
> Patrick
>
>
>
>
> Failed to execute the [velocity] macro
> org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
> Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
>   {{warning}}This document requires programming rights and needs to be 
> saved by an administrator of this Wiki{{/warning}} #else 
> #set($dateFormat = '  d, HH:mm')
> #if(!$request.list)
> $xwiki.ssx.use('XWiki.DeletedAttachments')##
> $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ## 
> #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
> 'datt.deleter', 'actions']) #set($columnProperties = {
> 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
> 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
> 'datt.date'  : { 'type' : 'date', 'filterable' : false },
> 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
> 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
> false }
>   })##
> #set($options = {
> 'url'   : "$xwiki.getURL('XWiki.DeletedAttachments', 'view', 
> 'list=1&xpage=plain&outputSyntax=plain')",
>'callback'  : 'XWiki.index.trash.attachments.displayEntry',
> 'translationPrefix' : 'platform.index.trashAttachments.'
>   })##
> ##
> ##
> ##
> {{html wiki="true" clean="false"}}
> 
> #livetable('attachmentTrash' $columns $columnProperties $options) 
>  {{/html}}
>
> {{html wiki="true" clean="false"}}
> 
>
>   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
> DeletedAttachment as datt').execute().get(0))
>   #if($deletedAttachments == 0)
>
> 
> {{info}}$services.localization.render('platform.index.trashAttachments
> Empty'){{/info}}
>
>   #else
>   #macro(displayDeletedAttachment $id)
> #set($datt = $xwiki.getDeletedAttachment("$id"))
> #set($originalAttachment = $datt.getAttachment())
> #set($originalDocument = $xwiki.getDocument($datt.docName))
> 
>href="$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
>  $originalAttachment.version, "rid=${datt.id}").replaceAll('&', 
> '&')">$escapetool.xml($datt.filename)
>href="$originalDocument.getURL()">$escapetool.xml($originalDocument.plainTitle)
>  ($escapetool.xml(${originalDocument.fullName}))
>   $xwiki.formatDate($datt.getDate(), $dateFormat)
>   $xwiki.getUserName($datt.getDeleter())
>   
> #if($datt.canDelete())
> class="tool delete" 
> title="$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')">$services.localization.render('platform.index.trashAttachmentsDeleteText')
> #end
>   
> 
>   #end
> ##
>   #if("$!{request.view}" == '')
> #set($queryParams = '')
>   #else
> #set($queryParams = "view=$!{escapetool.url($request.view)}")
>   #end
>   #set($paginationParameters = {
> 'totalItems' : $services.query.hql('select count(datt.id) from 
&

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Thomas Mortagne
The issue is " java.lang.OutOfMemoryError: Java heap space". Hard to
say what exactly is the cause, you might want to look at
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick
 wrote:
> Hello ,
>
> I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
> oracle).
>
> When I try to see the deleted attachments from the 'xwiki list of documents 
> ', I got this error (see bellow).
>
> There is just 2 deleted doc in the table;
>
> I tried to save the page with admin account (who has programming rights), 
> still  the same.
>
> Any idea?
>
> BR
>
> Patrick
>
>
>
>
> Failed to execute the [velocity] macro
> org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
> Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
>   {{warning}}This document requires programming rights and needs to be saved 
> by an administrator of this Wiki{{/warning}}
> #else
> #set($dateFormat = '  d, HH:mm')
> #if(!$request.list)
> $xwiki.ssx.use('XWiki.DeletedAttachments')##
> $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})##
> ##
> #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
> 'datt.deleter', 'actions'])
> #set($columnProperties = {
> 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
> 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
> 'datt.date'  : { 'type' : 'date', 'filterable' : false },
> 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
> 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
> false }
>   })##
> #set($options = {
> 'url'   : "$xwiki.getURL('XWiki.DeletedAttachments', 'view', 
> 'list=1&xpage=plain&outputSyntax=plain')",
>'callback'  : 'XWiki.index.trash.attachments.displayEntry',
> 'translationPrefix' : 'platform.index.trashAttachments.'
>   })##
> ##
> ##
> ##
> {{html wiki="true" clean="false"}}
> 
> #livetable('attachmentTrash' $columns $columnProperties $options)
> 
> {{/html}}
>
> {{html wiki="true" clean="false"}}
> 
>
>   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
> DeletedAttachment as datt').execute().get(0))
>   #if($deletedAttachments == 0)
>
> 
> {{info}}$services.localization.render('platform.index.trashAttachmentsEmpty'){{/info}}
>
>   #else
>   #macro(displayDeletedAttachment $id)
> #set($datt = $xwiki.getDeletedAttachment("$id"))
> #set($originalAttachment = $datt.getAttachment())
> #set($originalDocument = $xwiki.getDocument($datt.docName))
> 
>href="$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
>  $originalAttachment.version, "rid=${datt.id}").replaceAll('&', 
> '&')">$escapetool.xml($datt.filename)
>href="$originalDocument.getURL()">$escapetool.xml($originalDocument.plainTitle)
>  ($escapetool.xml(${originalDocument.fullName}))
>   $xwiki.formatDate($datt.getDate(), $dateFormat)
>   $xwiki.getUserName($datt.getDeleter())
>   
> #if($datt.canDelete())
> class="tool delete" 
> title="$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')">$services.localization.render('platform.index.trashAttachmentsDeleteText')
> #end
>   
> 
>   #end
> ##
>   #if("$!{request.view}" == '')
> #set($queryParams = '')
>   #else
> #set($queryParams = "view=$!{escapetool.url($request.view)}")
>   #end
>   #set($paginationParameters = {
> 'totalItems' : $services.query.hql('select count(datt.id) from 
> DeletedAttachment as datt').execute().get(0),
> 'defaultItemsPerPage' : 15,
> 'url' : $doc.getURL('view', $queryParams)
>   })
>   #pagination($paginationParameters)
>   
> 
>   $services.localization.render('platform.index.trashAttachments.datt.filename')
>class="xwiki-livetable-display-header-text">$services.localization.render('platform.index.trashAttachments.datt.docName')
>class="xwiki-livetable-display-header-text">$services.localization.render('platform.index.trashAttachments.datt.date')
>class="xwiki-livetable-display-header-text">$services.localization.render('platform.index.trashAttachments.datt.deleter')
>class="xwiki-livetable-display-header-text">$services.localization.render('platform.index.trashAttachments.actions')
> 
> 
> #set ($query = $services.query.hql('select datt.id from DeletedAttachment 
> as datt order by datt.filename asc'))
> #foreach($item in 
> $query.setLimit($paginationParameters.itemsPerPage).setOffset($paginationParameters.firstItem).execute())
>   #displayDeletedAttachment($item)
> #end
> 
>   
>   #set($discard = $paginationParameters.put('position', 'bottom'))
>   #pagination($paginationParameters)
>   #end ## deletedAttachments != 0
> 
> {{/html}}##
> #else ## request.list
> ## 
> 
> ## T