Ok, figured out a way to do it. I noticed that QueryRecord uses Apache Calcite so I tried some of Calcite functions until I got into this statement that seems to work:
SELECT index FROM FLOWFILE WHERE CAST( SUBSTRING(index FROM CHAR_LENGTH(index)-9) AS DATE) <= CURRENT_DATE Anyhow, I would still like to know if (and how) I could use either NiFi expression or RecordPath functions in a QueryRecord statement. Thanks in advance, Em qua, 16 de out de 2019 às 14:30, Eric Chaves <[email protected]> escreveu: > 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, > >
