<div dir="ltr">Hi,<div><br></div><div>you can use: <i>CmsObject.getRelationsForResource(CmsResource resource, CmsRelationFilter filter)</i> with <span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><i>CmsRelationFilter.SOURCE</i></span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"> as parameter. If the result is empty, no other resource references the given resource.</span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Stephan</span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-02-23 17:59 GMT+01:00 always.work.in.progress always.work.in.progress <span dir="ltr"><<a href="mailto:always.work.in.progress@gmail.com" target="_blank">always.work.in.progress@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>hi all...</div><div>i am using Opencms 10.0.0/mysql set up in multisite environment (<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;font-size:12.8px;background-color:rgb(255,255,255);float:none;display:inline">apache + mod proxy)</span></div><div>i manage some large web sites plenty of xml contents/pages that link to many internal uploaded pdf/images files/other filetypes etc..</div><div>often these files that are not needed anymore, are unlinked from related xml contents, but unfortunately they are not deleted from the vfs workplace and so become "forgotten".. :(</div><div><br></div><div>Is there an internal workplace jsp script or function in order to find these "orphan files" ?</div><div>i mean files that are present in vfs but not anymore linked from any xml contents page;</div><div><br></div><div>these files waste db blob space and the mysql database under opencms is growing in size and getting more and more big..</div><div><br></div><div>i tried to look for a way to do that but i've never found a similar function/method..</div><div>it would be really useful in order to locate these unused  files and delete them.</div><div><br></div><div>thanks in advance for your reply.</div><div><br></div><div>bye.</div><div><br></div><div><br></div></div>
<br>______________________________<wbr>_________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev" rel="noreferrer" target="_blank">http://lists.opencms.org/cgi-<wbr>bin/mailman/listinfo/opencms-<wbr>dev</a><br>
<br>
<br>
<br>
<br></blockquote></div><br></div>