yangxn的专栏

Local Rowset    &RS_Level0, &RS_Level1;Local Row    &Row_Level0, &Row_Level1;Local Record    &Rec_TaskRsrc;Local Field    &Fld_PctAvail;REM Get rowset of level0 (获取0层的行集合）;&RS_Level0 = Get

Good Looking MessagesJuly 1, 2010 — digitaleagle I have often wanted to display an informational message at the top of the page.  Rather than just slap a Long Edit Box at the top of the scre

Tracing Tips and ResourcesI had an issue recently where I needed to trace a process to try to determine where a bug was occurring.  So, I decided to try to document how I could setup tracing on a

If you know the name of the component interface, you can easily find it in App Designer.  Just press Ctrl+O or File > Open and search for it by name.  But, what if you only know the name of the compon

This post is to address a question posed in one of the comments on another post.  The answer is a little too in-depth for a comment reply.  Also, I had been wanting to blog more about arrays anyway.

OperatorsRecordDescriptionPSOPRDEFNStores all operators (users) in the PeopleSoft system. Also stores their employee ID (EMPLID), encrypted password, primary permission list,

I find that you often need to create and manipulate standalone rowsets. Sometimes you can get the data for your standalone rowset from the database using the Fillmethod, however sometimes you'll wan

Tracing online People Code and SQL1. Select Trace at the login screen or add “&trace=Y” to the login URL OR - To set trace flags, click here (use this link.2. Choose the options in the tra

How to hide & unhide the grid from the page by using people code?In the given example, user wants to hide and unhide the grid from the page by selecting the check box option on the page. If the ch

导入脚本里，在import之前加SET IGNORE_DUPS;即可

Adding a Log Step to the ProgramBefore we dive into the PeopleCode, we need to add a second step to the program.  This step will come in handy for testing how the program works.  It will just simply

PeopleTools Reference: Meta-SQL %Updategenerates an update statement to change the database to match the values in the record object.ExampleLocal Record &recJob;&recJob.EMPLID.value =

During one of my PeopleTools classes, a student asked for a quick list of the PeopleTools catalog tables. Here is an attempt at this list. The list is organized by type of PeopleTools Defintion:Proj

有时候我们可能并不想使用PeopleSoft自带的Save Function，比如当Grid的数据源是一个View的时候，这时候可以使用一个Button来触发FieldChange事件，执行我们需要的业务逻辑。假设页面结构如下。   在button的FiledChange事件中加如下逻辑。Local Rowset &HDR_ROWSET, &LINE_ROWSET;Lo

在APP Engine的运行机制中，默认是从Main Section开始，根据内在的Step排列，从上往下执行的。这种机制能满足我们大多数的工作，但是面对比较复杂的逻辑时，顺序执行就会显得有些苍白无力，这时我们就可以在peoplecode中根据我们的逻辑需求，动态调用section来满足我们的逻辑了。 　　在我们的App Engine中，有如下几个Section,在Main Section

Gird在PeopleSoft中的用法是比较普遍的，通常可以用来维护一个列表，PeopleSoft自身的机制是可以对单表进行添加和修改，但在实际运用中会遇到一些特殊的情况，这时可以借助PeopleCode来达到我们的需求。如何在显示前过滤数据，使得Grid只列出符合逻辑要求的数据？在默认情况下，Grid会显示数据库表里面所有的数据，但有时我们希望只显示某一部分数据，这时我们可以在Recor

统计最近一周内入职的员工，并在主页提醒：Pagelet：  1．建立好Query：CSN_NEW_EMPL_QRY：  其中红色方框内的标准必须添上，否则会出现冗余数据，因为只是根据部门ID会找到很多部门描述，主要原因是很多SetID都复用了该DeptID，所以要确定具体的SetID。运行结果如下： 2．新建一个Pagelet向导，路径：PeopleTools>

昨天在RUN一个process的时候，发现一直重复出错，tracefile信息也没有什么有意义的提示，仔细研究了一下，发现原来是在第一次出错以后，系统把出错信息记录在PS_AERUNCONTROL了，这样当下次用同样的ID和同样的Control ID运行的时候，他会重这个表里面去比较，因而总是得到同样的出错信息。要解决这个问题，只需要将这个表的相应记录删除就可以了。 　　在db2中执行一下

在DataMove中执行以下脚本：update PSOPRDEFNset OPERPSWD = 'PS', ENCRYPTED = 0 where OPRID = 'PS'; encrypt_password PS;

A summary of the main PeopleTools security records.OperatorsRecordDescriptionPSOPRDEFNStores all operators (users) in the PeopleSoft system. Also stores their employee ID (

Have you ever tried to recreate a component interface and allow PeopleSoft to default the properties and collections? The hard part is that you have to make sure that it uses the same names as your ol

Application EngineTracingUse the -TRACE option to trace the SQL executed by an application engine program. You can do this either through the command line debugger or in the override parameters

Function Generate_xmlReport();   Local XmlDoc &xmlDoc;   Local XmlNode &root_node, &sub_node, &text_node;   Local Rowset &rs, &rs1;      Local PSXP_XMLGEN:RowSetDS &oRS;   Local PSXP_RPTDE