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
);
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