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.
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.
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:
