Hi Folks, I'd like to use a SQL statement in QueryRecords like this uses the extract the last 10 chars of field and compare it to today, similar to the line below:
SELECT substring( '/index', 10, -1) as expired FROM FLOWFILE WHERE expired
<= '${now():format("yyyy-MM-dd")}'
This statement is not work and I can't find a list of QueryRecord supported
UDF or if (nd how) I can use RecordPath functions.
Is there any documentation where I can see the available UDFs?
Regards,
