SQL exportation - datas in list = values

Question

Hi, 
 
 How to export from M-Files objets and sub-objects with metadatas in list and to get the value of the metada (and not the number of the item in the list :-( ) 
 
 Thanks in advance.

Joonas Linkola · Answer

The data set export creates a separate table for value lists and you need to JOIN these in your query or database view to get the actual value instead of the ID. 
 Here's an example with the Country value list, where we pick the Name column from the Country table: 
 
 Query: 
 
 Result:

SQL exportation - datas in list => values

Top Replies