How to create a validation that access another MDM-Table?

[Former Member]

Hello,

is it possible to create a validation (using MDM expression editor) in one table that checks if the entered value is contained in another table? How can i access data in another table?

Please provide me with a code-sample of the expression if you have a solution!

Thanks a lot!

Marc

[Former Member · Accepted solution]

Hi Marc,

it is currently not possible to check for values in other tables within different repositories (main tables).

If you want to check for values in flat lookup tables, use the "Fields" menu in the expression editor. You will get sth like this:

IS_NULL(Category.Item)

whereas "Category" could be a lookup table (flat, hierarchy, taxonomy) and "Item" a field in it.

Checking across qualified lookup tables is only possible in a very restricted manner.

Hope that helps.

Christian

[Former Member · Accepted solution]

Thank you Christian!

To understand you right: it is only possible - in a validation in Table A - to access/check other tables that are defined in table A as lookup fields!? I cannot reference another flat table (within a repository) if this table ("B") has no relation/link to table A (via a lookup-field in table A referencing table B) defined!?

Kind Regards,

Marc

[Former Member · Accepted solution]

That is correct. You will have to use the Java API to achieve this.