To  Hide  Page Title tab

 in your component if you have only one page and you want hide tab name so uncheck below check in component level


 then you can use HTML for page Title

To get project information based on object name :

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B

WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME

To get Component interface information

Use below SQL to get CI assigned permission list

SELECT * FROM PSAUTHBUSCOMP WHERE BCNAME='CI Name'

To get object migrated from which project

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME

Multiple SQL statements in one single Application Engine SQL Action

%Execute([/])
statment1{; | /}
statment2{; | /}
statment3{; | /}

ex:

%Execute(/)
statment1
/
statement2
/
statement3
/

How to find PeopleSoft current bundle number

use below Sql in DESCR place you can get bundle number info

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like '%BUNDLE%' ORDER BY 3 DESC

Some good peoplesoft blogs :

http://peoplesofthrms.blogspot.in

To restrict  Component Interface to execute the code

using  %CompIntfcName  you'll get component interface name

If %CompIntfcName <> "Your CI name" then
Messagebox("Message")
End-If

The above condition will restrict the message box from executing when the People code is executed from your CI.