WebSphere Commerce 7 | Storefront | Enable "SearchBasedNavigation" through Queries

If you have problem logging in Management Center and  still wanted to enable Search Based Navigation through the Queries then here is the approach,

Queries to check whether Search Based Navigation is enabled,
select * from emspot where name = 'SearchBasedNavigation';
select * from DMEMSPOTDEF where emspot_id in (select emspot_id from emspot where name = 'SearchBasedNavigation'); 


Queries to enable Search Based Navigation for the store,
insert into emspot(emspot_id, storeent_id, name, usagetype, up_name) values ((select max(emspot_id)+1 from emspot), 10101, 'SearchBasedNavigation', 'STOREFEATURE', 'SEARCHBASEDNAVIGATION');
insert into DMEMSPOTDEF(dmemspotdef_id, emspot_id, storeent_id, contenttype, content, optcounter, sequence)
    values (
        (select max(DMEMSPOTDEF_ID) + 1 from DMEMSPOTDEF),
        (select emspot_id from emspot where name = 'SearchBasedNavigation' and storeent_id = 10101),
        10101,
        'FeatureEnabled',
        'true',
        0,
        0
    );

No comments:

Post a Comment

My Writings........

Salesforce Enhanced Chat v2

What is Salesforce Enhanced Chat v2? Enhanced Chat v2 is a new customer interface for Enhanced Chat. V2 is optimized for modernized features...