<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:9pt" ><div dir="ltr" >To me, it feels like you need to do the search the other way around.</div>
<div dir="ltr" > </div>
<div dir="ltr" >Firstly, from the target of say "4 weekdays ago", work out how many real days ago that was.</div>
<div dir="ltr" >Then use that as a criteria in mmfind or mmapplypolicy.</div>
<div dir="ltr" > </div>
<div dir="ltr" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div class="socmaildefaultfont" dir="ltr" ><div dir="ltr" style="margin-top: 20px;" ><div style="margin-top: 10px;" ><div style="font-family: sans-serif; font-size: 8pt; margin-bottom: 0.0001pt; line-height: normal;" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><span style="font-size:1.000em;" >Daniel</span></font></font></div>
<div style="font-family: sans-serif; font-size: 8pt; margin-bottom: 0.0001pt; line-height: normal;" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font></div>
<div style="margin-bottom: 0.0001pt; line-height: normal;" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font color="#19A9F3" size="3" style="font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; font-size: 8pt; outline: none;" >_________________________________________________________</font><br style="outline: none;" ><font color="#808080" face="Arial" size="2" ><span style="caret-color: #121212;" ><b>Daniel Kidger Ph.D.</b></span></font></font></font></div>
<div style="margin-bottom: 0.0001pt; line-height: normal;" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><span style="outline: none; caret-color: #121212; font-size: 10.666666984558105px;" ><font color="#121212" ><span style="outline: none; font-size: 7.5pt;" >IBM Technical Sales Specialist</span></font></span></font></font></div>
<div style="margin-bottom: 0.0001pt; line-height: normal;" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><span style="outline: none; caret-color: #121212; font-size: 10.666666984558105px;" ><font color="#121212" ><span style="outline: none; font-size: 7.5pt;" >Spectrum Scale, Spectrum Discover and IBM Cloud Object Storage<br style="outline: none;" ><br style="outline: none;" ><span style="font-size:0.857em;" >+</span></span></font></span><span style="font-size:0.857em;" ><span style="outline: none; font-family: sans-serif;" ><font color="#5f5f5f" ><span style="outline: none; font-family: Verdana, Geneva, sans-serif;" ><span style="outline: none;" >44-(0)7818 522 266 </span></span></font></span></span><br style="outline: none; caret-color: #121212; font-family: sans-serif; font-size: 10.666666984558105px;" ><span style="outline: none; font-family: sans-serif; font-size: 10.666666984558105px;" ><font color="#5f5f5f" ><span style="outline: none; font-family: Arial, Helvetica, sans-serif;" ><span style="outline: none; font-size: 8pt;" >daniel.kidger@uk.ibm.com</span></span></font></span> </font></font>
<table border="0" style="border-collapse: collapse; border-color: rgb(105, 105, 105); table-layout: fixed; width: 360px; word-wrap: break-word;" > <tbody> <tr> <td style="overflow: hidden; width: 66px; border-color: rgb(105, 105, 105);" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><a href="https://www.youracclaim.com/badges/687cf790-fe65-4a92-b129-d23ae41862ac/public_url" target="_blank"><img alt="" src="https://images.youracclaim.com/size/110x110/images/c49300ae-d13e-4071-90f5-15f59d199c9e/IBM_Volunteers_Gold_v6.png" style="width: 90px; height: 90px;" ></a></font></font></td> <td style="overflow: hidden; width: 66px; border-color: rgb(105, 105, 105);" ><a href="https://www.youracclaim.com/badges/8dac4bc0-7b3a-4035-b127-daec8dce9200"><img src="https://images.youracclaim.com/size/110x110/images/c3275eba-a1a8-4602-ab7a-c857877733fb/Virtual_Collabortor_Enterprise.png" style="width: 90px; height: 90px;" ></a></td> <td style="overflow: hidden; width: 66px; border-color: rgb(105, 105, 105);" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><a href="https://www.youracclaim.com/badges/8153c6a7-3e02-40be-87ee-24e27ae9459c/public_url" target="_blank"><img alt="" src=" https://images.youracclaim.com/size/110x110/images/f2539224-f951-46b4-b376-b88f21c2be98/IBM-Selling-Certification---Level-1.png" style="width: 90px; height: 90px;" ></a></font></font></td> <td style="overflow: hidden; width: 66px; border-color: rgb(105, 105, 105);" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><a href="https://www.youracclaim.com/badges/78197e2c-4277-4ec9-808b-ad6abe1e1b16/public_url" target="_blank"><img alt="" src="https://images.youracclaim.com/size/110x110/images/ea52b12f-97ac-4e72-8d24-b0ced8054e7d/Storage_Technical_V1.png" style="width: 90px; height: 90px;" ></a></font></font></td> </tr> </tbody></table><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font>
<div><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font></div><font face="Verdana,Arial,Helvetica,sans-serif" size="2" ><font face="Verdana,Arial,Helvetica,sans-serif" size="2" > </font></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<div dir="ltr" > </div>
<div dir="ltr" > </div>
<blockquote data-history-content-modified="1" dir="ltr" style="border-left:solid #aaaaaa 2px; margin-left:5px; padding-left:5px; direction:ltr; margin-right:0px" >----- Original message -----<br>From: Jonathan Buzzard <jonathan.buzzard@strath.ac.uk><br>Sent by: gpfsug-discuss-bounces@spectrumscale.org<br>To: gpfsug-discuss@spectrumscale.org<br>Cc:<br>Subject: [EXTERNAL] Re: [gpfsug-discuss] gpfsug-discuss Digest, Vol 108, Issue 18<br>Date: Sat, Jan 30, 2021 10:29<br>
<div><font face="Default Monospace,Courier New,Courier,monospace" size="2" >On 30/01/2021 00:31, Owen Morgan wrote:<br><br>[SNIP]<br><br>><br>> I would prefer to stay in the bounds of the SQL policy rule setup as<br>> that is the framework I have created and started to implement..<br>><br>In general SQL is Turing complete. Though I have not checked in detail I<br>believe the SQL of the policy engine is too.<br><br>I would also note that SQL has a whole bunch of time/date functions.<br><br>So something like<br><br>define(offset, 4)<br>define(day, DAYOFWEEK(CURRENT_TIMESTAMP))<br>define(age,(DAYS(CURRENT_TIMESTAMP)-DAYS(ACCESS_TIME)))<br>define(workingdays,<br>CASE<br>WHEN day=1<br>THEN offest+1<br>WHEN day=6<br>THEN offset<br>WHEN day=7<br>THEN offset+1<br>ELSE<br>offset+2<br>)<br><br>/* delete all files from files older than 4 working days */<br>RULE purge4 DELETE<br> WHERE (age>workingdays) FOR FILESET dummies<br><br><br>JAB.<br><br>--<br>Jonathan A. Buzzard Tel: +44141-5483420<br>HPC System Administrator, ARCHIE-WeSt.<br>University of Strathclyde, John Anderson Building, Glasgow. G4 0NG<br>_______________________________________________<br>gpfsug-discuss mailing list<br>gpfsug-discuss at spectrumscale.org<br><a href="http://gpfsug.org/mailman/listinfo/gpfsug-discuss" target="_blank">http://gpfsug.org/mailman/listinfo/gpfsug-discuss</a> </font><br> </div></blockquote>
<div dir="ltr" > </div></div>Unless stated otherwise above:<BR>
IBM United Kingdom Limited - Registered in England and Wales with number 741598. <BR>
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU<BR>
<BR>