Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Property as Simple list of string values

Question
Laura Cavanaugh · Feb 15, 2017

Property as Simple list of string values

I have a property, Emails, that needs to contain a list of comma-delimited values, or "". Is there a benefit to making this property a list of %String, a Collection[list] (or however you do it), an array, or anything other than a simple %String type?

I just  need to store some values, and return these values in SQL -- so it needs to be SQL compatible.  I don't need to index the values or use individual values in the SQL statement (e.g. Select * from table where emails [ "email@co.com"  -- I don't need to do this, although maybe this would work anyway if it's of type %String).

What's the simplest way to store multiple string values, and display them in SQL? I'm just going with %String for now.

Thanks,

Laura

#Object Data Model #SQL #Caché

Source URL:https://community.intersystems.com/post/property-simple-list-string-values