Add existing settype to product search

[former_member193040]

Hello,

I want to add the existing field basecategory (Relation ProductBaseCategory) to the product search in CRM.

1. I have appended the new field to the search structure CRMT_PRIL_QUERY_ADVSEARCH_PROD

2. I have created an entry in table CRMC_PRSEA_ATTR for my field. I have found the settype COMM_PR_CATEGORY which sounds suitable. But I cannot see the Attributes belonging to it. Does anybody know what is the attributes naem for the base category?

Or has anybody another idea how I can add the BaseCategory to the Search Parameters?

Thanks,

Anne

[Former Member · Accepted solution]

Hi Anne,

In the standard you can already search products with the category, why do you want to add the base category ?

Regards,

Benoît

[Former Member · Accepted solution]

Hello Anne,

Search based on Category ID is already present in standard.

But I doubt, enhancing the search with base hierarchy would work since this field is not covered

within existing standard search. ( I mean by underlying APIs).

Best Regards,

Shanthala.

[former_member193040]

Thanks for your hints,

we have checked the standard field category and it is true, with this search field, we can also search for the base category. Thanks for this hint!