...
SQL for receiving unique JobProfile Ids where Match Profile inside this Job Profile has an association with the Modify Action Profile and this association has order = 0:
| Code Block |
|---|
SELECT DISTINCT
m.jsonb->>'jobProfileId' AS jobProfileId
FROM
{tenantId}_mod_di_converter_storage.match_to_action_profiles m
JOIN
{tenantId}_mod_di_converter_storage.action_profiles a ON m.jsonb->>'detailProfileId' = a.jsonb->>'id'
WHERE
a.jsonb->>'action' = 'MODIFY'
AND m.jsonb->>'order' = '0'; |