Correcting the display of catalogue structure (version 7.6)

Case

When the catalogue structure is changed, catalogues cannot be opened.

Solution

In the FolderManagerViewModel  schema of the ProductOmnichannel  package, make the following changes in the getCatalogueLevelItemsSelect()  method:

repace the strings:

select.addColumn("Id", "ColumnPathValueId");
var column = select.addColumn("Name", "ColumnPathValueName");

for the following:

select.addMacrosColumn(Terrasoft.QueryMacrosType.PRIMARY_COLUMN, "ColumnPathValueId");
var column = select.addMacrosColumn(Terrasoft.QueryMacrosType.PRIMARY_DISPLAY_COLUMN,  "ColumnPathValueName");

These changes are needed because a customer might not have the [Name] field in the object at all.

Necessary conditions:

Verison 7.6