Frequently Asked Questions
Frequently Asked Questions
How to map a single source column to several M-Files properties
Posted by Ville Karinen (M-Files) on 25 March 2019 12:52 PM

Sometimes when configuring connections to external databases, you might want to use the same source column for two or more properties in M-Files. You can do this by repeating the source column in your SELECT statement. This will return several instances of the source column, so you can map the different instances to different M-Files properties.

For example, you might need to map the source database's ID column to M-Files' Object ID column, and still want to import the source database's ID value to some property on the M-Files object's metadata. In this case you would add the ID column twice to your SELECT statement and then map one of the instances to Object ID and the other instance to the desired property on the object's metadata card.

The example above is illustrated in the following image:

SELECT statement with a double source column

NOTE: If you include several instances of a given source column to your external database connection, make sure not to include more than one instance of the property in the UPDATE and INSERT INTO statements if you allow writing from M-Files to the external database. If you use the ID column in a metadata property besides the Object ID, then make sure not to include the metadata property ("Customer ID" in the example above) in your UPDATE and INSERT INTO statements.

(0 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako case