How to use [Depth] for accessing node of hierarchy in validation?

[Former Member]

Hello Experts,

Is there any way to access hierarchy node at particular level in validation expression.

In validation, there is a provision for accessing immediate parent or child of hierarchy node.

But is there any way to navigate more than one level up or down in hierarchy?

There is a option of [Depth], but we are not able to find any documentation about how to use [Depth].

Can anybody help us on this?

Thanks & Regards,

- Shailesh.

[Former Member · Accepted solution]

Hi Shailesh,

The fields with [] are called virtual fields in expressions. Use [depth] as type length of hierrachy for example: make hierarchy with more than 1 node as given below-

Hierarchy:
1-->11-->111
2-->22
3

Now write a validation expression:

if(hierarchy.depth>1, False, True)

Execution Type: Error

Now MDM should alow you to enter only value for node 3, for 111 and 22 it wil through error message.

Let me know if you have any other reqirement.

BR,

Alok Sharma

[Former Member · Accepted solution]

Hello Alok,

Thanks for your replay...

Actually our requirement is to access parent of parent node in validation.

For example: in the first hierarchy you have given 1>11>111...

We want to access 1 (i.e. parent of parent of 111), when the current record having 111 as a selected hierarchy node.

We are wondering whether [Depth] can help us to achieve the same.

Thanks,

Shailesh.

[Former Member · Accepted solution]

Shailesh,

Unfortunately this is not supported in MDM so far. Upto 1 level its possible.

NOTE u25BAu25BA You can navigate a parent/child hierarchy relationship to
reference the records and fields only a single level up or down.

You can have a look at this note in topic "Accessing the Virtual Extended Record" in Data Manager Reference Guide.

Depth cant help in this regard as it returns an integer value.

BR,

Alok