MIGX DB: Can i change the delimiter || with comma for listbox-multiple

[epifanios94]

Hello,

I use Migxdb and I have a Listbox (multiple select) in the input tv type. I want to ask if i can to replace the delimiter || with comma when are saving values in the database.

[bruno17]

you could. with a aftersave hooksnippet.
But you will need to convert it back to pipes before editing with a aftergetfields hooksnippet

[epifanios94]

Thanks @bruno17 for your reply. I resolve it. Also i have another problem. I tried to get the name of these ids from the “document_type_id” column using the grid table. Basically when are saving multiple values in the database, in my grid is showing only the first value.

This is my grid column:

For example the second and third row it should have and the other values.

In rendered i use this.renderChunk and in the rendereChunk template i have this:

`[[migxLoopCollection? &packageName=`document_types_categories` &classname=`Document_Type_Category` &tpl=`@CODE:{{+name_gr}}` &where=`{"id:=":"[[+document_type_id]]"}` &outputSeparator=`||`]]`

Any idea for this?

[bruno17]

if they are commaseperated now, you could try something like that

&where=`{"id:IN":[ [[+document_type_id]] ]}`

[epifanios94]

Thanks a lot Bruno. Its working.