+4Hey community,
The term overview screen shows the entries of all types.
I would like to implement a ‘term type’-filter (via Application Settings → Search Configurations) on that page. For that I need to know in which entity and property term type has been implemented, but I cannot find that. We have version 13.9.4.
Does anyone have a clue?
Kind regards,
Albert de Ruiter
Best answer by Albert de Ruiter
Hi everybody,
With the aid of Ataccama support I have managed to extract the term type by using computed content. As follows.
In the Query field enter the following queryselect
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"
After saving and publishing, property termType is available.
Hi Albert,
I had a similar need for ’term types’ when I was experimenting with filters (v13.8).
We came to the conclusion that due to the ‘term type’ being an entity name, we are not able to specify a property that references multiple entity names.
+4Hi Sam (SamWrigley),
Thanks for your repsonse. From your answer I understand that ‘term type’ is an entity, but in the metamodel I cannot find such an entity. Which entity are you referring to?
Kind regards,
Albert
The entity ‘term type’ I’m referring to may be different in your environment, but it’s the name of the extended entities from “term”
For example, businessTerm and securityTerm is the name of extended entities from term that are used as term types in the Term overview page.
But if we use either of these in the search configuration as an indexed node, with the indexed property of “name”. It would not display businessTerm or securityTerm in the property filter, it will display the term names created under these term sub-types.
I’m not certain there is a way to reference an entity name in the search configuration as it’s not an explicit property of an entity.
+4Okay thanks for the clarification, I see what you mean now. I will contact support to see if they have some idea.
+3Hi
+4Hi everybody,
With the aid of Ataccama support I have managed to extract the term type by using computed content. As follows.
In the Query field enter the following queryselect
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"
After saving and publishing, property termType is available.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
