Options
  • State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 1215 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Saving Multiselect values as assignment in Configuring the connection to external data sources for object types / value lists

Falk Huth

Do you have a feature on your road map where also multi-select values can be stored within a text field using a comma-separated list of either

  • internal lookup ids,
  • external database keys (important for foreign key constrains in the database.
  • or perhaps also using the display values of the entries if it is a list with currency 3-letter-codes, for example)

How I can do that using T-SQL for MS SQL server? For that, I have found lots of easy going descriptions via google - but: why is it not supported also by M-Files?

Thank you for informing me about the roadmap plans according to that topic - and for everyone who can confirm from own projects that this would be a real advantage.

(Just drop a comment in this case - maybe also if you have a better idea or if you think this is totally useless Slight smile)

  • 0

    I haven't heard of any roadmap plans in this area, multi-select values can already be read from external databases but they must be provided on separate rows in the database which I know is not always possible. Step 22 in the user guide shows an example of a supported data structure: www.m-files.com/.../Connection_to_external_database.html

    If you have a comma-separated list in the database, currently the workaround (as your probably already know) is to read the list into a text property through the external connection and then process and store the values to the desired multi-select lookup property in an event handler.

  • 0 in reply to Joonas Linkola

    Ok that was new to me but a little bit difficult to understand from user guide. That means you have 3 database rows which are identically except the multiselect industry column. Sounds like a hack Slight smile

    The workaround is what I have already implemented but would be better to have a standard feature for that. Then you would need a separate property.





              

© M-Files Corporation 2024 | Privacy Policy