Fort Wayne, IN
|reply to jfmezei |
Re: Indexing fields with multiple values
said by jfmezei:Depends on how you are maintaining the list. I personally would have a way to add mutiple (potentially) new values via a comma separated list, but existing records are deleted individually.
So, if one updates a record to remove 1 of 4 tags and add 2 more, what is the common way to handle this when writing the record back ? Delete all previous tags and recreate a new list of tags ? Or go through existing tags one by one, deciding if they stay or get deleted, and then add only those that were not present in the original record ?
However you could always maintain them as just a CSV list. It would just be more work as you'd have to delete existing values that weren't in the updated list. The update process wouldn't be as atomic as what individualized deletes would be, or inserting a list individually.