[jira] [Assigned] (NIFI-14076) Expression Language doesn't evaluate in the JoinEnrichment processor

["Pierre Villard (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-14076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pierre Villard reassigned NIFI-14076:
-------------------------------------

    Assignee: Pierre Villard

> Expression Language doesn't evaluate in the JoinEnrichment processor
> --------------------------------------------------------------------
>
>                 Key: NIFI-14076
>                 URL: https://issues.apache.org/jira/browse/NIFI-14076
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.20.0
>         Environment: NiFi setup on Docker
>            Reporter: Joby Joje
>            Assignee: Pierre Villard
>            Priority: Minor
>         Attachments: Dummy_Test.json
>
>
> Hey Team,
> I am trying to use an Expression Language in the JoinEnrichment processor, to generate the date on the fly when running the SQL
> SQL property on JoinEnrichment
> {code:java}
> SELECT original.*, '${now():format("yyyy-MM-dd HH:mm:ss", "Europe/Paris")}' AS Dateval FROM original WHERE record_id NOT IN (SELECT record_id FROM enrichment){code}
> This gives me an output as follows without actually evaluating the expression language
> {code:java}
> [ { "record_id" : "DUMMY--2", "mode_completion" : "2", "Dateval" : "${now():format(\"yyyy-MM-dd HH:mm:ss\", \"Europe/Paris\")}" } ]{code}
> When I run the same on QueryRecord processor
> {code:java}
> SELECT *, '${now():format("yyyy-MM-dd HH:mm:ss", "Europe/Paris")}' AS Dateval FROM FLOWFILE{code}
> I get the expression language in the right format as expected
> {code:java}
> [ { "record_id" : "DUMMY--1", "mode_completion" : "2", "Dateval" : "2024-12-04 00:29:49" }, { "record_id" : "DUMMY--2", "mode_completion" : "2", "Dateval" : "2024-12-04 00:29:49" } ]{code}
> I also tried to add the expression language to an attribute using UpdateAttribute processor and use the attribute in the JoinEnrichment  still the same issue it just prints the attribute name as it is.
> I am also sharing the sample flow.json for testing.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)