-- liquibase formatted sql
-- changeset broadleaf:content-zone-item-display-rules-migration
UPDATE BLC_CONTENT_ZONE
SET ALTERNATE_ITEM_SETS =
REGEXP_REPLACE(ALTERNATE_ITEM_SETS,
'contains(.customer\?\.customerSegmentIds)',
'containsAny(customer?.customerSegmentIds');
UPDATE BLC_CONTENT_ZONE
SET DEFAULT_ITEMS =
REGEXP_REPLACE(DEFAULT_ITEMS,
'contains(.customer\?\.customerSegmentIds)',
'containsAny(customer?.customerSegmentIds');