Here is an SQL that will list all dates for a particular month.
Few posts back, I wrote about how to call a UNIX script from PeopleCode. In this post, I will provide a sample code to call a UNIX script from an SQR program.
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.
Peoplesoft provides a function called as "DateTimeToLocalizedString" to change date from one format into another.
Following is syntax used to achiev this.
DateTimeToLocalizedString({datetime | date}, [Pattern])
Param1 : Variable of Date Datatype
Param2 : Date format which you want for example "dd/MM/yyyy".
If you have Param1 of type string then use function "DateValue" to convert that string to Date.
This SQL returns details of the fields like DESCRIPTION, FIELD TYPE, FIELD LENGTH, KEY TYPE , REQUIRED, DEFAULT VALUE, EDIT , PROMPT TABLE etc.
in CI just replace ': COMPONENT INTERFACE NAME' with your Component Interface Name
Hi all,
This is very basic Doc for Workflow. Even those who has not worked yet on workflow can go through and start making their own.
This helped me a lot.
I hope this is really goonne help.
Regards
Nitin Khanna
This code i have got Ittool box.com.
It is very useful. we usually have requirement when we want to hide some translate values from translate field on page for some business reason.
In this case we can use AddDropDownItem(),ClearDropDownItem().
The fact is that we need to use ClearDropDownItem() function first. so whatever values it had will be cleared out and then we will have to manually add values using AddDropDownItem().
Here is an example on the page activate PeopleCode.
An SQL that will identify permission lists along with permission lists description assigned to a specific component.
It is relatively easy to select current_timestamp from dual and get current date time in your time zone. But things get a little more complicated when you want to get date and time in a different time zone. Here is how you can accomplish that:
A function to call UNIX and/or shell script from PeopleCode.
The Exec command has changed in PT8.4x so the above function will be:
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 16 weeks ago
2 years 21 weeks ago
2 years 21 weeks ago
2 years 22 weeks ago
2 years 23 weeks ago
2 years 23 weeks ago
2 years 25 weeks ago
2 years 27 weeks ago
2 years 30 weeks ago
2 years 36 weeks ago