How to get table code of a lookup table?

[Former Member]

I have the lookup field name in the main table. How can I get the table code of the lookup table with MDM Java API?

Thanks:-)

[Former Member · Accepted solution]

Hi,

Please try given below steps :

1. Get Field Properties of particular field from Repository schema with the method

getField(java.lang.String tableCode, java.lang.String fieldCode)

2. Type cast this field properties to lookupField properties.

3.Get Lookup Table ID from lookup properties getLookupTableId() method.

for example : ((LookupFieldProperties)currentproperties).getLookupTableId()

4. Get Lookup table code from the Table ID retrieved in step 3.

Hope it helps.

Regards,

Neeharika

[Former Member · Accepted solution]

Hi Neeharika,

It works! Thanks a million:-)