[jira] [Created] (NIFI-11671) JoinEnrichment SQL strategy doesn't allow attributes in join statement

["Philipp Korniets (Jira)" <ji...@apache.org>]

Philipp Korniets created NIFI-11671:
---------------------------------------

             Summary: JoinEnrichment SQL strategy doesn't allow attributes in join statement
                 Key: NIFI-11671
                 URL: https://issues.apache.org/jira/browse/NIFI-11671
             Project: Apache NiFi
          Issue Type: Bug
          Components: Core Framework
    Affects Versions: 1.20.0, 1.18.0
            Reporter: Philipp Korniets


We use ForkEnrichement - JoinEnrichment pattern and want to include filtering in join SQL

{code:sql}
${test}  = 'NewValue'

SELECT original.*, enrichment.*,'${test}'
FROM original 
LEFT OUTER JOIN enrichment 
ON original.Underlying = enrichment.Underlying
WHERE enrichment.MyField = '${test}'
{code}

However this doesnt work because JoinEnrichment doesnt use evaluateAttributeExpressions




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