Can we use reference data in case statement in Computed content?

Hi ​@sumisha ,

can you please elaborate a bit more on your usecase? The computed content is limited to the content of the mmm database, which means that it can only work with the metadata inside.

Kind regards,

Anna

HI Anna, I have a table defined in One data 

I want to use this in my case statement in Context to get value in attribute field. LIke where sensitivity is PII, mark as confidential. List is very long, so I don;t want to hard code in case. Rather use this One data table or any other reference table here

My computed content looks like this: 

 with
    connection_query as 
   (select att.$attId$   as term_instance_id,
                      ti.$tiFrom$ as "term_instance_from",
                      t.$tName$   as "displayName",
                      att.$attPath$ as "tiPath"
               from $att$ att
               inner join $ti$ ti on  att.$attId$ = ti.$tiParentId$
               inner join $t$ t on ti.target_ri = t.$tId$ and
                                         (ti.target_rh is null or ti.target_rh = t.to_h)
                        join "_MmdDictionary" d on ti.$tiPath$ = d.id and d.name like '%/termInstances')
select j.term_instance_id as "id_i",
       j.term_instance_from as "from_h",
       $path("tiPath")$ as "path_i",
       $type()$ as "type_i",
       j.term_instance_id as "parent_id_i",

 case 
           when j."displayName"='DateOfBirth' then 'PII'
           when j."displayName"='EmailAddress'  then 'PII'
           when j."displayName"='FirstName'  then 'PII'
           when j."displayName"='Mobile' then 'PII'
           when j."displayName"='Landline' then 'PII'
           else ''
           end as "sensitivity",
         case 
           when j."displayName"='DateOfBirth' then '4 - High'
           when j."displayName"='EmailAddress'  then '4 - High'
           when j."displayName"='FirstName'  then '4 - High'
           when j."displayName"='Mobile' then '4 - High'
           when j."displayName"='Landline' then '4 - High'
           else ''
           end as "risk"
from connection_query j

Hi ​@sumisha ,

I understand your usecase, but this isn’t supported to my knowledge. ONE Data is a completely different module that is separated from the mmm backend database, thus it cannot see its values. I am thinking that maybe the Lists of values could be able to help you here instead of ONE Data but that has very limited functionality (no DQ monitoring etc.)

Also an alternative solution could be to use the orchestration server for this automation - you can export the ONE Data reference data into some DB and use this export in your workflow, that would populate the field via API. Together with some Notification handler you could potentially be able to make it “near real time” as well.

https://docs.ataccama.com/runtime-server/latest/workflow-and-scheduler/notifications-handler.html

Kind regards,

Anna

Thanks for getting back. Can you share some screen shot of an example of List of values mentioned in first solution?

Hi ​@sumisha, I’m closing this thread for now. If you have any follow up questions please feel free to share them in the comments or create a new post 🙋🏻‍♀️