Which entity and property applies to term type

Hi everybody,

With the aid of Ataccama support I have managed to extract the term type by using computed content. As follows.

1. Create a new entity named termTypeCC and save without having a property yet.
   Also, do not publish yet.
2. Go to the Computed Content tab.
3. For entity term add the following properties

   

4. In the Query field enter the following query
   
   select

    entity."id_i" as "id_i",

    entity."id_i" as "parent_id_i",

    $path(entity."path_i")$ as "path_i",

    entity."from_h" as "from_h",

    $type()$ as "type_i",

    d.name as "termType"

from

    (select e.$entityId$ as "id_i", e.$entityPath$ as "path_i", e.$entityFrom$ as "from_h", e.$entityType$ as "type_i" from $entity$ e) entity

$if($_plr$)$

join

    $_plr$ r on r.$_plr_id$ = entity."id_i"

$endif$

join "_MmdDictionary" d on d.id = entity."type_i"
   
   Note that termType will contain all termtypes and with the name of the entity. If you want to show just a subset of the types and with a more functional name instead of d.name as "termType" you can use
   
       case d.name when 'businessTerm' then 'Business term'

                when 'entityTerm' then 'Entity term'

                when 'attributeTerm' then 'Attribute term'

                when 'cceTerm' then 'Client critical element'

    end as "termType"

5. Rename the SQL Variable as termType as String and check the Preview Results that should look something like

   

6. Now open entity term and add a new property named termTypeCC, of type Embedded object from Object (entity) termTypeCC.
7. Add one more property named termType, of type Delegated scalar property, via property termTypeCC (of the previous step) with Delegate property termType.

8. After saving and publishing, property termType is available.