Ask Question
Help Others
Home › PeopleSoft › PeopleSoft SQL Snippets

Is Component Attached to a Menu?

Fri, 01/25/2008 - 2:24pm — Lepa
Your rating: None Average: 5 (1 vote)

This SQL will help you find the menus a specific component is attached to.

-- Is component attached to a menu?
-- List all the Menus that have a specific component
SELECT * FROM PSMENUITEM menu
WHERE pnlgrpname = :component_name
AND ITEMTYPE <> 8;

Bookmark/Search this post with:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Thu, 07/08/2010 - 12:40am
#1
anithan's picture
anithan
User offline. Last seen 5 hours 36 min ago. Offline
Joined: 06/29/2010
Posts: 20
Re: Is Component Attached to a Menu?

hi,
i am new to people soft
why u have given in where condition 8
it may be a silly question for u
but as a beginer its helpfull to me
so please help me...
thanks in advance
anitha

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
3 + 5 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.