Re: Listing IFS objects created or changed on or after a certain date?

On 8/31/2023 3:18 PM, Steve McKay wrote:

Is there a way to get a meaningful path and object name from your SQL?

I am not saying this is a good idea; if I needed this in production I would write a UDF.

-- files after a certain date
-- finds the last slash and splits there
select
path_name,
substr(path_name, 1, (regexp_instr(path_name, '/(?:.(?!/))+$') - 1)) as "Path name",
substr(path_name, (regexp_instr(path_name, '/(?:.(?!/))+$') + 1), length(path_name) - (regexp_instr(path_name, '/(?:.(?!/))+$'))) as "File name"
from table (
qsys2.ifs_object_statistics(
start_path_name => '/dir/dir/dir',
subtree_directories => 'YES'
)
)
where object_type = '*STMF'
and Create_Timestamp > '2023-08-01';

On Thu, Aug 31, 2023 at 1:55 PM Bryan Dietz wrote:

and SQL

select * from table (qsys2.ifs_object_statistics(
start_path_name => '/your/Dir',
subtree_directories => 'YES' ) )
where Create_Timestamp > current_timestamp - XX days ;