How to use default modifier with a list of values in a impex - hybris

Question

I wrote an impex that look like this:

UPDATE B2BCustomer; uid[unique=true];groups(uid)[mode=remove][default=group1, group2, group3]
;00003269;

In my example, the b2bCustomer 00003269 has only one of these 3 groups (the group3). The impex is executing without error, but it's not removing the group3 from the customer.

If I move the value from the default modifier to the row, it works:

UPDATE B2BCustomer; uid[unique=true];groups(uid)[mode=remove]
;00003269;group1, group2, group3

What should I do to make my first example work as expected?

Answer 1

I don't think mode=remove and default will work at the same time. default takes effect when there is no value in the data line.

If B2BCustomer has group1, group2, and group3, and you want to remove group3, do:

UPDATE B2BCustomer;uid[unique=true];groups(uid)[mode=remove]
;00003269;group3

Also, if you have multiple default values, you should group them with a single quote.

UPDATE B2BCustomer;uid[unique=true];groups(uid)[default='group1,group2,group3']
;00003269;