Problem Definition

Filter migration with JCMA doesn't support column layout.

When customers migrate filters with JCMA, it doesn't migrate column layout.

Column layout before migration

Columns layout after migration

Suggested Solution

• Make the necessary changes in cloud and JCMA to support column layout migration.

Workaround

Manually add the columns back to the filters. Here's the SQL query to identify the columns and their orders.

SELECT SR.id,SR.filtername, CLI.fieldidentifier, CLI.horizontalposition
FROM columnlayoutitem    CLI
INNER JOIN columnlayout  CL  ON CLI.columnlayout = CL.id
INNER JOIN searchrequest SR  ON CL.searchrequest = SR.id
WHERE SR.id IN (<list_of_filter_ids>);
ORDER BY SR.id, CLI.horizontalposition;