Query directly from Lookup [QualifiedFlat] multivalued table

[Former Member]

Hi,

Can i directly query from Lookup [QualifiedFlat] multivalued table without using the main table to traverse to the Lookup [QualifiedFlat] multivalued table?

to put it simple:

select * from table1;

here table1 is a Lookup [QualifiedFlat] multivalued table

Thanks,

gayatri

[Greg_Austin · Accepted solution]

Gayatri,

If you query a qualified table you can only get the possible values of the non qualifier field, not all qualified table records in MDM. To get the actual data from the qualified table you have to go through a main table record.

-Greg

[Former Member]

Can you give me a code snippet to get all data from a Qualified Lookup table?

Thanks,

Gayatri

[Former Member]

Hi,

You can query from any table, using the Java API's, it doesnot matter whether it is a main table or a lookup table.

Thanks,

Priya.