Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 01:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded