Menu Maintenance

Kinetic ERP
1

I want to do a SQL query on menu maintenance to get the form to use field to see which forms have been changed to kinetic and which are still on classic.

I couldn’t find the data in the ice.menu defaultformtype field.

2

I’ve been using something like the following…

select a.MenuID, a.MenuDesc, a.ParentMenuID, a.Sequence, 
	case a.DefaultFormType when 'Default' then 'User Choice' when 'Url' then 'Kinetic' when 'Base' then 'Classic' end as MenuType 
from Ice.Menu a 
where /*ParentMenuID = 'XAMN1000' 
	and*/ MenuID not in('DNM0000', 'SSMN0000', 'AEEstMng')