Good morning!
This relates to 'on premise' 200c Professional v12 -
When the menu has been customised, does anyone know how to find the target of a menu item ?
I can't find anything in the Company or Config databases, and there's nothing helpful in the .dif file from the menu export.
I've even asked our Partner, and they don't know !
Any advice gratefully recieved ...
Kind regards,
Paul.
I have an SQL query that produces an indented list of the whole menu. Run it against the 200c configuration database. It can be used as the data source for an Excel sheet to allow for searching/filtering etc. It's also useful for finding the Feature Group (eg. Basic, Advanced) for a particular menu option.
This is a sample of the output in Excel:
This is the query:
with TreeMenu(NavigationItemID,lvl,keyvalue) as (
Select NavigationItemID,0,cast(PositionIndex+1 as bigint ) From tblNavigationItem where ParentNavigationItemID is null
union all
select tblNavigationItem.NavigationItemID,TreeMenu.lvl+1,cast(TreeMenu.keyvalue*1000+tblNavigationItem.PositionIndex+1 as bigint)
from tblNavigationItem Inner Join TreeMenu on tblNavigationItem.ParentNavigationItemID=TreeMenu.NavigationItemID)
select TreeMenu.lvl,space(treemenu.lvl*2) + tblNavigationItem.Title,tblNavigationItem.NavigationItemID,ParentNavigationItemID ,t1.FeatureGroupName ,t1.FeatureTargetAction
from TreeMenu inner join tblNavigationItem on TreeMenu.NavigationItemID=tblNavigationItem.NavigationItemID
left outer join (SELECT distinct tblFeatureTarget.FeatureTargetGUID, tblFeatureTarget.FeatureTargetAction,tblFeatureGroup.FeatureGroupName
FROM tblFeatureTarget INNER JOIN
tblFeature ON tblFeatureTarget.FeatureTargetFeatureID = tblFeature.FeatureID INNER JOIN
refFeatureGroupFeature ON tblFeature.FeatureID = refFeatureGroupFeature.FeatureID INNER JOIN
tblFeatureGroup ON refFeatureGroupFeature.FeatureGroupID = tblFeatureGroup.FeatureGroupID) as t1 on tblNavigationItem.TargetGUID=t1.FeatureTargetGUID
order by cast(TreeMenu.keyvalue as varchar )