PeopleCode Interview Questions

In the record field properties where you want the the dynamic search record -- change it to Table Edit and in the prompt table write %derived.
then
in the component prebuild code
change the search record specific to the menu.

You can use the menu override option to specify your search record for the respective menu.

1). "nosearch_vw" is a view which is not having search keys,if wee pass this view as a search record........
2). "setsearchdialogbehaviour()" by using this function in searchinit event we can bypass the search page

Use record with no search keys

join the two tables:
select E.EMPLID
from PS_EMPL_TBL E
, PS_DEPT_TBL D
where D.MGRID = E.EMPLID

You need to link two tables where MGRID = EMPLID

with the help of SQLExec, we can fetch only one row of multiple same rows.
with the help of CreateSql, we can fetch all the rows.

The main Difference Between SqlExec and CreateSql is SqlExec directly interactive with
data base but Createsql not directly interactive with the data base

Record level people code Executes in any Component containing the record field.

Component level people code Will only execute for that particular Component.

Record level peoplecode will be fired in all the components to which it is attached. This code will be fired first.ComponentRecord level peoplecode will be fired only while processing through a partic...

I guess you are asking about the migration of SQL report from one env to another (like from development to UAT)Your DBA will be required to place the SQR report manually to the target env, however, su...

If you want to send mails through Workflows, then you need to use the objects Business Process.Under a business process, you define an activity.Within an activity, you need to define steps, events and...

hi there, You can send emails in PeopleSoft using function SendMail().There are arguments for the function SendMail(&n_MailFlags_l, &s_MailTo_l, &s_MailCC_l, &s_MailBCC_l, &s_MailS...

Databse Server Select * from PSPCMPROG You will all below information 1 AA_OVRD_CRSDATA 2 STRM 12 RowInit 1 AA_OVRD_CRSDATA 2 UNITS_DIRECTED 12 RowInit 1 AA_OVRD_CRSDATA 2 UNITS_DIRECTED 12 RowInsert ...

Database Server

Events are the only way that you can associate Peoplecode to an Object. Prior to PeopleTools 8 (i.e., before Object Oriented Peoplecode evolved), Peoplecode is associated only with the Records and Men...

You can write PeopleCode (PC) in the Application Designer IDE. The PC are stored :- on the events and are triggered by them- in librairies called funclibs in PeopleSoft and called manually by the deve...

For the discussions already made, I would add one more event when a page is saved, i.e. workflow. So, Now series will be
SaveEdit,
SavePreChange,
Workflow,
SavePostChange

Workflow: Only Peoplecode related to Workflow (e.g. Approval processes and Notification purposes) are written.

Firstly, its SaveEdit followed by SavePreChange and finally SavepostChange The SaveEdit event is initiated whenever a user attempts to save the component. You can use SaveEdit PeopleCode to vali...

Also, SQLExec will open a new session on database, so if anything has been updated in Comp Buffer, will not be available in that session as COMMIT might not have happened. Also, if we have selected so...

If we need to retrieve more than one rows from the database, we can use SQL class instead of SqlExec...

To add to all this, if deferred processing is started, then if any pending FieldEdits/FieldChange are also executed before SaveEdit starts.

1.SaveEdit Event2.Save Prechange3.Workflow4.SavePost changeSaveEdit is intiated when a component is saved.It is used to validate the consistency of the data in the component fields.It is used when&nbs...

You can assign a record which is used in component buffer to a state record of Application engine.

exit(1)

We have the docancle() function, it cancle the current component when it Occurs

Record level Peoplecode perform for that perticuler record only.

Component level Peoplecode performs for all the records which are under that perticuler component.

1. The PreBuild event is initiated before the rest of the component build events. 2. This event is often used to hide or unhide pages. 3. It is also used to set component variables. 4. The PostBui...

PreBuild event is the foremost event which triggers at Component Level. If at all there is an error generated at prebuild then the component fails to load before the search itself. Where as PostBuild ...

People code supports these types of functions:

1.Build in

2.Internal

3.External people code

4.External non-people code

people Code functions are

setdefault

NOne

hide

unhide

insertimage

delimage

Getfield etc.. 

Dynamic View:This is selected to define a record definition that can be used like a view in pages and PeopleCode,but is not actually stored as a SQL view in the database.Instead, the system uses the v...

save prechange exicutes for all active rows but savepost change exicutes only once....

Hey i dont think, it will get executed for all the active rows. It will always gets executed once.

we can use the on-execute event. sometimes we can use the saveprechange event also.