I have old MVA values (1,2,3) and I want to add also (4,5) and I don’t understand how to merge them with updateing: I would like for example just it:
update indexName set mva_field_ids=(mva_field_ids as old_values, 4,5 ) + where id=1648;
Is it possible by manticore?
No, it’s not possible, you have to specify the whole new list in UPDATE.
Ok, thanks for answare. But I think it possible would make life easier.
No doubt. As well as UPDATE idx SET a=a+1
, but it’s not supported yet too.