摘要：There are a lot of events in PeopleSoft, like SaveEdit, SavePreChange, SavePostChange, etc. Each event is associated with certain objects (Page, record, or record field). Starting from People Tools 8.48, component buffer is introduced into the system, which makes the situation more complicated. For 阅读全文

摘要：In MS SQL Server, sometimes we will use queries like this to avoid the NULL value to be populated 1: SELECT ISNULL(TABLE1.COLUMN1,'IT IS NULL') 2: FROM TABLE1Similarly, in Oracle Database, we ca... 阅读全文

摘要：Many times we came across situation where we have Page name but we dont know the navigation for this page in Portal.Following SQL makes the job easy for us.Execute the following SQL in Database.SELECTREPLACE(navigation,'',' > ')"PIA Navigation",url,MENU_NAME,COMPONENT_NA 阅读全文