Table Value Sets Issue
Hi all,
I have created a Value Set with Table Validation Type. In the where clause I have referred to another attribute in the same attribute group as seen below:
WHERE CLAUSE : lookup_type = 'TEST_CK_LOOKUP1' AND enabled_flag = 'Y' AND LANGUAGE = 'US' AND LOOKUP_CODE = :$ATTRIBUTEGROUP$.CK_ORDER_TYPE
Although when I open the Product Workbench this validation works like a charm, when I open the Item Catalog page then the following error message appears:
I have created a Value Set with Table Validation Type. In the where clause I have referred to another attribute in the same attribute group as seen below:
WHERE CLAUSE : lookup_type = 'TEST_CK_LOOKUP1' AND enabled_flag = 'Y' AND LANGUAGE = 'US' AND LOOKUP_CODE = :$ATTRIBUTEGROUP$.CK_ORDER_TYPE
Although when I open the Product Workbench this validation works like a charm, when I open the Item Catalog page then the following error message appears:
Error while processing attribute group CK Attribute Group 1.
Contact system administrator to check all related attribute definitions,
especially value set queries.
Are here any ideas why the validation only works in Workbench and not in Item Catalog?
Are here any ideas why the validation only works in Workbench and not in Item Catalog?
0