select cm.name from char_menu cm
where cm.name not in (select fc.charMenu from field_char fc where fc.charMenu=cm.name )
and cm.name not in (select sf.charMenu from actlink_set_char sf where sf.charMenu=cm.name)
It tells any menu that cannot be found attached directly to or field and any menu that is not being dynamically attached to a field during an Active Link Change process.
On 8/11/06, L. J. Head <[EMAIL PROTECTED]> wrote:
ARSDoc tells you that...I think that ARInside does as well
L. J. Head
Software Engineer
Remedy Approved Consultant
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of T. Dee
Sent: Friday, August 11, 2006 8:28 AM
To: arslist@ARSLIST.ORG
Subject: Question: Menus not being used
Does anyone know a utility that can tell me which menus are not being used
or should I say menus no longer associated with a form?
Thanks!
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
