From: Misztur, C. <CMi...@ma...> - 2013-12-25 02:55:15
|
I am trying to get the most recent *.log file from the $files variable. However the below order by returns the following. I would expect it to be reverse, with December 25 file on top? RESULT: <ft-client:resource xmlns:ft-client="http://expath.org/ns/ft-client" name="report-20131224150738948.log" type="file" absolute-path="" last-modified="2013-12-24T20:21:00-06:00" size="29760" human-readable-size="29 KB" user="xml" user-group="external-ftp" permissions="-rw-rw-rw-"/> 3 <ft-client:resource xmlns:ft-client="http://expath.org/ns/ft-client" name="report-20131224204120839.log" type="file" absolute-path="" last-modified="2012-12-25T01:55:00-06:00" size="29760" human-readable-size="29 KB" user="xml" user-group="external-ftp" permissions="-rw-rw-rw-"/> 4 SCRIPT: let $files := <ft-client:resources-list xmlns:ft-client="http://expath.org/ns/ft-client"> <ft-client:resource name="full20131224-1507.zip" type="file" absolute-path="" last-modified="2013-12-24T20:21:00-06:00" size="11261744" human-readable-size="10 MB" user="xml" user-group="external-ftp" permissions="-rw-rw-rw-"/> <ft-client:resource name="full20131224-2041.zip" type="file" absolute-path="" last-modified="2012-12-25T01:55:00-06:00" size="11261745" human-readable-size="10 MB" user="xml" user-group="external-ftp" permissions="-rw-rw-rw-"/> <ft-client:resource name="report-20131224150738948.log" type="file" absolute-path="" last-modified="2013-12-24T20:21:00-06:00" size="29760" human-readable-size="29 KB" user="xml" user-group="external-ftp" permissions="-rw-rw-rw-"/> <ft-client:resource name="report-20131224204120839.log" type="file" absolute-path="" last-modified="2012-12-25T01:55:00-06:00" size="29760" human-readable-size="29 KB" user="xml" user-group="external-ftp" permissions="-rw-rw-rw-"/> </ft-client:resources-list> return (for $file at $position in $files/ft-client:resources-list/ft-client:resource where ends-with($file/@name/string(), '.log') order by xs:dateTime($file/@last-modified) descending return ($file,$position)) ________________________________ The contents of this message may be privileged and confidential. Therefore, if this message has been received in error, please delete it without reading it. Your receipt of this message is not intended to waive any applicable privilege. Please do not disseminate this message without the permission of the author. Please consider the environment before printing this e-mail |