CLAN
The CLAN
function returns a new set containing the IDs of the domains that, in the project taxonomy, are in a given hierarchical relationship with a given domain. In the examples below, domain labels are also shown, in brackets, to facilitate understanding.
For example, given the sample project taxonomy, consider this code:
var sportChildren = CLAN(SON,"1.01");
var judoFather = CLAN(FATHER,"1.01.2");
The first instruction defines and populates the sportChildren
with all the children of the 1.01
(martial art) domain, that is:
1.01.1 (aikido)
1.01.2 (judo)
1.01.3 (karate)
The second instruction defines and populates the judoFather
set containing the father of the 1.01.2
(judo) domain, that is:
1.01 (martial art)
The syntax is:
CLAN(relationship, domain)
where:
relationship
is the kinship between that domain and the other taxonomy domains. The values are described below.domain
is a domain ID.
Relationship | Description |
---|---|
SON |
Select all the children of the given domain. |
FATHER |
Select the father of the given domain (if it exists). |
ANCESTOR |
Select all the ancestors—for example father, grandfather, great-grandfather—of the given domain. |
DESCENDANT |
Select all children, grandchildren and lower level descendants of the given domain. |
SIBLING |
Select the siblings of the given domain; "founder" domains (see the FOUNDER relationship below) are not considered siblings even though they all share the same level. |
RELATIVE |
Select all the all the descendants of the domain's founder. |
FOUNDER |
Select only the "founder" of the given domain, that is the highest-level ancestor. |