external database, retrieving column with multiple values

We have a vault with multiple connections to external databases, using an Application Connection, where the services is M-Files OLE DB.  For our "claim" object, in the connection configuration we are retrieving a column that has multiple values that we map to a property called "Policies".  Policies is the multiselect property for the Policy object.    The values in the column retrieved are the IDs of the Policy objects. When the records pull in, if there is only one ID in the policies property, everything works great.  If there's more than one Policy ID in the column, the Policies property is just blank.  Initially we tried this with the separator between multiple values in the table we query as the pipe character -> |.  Since that didn't work, I just tried the semi-colon -> ; .  And I'm still having the same problem.  Anyone have a suggestion?

Parents Reply Children
  • Thanks for the reply.  We are already importing the Policy object with several other properties on the metadata card.  I'm unclear as to how I could import Policies into a a separate object type with all of that other metadata.

    Are you saying that I cannot have one property on the Claim object, that references multiple Policy Objects.  It seems like this should work.  But I haven't been able to get it to work.