摘要：
Select PeopleTools, Utilities, Debug, Trace SQL to access the Trace SQL page.You use this page to change the SQL tracing options while you're online. Your Configuration Manager settings are not affected:Trace SQL StatementSelect to show the SQL statement.Trace SQL BindSelect to show bind values 阅读全文
posted @ 2013-10-24 14:46
Bryan chen
阅读(241)
评论(0)
推荐(0)
摘要：
Using the PeopleTools Test Utilities PageSelectselectPeopleTools,then selectUtilities,then selectDebug,then selectPeopleTools Test Utilitiesto access the PeopleTools Test Utilities page:Image: PeopleTools Test UtilitiesThis example illustrates the fields and controls on the PeopleTools Test Utilitie 阅读全文
posted @ 2013-10-24 14:46
Bryan chen
阅读(494)
评论(0)
推荐(0)
摘要：
Configuring PeopleCode TraceSelect PeopleTools, Utilities, Debug, Trace PeopleCode to access the Trace PeopleCode page.You use this page to change the PeopleCode tracing options while online. This page does not affect trace options that are set in PeopleSoft Configuration Manager. Use Trace PeopleCo 阅读全文
posted @ 2013-10-24 14:44
Bryan chen
阅读(259)
评论(0)
推荐(0)
摘要：
If you are seeing messages like this in your message log when running a process through the process scheduler and distributing the information via email:SMTP sendMail failed (server yourserver.com:25). Cannot send email to example@test.comFailed to connect to the SMTP server at :25It indicates that 阅读全文
posted @ 2013-10-24 14:43
Bryan chen
阅读(2768)
评论(0)
推荐(0)
摘要：
Oracle临时表可以说是提高数据库处理性能的好方法，在没有必要存储时，只存储在Oracle临时表空间中。希望本文能对大家有所帮助。1 、前言Oracle Logo目前所有使用 Oracle 作为数据库支撑平台的应用，大部分数据量比较庞大的系统，即表的数据量一般情况下都是在百万级以上的数据量。当然在 Oracle 中创建分区是一种不错的选择，但是当你发现你的应用有多张表关联的时候，并且这些表大部分都是比较庞大，而你关联的时候发现其中的某一张或者某几张表关联之后得到的结果集非常小并且查询得到这个结果集的速度非常快，那么这个时候我考虑在 Oracle 中创建“临时表”。我对临时表的理解：在 Ora 阅读全文
posted @ 2013-10-24 14:43
Bryan chen
阅读(349)
评论(0)
推荐(0)
摘要：
1、初始化连接。App Server从配置文件中获得connect ID和user ID进行数据库初始化连接。2、查询数据库中与安全相关的表信息connect ID被验证以后，AppServer查询PeopleTools的相关表（PSOPRDEFN，PSACCESSPRFL,PSSTATUS）,从这些表中AppServer能够获得user ID和password，symbolic ID，access ID和access password。AppServer获得这些信息后就断开数据库连接。3、App Server使用access ID重新连接数据库系统验证access ID有效以后，App Se 阅读全文
posted @ 2013-10-24 14:42
Bryan chen
阅读(653)
评论(0)
推荐(0)
摘要：
SQL that I find useful in many occasions. It will return a list of permissions that are assigned to a specific user.SELECTd.oprid,d.oprdefndesc,c.roleuser,a.rolename,a.classid,b.classdefndescFROMpsroleclass a,psclassdefn b,psroleuser c,psoprdefn dWHEREa.classid=b.classidANDc.rolename=a.rolenameANDd. 阅读全文
posted @ 2013-10-24 14:41
Bryan chen
阅读(173)
评论(0)
推荐(0)
摘要：
In aprevious postI showed you how to know what Roles are assigned to a specific user. But here is how you find out what Users are assigned to a specific Role.SELECTC.OPRID, C.OPRDEFNDESC, A.ROLENAME, A.DESCR FROMPSROLEDEFN A, PSROLEUSER B, PSOPRDEFN C WHEREB.ROLENAME=A.ROLENAME ANDC.OPRID=B.ROLEUSER 阅读全文
posted @ 2013-10-24 14:40
Bryan chen
阅读(176)
评论(0)
推荐(0)
摘要：
Here is a query that I often use to lookup Roles assigned to a specific PeopleSoft user.At run time, replace :1 with OPRID your are looking for OR user name (partial search also works).SELECTC.OPRID,C.OPRDEFNDESC,A.ROLENAME,A.DESCRFROMPSROLEDEFN A,PSROLEUSER B,PSOPRDEFN CWHEREB.ROLENAME=A.ROLENAMEAN 阅读全文
posted @ 2013-10-24 14:38
Bryan chen
阅读(181)
评论(0)
推荐(0)
摘要：
1) Run the below SQL to get the content reference name for your componentSELECTPORTAL_NAME, PORTAL_OBJNAMEASCONTENT_REFERENCE, PORTAL_LABEL, PORTAL_URI_SEG1ASMENU, PORTAL_URI_SEG2ASCOMPONENT, PORTAL_URI_SEG3ASMARKET FROMpsprsmdefn WHEREPORTAL_NAME='EMPLOYEE' ANDPORTAL_URI_SEG2=:1;-- Replace 阅读全文
posted @ 2013-10-24 14:37
Bryan chen
阅读(211)
评论(0)
推荐(0)
摘要：
Open the following defination and changed them.1. NEW_PS_LOGO (Image Type) - To change the logo.2. PORTAL_UNI_HEADER_NS4X (Html Type) - Change logo name on mouse over.3. PORTAL_UNI_HEARDER_NNS (Html Type)4. PT_BRANDING (Application Package Type) - Deals to manipulate homepage and portal look.Note:Do 阅读全文
posted @ 2013-10-24 14:36
Bryan chen
阅读(259)
评论(0)
推荐(0)
摘要：
Portal RegistryEach portal is defined by a portal registry.A portal registry has a tree-like structure in which content references are organized, classified, and registered.A portal registry contains folders and content references.In the portal registry, folders organize content references into a mu 阅读全文
posted @ 2013-10-24 14:18
Bryan chen
阅读(198)
评论(0)
推荐(0)
摘要：
Steps to configure and get Reports in Report manager.1. Enable getting Reports in Report Manager.2. Add New Folders.3. Get new files to Process Monitor.4. Assign/Create required Permission Lists/Roles to Users.5. Configure the process.6. Create a new run control id.7. Run it.8. Verify it.For any rep 阅读全文
posted @ 2013-10-24 14:11
Bryan chen
阅读(236)
评论(0)
推荐(0)
摘要：
The Rowset class contains two methods that can be used to show and hide all rows:ShowAllRows()HideAllRows()You can use these two methods to show or hide a grid on a page associated wtih a particular rowset.Simply make sure that the grid uses the main record that your rowset refers to, then refer to 阅读全文
posted @ 2013-10-24 13:56
Bryan chen
阅读(606)
评论(0)
推荐(0)
摘要：
If you ever need to create a view that selects all fields from a particular record, then you should be using the%SelectAllmeta-sql construct.Why? Because%SelectAlluses the underlying record definition to select the fields - so it will always return all fields from the underlying record, even if that 阅读全文
posted @ 2013-10-24 13:55
Bryan chen
阅读(324)
评论(0)
推荐(0)
摘要：
If you are trying to set the value of a field through PeopleCode and that field happens to beNAMEthen you will experience the following error when using the shortcutRowset(Row).Record.Field.Value approach:&rsExample(1).DERIVED.NAME.Value = "This will error";Gives the following error wh 阅读全文
posted @ 2013-10-24 13:54
Bryan chen
阅读(221)
评论(0)
推荐(0)
摘要：
A blunt, but useful method for debugging PeopleCode is to use the inbuilt "Error" function to stop processing and provide a message.Something as simple as this can be a valuable debugging tool at times:Error "The value of variable x=" | &x;Most people use message box (or the 阅读全文
posted @ 2013-10-24 13:53
Bryan chen
阅读(234)
评论(0)
推荐(0)
摘要：
The Case-When-Exists expression in Oracle is really handy. Here's an example of how to use it in a sub-select to return a status. This SQL checks for a match between thePS_PERSONandPSOPRDEFNrecords to determine the person status. The idea is that if the operator is not inPS_PERSONthen they are n 阅读全文
posted @ 2013-10-24 13:51
Bryan chen
阅读(1946)
评论(0)
推荐(0)
摘要：
Use theSearchClear()method which is part of the Field class to clear search values on a particular search key field. This is how you canresetsearch parameters specified by a user when they press theReturn to Searchbutton.You can call this using the shortcut notation:RECORD.FIELD.SearchClear();Or you 阅读全文
posted @ 2013-10-24 13:50
Bryan chen
阅读(171)
评论(0)
推荐(0)
摘要：
AddToDateis aPeopleCode built-in functionfor manipulating a date in PeopleCode.You can use it toadjustdates forwards and backwards, by a given number of years, months or days.The basic syntax is:Local date &dtExample;&dtExample = %Date;/* Get date forward 1 year, 0 months, 0 days */&dtEx 阅读全文
posted @ 2013-10-24 13:49
Bryan chen
阅读(311)
评论(0)
推荐(0)
摘要：
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 theFillmethod, however sometimes you'll want to copy from existing rowsets. This is where theCopyTomethod comes in handy.However there is one 阅读全文
posted @ 2013-10-24 13:49
Bryan chen
阅读(196)
评论(0)
推荐(0)
摘要：
If you are working with files or file attachments in PeopleCode, you will typically want to create a unique file name for each user to prevent them from overwriting each others files if files are being stored in the same folder.Here's a simple piece of PeopleCode that generates a file name prefi 阅读全文
posted @ 2013-10-24 13:48
Bryan chen
阅读(251)
评论(0)
推荐(0)
摘要：
If you ever want to conditionally count the number of times a particular condition occurs in SQL, you can do it in Oracle using thecaseandcountfunctions. Here's a simple example which counts the number of males/females stored inPS_PERSONAL_DATA.selectcount(casewhenSEX='M'then1end)asMALES 阅读全文
posted @ 2013-10-24 13:47
Bryan chen
阅读(165)
评论(0)
推荐(0)
摘要：
When trying to sort based on values that do not fit the standard ascending and descending sort logic provide by your database engine you can use the following decode() function to sort based on custom value ordering.By ordering your value list in a decode function you can sort based on the integer v 阅读全文
posted @ 2013-10-24 13:46
Bryan chen
阅读(173)
评论(0)
推荐(0)
摘要：
The following SQL identifies custom queries created in your system from thePSQRYDEFNPeopleTools table. It includes the query type (and the operator ID who owns the query if it is private).selectQRYNAMEas"Query Name",DESCRas"Query Description",CREATEOPRIDas"Created By",C 阅读全文
posted @ 2013-10-24 13:45
Bryan chen
阅读(241)
评论(0)
推荐(0)
摘要：
1. Set component changed page field property:For understanding this open a page in application designer and in the field property of one of the edit field uncheck the propertySet component Changedand save the page. Now go on the online page, make some changes in field value and save the page.What do 阅读全文
posted @ 2013-10-24 13:41
Bryan chen
阅读(472)
评论(0)
推荐(0)
摘要：
Setting a Date to Null in PeopleCodeTo set a date to null in PeopleCode either use the SetDefault() function (deprecated) or the SetDefault field methodUsing the function:SetDefault(YOUR_RECORD.DT_FIELD);Using the field method If you are in the current context:YOUR_RECORD.DT_FIELD.SetDefault();Using 阅读全文
posted @ 2013-10-24 13:40
Bryan chen
阅读(415)
评论(0)
推荐(0)
摘要：
1. Get the description of the translate value:No need to write SQLEXEC on PSXLATITEM passing fieldname and Field value. Just use LongTranslateValue property to get the long description of the field as:Local Any &VALUE;Local Field &MYFIELD;&MYFIELD = GetField();&VALUE = &MYFIELD.L 阅读全文
posted @ 2013-10-24 13:38
Bryan chen
阅读(1117)
评论(0)
推荐(0)
摘要：
SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH(REVERSE(PORTAL_LABEL), ' >- '), ' >- ')) "NAVIGATION" FROM PSPRSMDEFN PWHERE PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT'START WITH PORTAL_URI_SEG2 = 'C_PUNCH_EXPET'/*要找的component的名称*/CONNECT BY PRIOR PORTAL_P 阅读全文
posted @ 2013-10-24 13:38
Bryan chen
阅读(175)
评论(0)
推荐(0)
摘要：
在rowinit里面：/*增加打卡规则字段 陈楚豪 2013/5/7 新建*/Local Field &KL_PUNCH_RULE;&KL_PUNCH_RULE = GetRow().GetRecord(Record.SCH_SHIFT_DTL).GetField(Field.KL_PUNCH_RULE);&KL_PUNCH_RULE.ClearDropDownList();&KL_PUNCH_RULE.AddDropDownItem("01", Char(8233) | "正常上班打卡");&KL_PUNCH_R 阅读全文
posted @ 2013-10-24 13:37
Bryan chen
阅读(305)
评论(0)
推荐(0)
摘要：
Hi, Can you tell me the differences between subpage and secondary page and when to use which ? I need to display about 100 fields of our custom interface record on 4 different pages or tabs (I want the look just like the page with 3 tabs of "Workforce Admin > Personal Info > Biographical 阅读全文
posted @ 2013-10-24 13:36
Bryan chen
阅读(1046)
评论(0)
推荐(0)
摘要：
1. You will need a Long character field to hold the HTML string. You can use the delivered field HTMLAREA if there is no need to create a custom field.2. Create a new page.3. Place an HTML Area on the page.4. Assign a record and field to the HTML Area Properties page. (Note: The field used for the H 阅读全文
posted @ 2013-10-24 13:35
Bryan chen
阅读(1310)
评论(0)
推荐(0)
摘要：
From time to time you may have the need to grab the top X number of rows returned from a table. For instance “give me the 10 vendors we pay the most from the voucher table”.This might seem impossible in something like query as there is no way to stop the output after 10 rows… unless you use the SQL 阅读全文
posted @ 2013-10-24 13:29
Bryan chen
阅读(164)
评论(0)
推荐(0)
摘要：
As we all know, PeopleSoft is capable of maintaining application data in multiple languages within the same database. This feature is driven by special records called Related Language Records that store language sensitive information in all required languages other than the base language of the syst 阅读全文
posted @ 2013-10-24 13:27
Bryan chen
阅读(349)
评论(0)
推荐(0)
摘要：
今天遇到一个需求：在做页面输入验证的时候，如果用户没有输入某个项，那么这个项显示为红色，一直没头绪，也找peoplebook，发现field有一个style的方法，后来又在谷歌上找，终于找到了方法： Just to check, did you include custom stylesheet in PSSTYLEDEF? That is a key step in order to use any custom style sheet in PeopleCode or anywhere in app designer. This is what I did (a similar requi 阅读全文
posted @ 2013-10-24 13:24
Bryan chen
阅读(8052)
评论(0)
推荐(0)
摘要：
%EDITTABLE is field in the work record DERIVED. This field is generally used a prompt table for various fields. This field would mostly be set at the Page Activate Level or the main keys RowInit Level. This field can be used to dynamically change prompt tables.Consider a scenario where if an employe 阅读全文
posted @ 2013-10-24 13:21
Bryan chen
阅读(232)
评论(0)
推荐(0)
摘要：
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements.PeopleSoft 8 provides the functionality to create dynamic views. These are essentially SQL statements executed on the fly by the PeopleSoft component processor. We can use dynamic views in Pe 阅读全文
posted @ 2013-10-24 13:17
Bryan chen
阅读(654)
评论(0)
推荐(0)
摘要：
Sometimes a situation in project work arises to have a dynamic prompt table for record fields on PeopleSoft pages. In PeopleSoft itself dynamic prompt table functionality is utilized to a great extent. So, the question is:How to achieve the same??We can accomplish dynamic prompt table in 2 ways:Usin 阅读全文
posted @ 2013-10-24 13:15
Bryan chen
阅读(452)
评论(0)
推荐(0)
摘要：
Every time you access and navigate through the fields on a page in PeopleSoft there are events such as Field Edit, Field Insert, etc... that get triggered.For example if I am on a page and enter a letter in a numeric field, the field edit peoplecode can fire (to check if the value is valid) when I t 阅读全文
posted @ 2013-10-24 13:14
Bryan chen
阅读(1105)
评论(0)
推荐(0)
摘要：
You will find yourself very familier to this topic. Ok, let me ask you one question:Let me know the names of some think-time functions?I know your answer will be...Winmessage, MessageboxNow I will ask...anything else???My dear friends, before we answer we should think what exactly is the definition 阅读全文
posted @ 2013-10-24 13:13
Bryan chen
阅读(207)
评论(0)
推荐(0)
摘要：
There was a question asked on the forum on how to hid a subpage. There is no Peoplecode function to hide a subpage directly, BUT one way around that is putting the subpage in a group box and hid the group box instead. Hiding the group box will end up hiding your sub pageMake sure to follow the follo 阅读全文
posted @ 2013-10-24 13:10
Bryan chen
阅读(1573)
评论(0)
推荐(0)
摘要：
There could be different reasons why a PeopleSoft developer would like to delete a query from the database. Upgrade clean up would probably be the most common one. Here is a function you can use to get you started.Function DeleteQuery(&sQueryName As string) SQLExec("DELETE FROM PSQRYDEFN WH 阅读全文
posted @ 2013-10-24 13:09
Bryan chen
阅读(200)
评论(0)
推荐(0)
摘要：
The below function is to be used on a grid with multiple check boxes. Place the code behind a FieldChange event and users will have the option to Select or Deselect grid rows all at once.Function selectAllRows(&rs As Rowset) Local number&i; Local Row&row;For&i=1To&rs.ActiveRowCou 阅读全文
posted @ 2013-10-24 13:07
Bryan chen
阅读(479)
评论(0)
推荐(0)
摘要：
PeopleSoft stores object definitions types such as Record, Field and SQL definitions as numbers inPeopleTools meta-tables. Here is a list of what each number means with respect to its definition.Definitions for Record Object TypesThe following are stored on the PSRECDEFN table on RECTYPE field. RECT 阅读全文
posted @ 2013-10-24 13:02
Bryan chen
阅读(242)
评论(0)
推荐(0)
摘要：
A grid label is the blue (normally) colored grid header that you see on PeopleSoft pages. The grid text label can be easily edited using the Grid Properties in app designer. Once you have the grid properties box open, click the Label tab > Properties and there you can see the Label Text area.You 阅读全文
posted @ 2013-10-24 12:12
Bryan chen
阅读(245)
评论(0)
推荐(0)
摘要：
Sometimes you would want to give users the option to click a button on the page and send them back to the Portal Folder they came from, or may be couple folders back! Here is how you go about doing that.You can actually use the PeopleSoft delivered function NavPageURL to accomplish this! So, lets ge 阅读全文
posted @ 2013-10-24 12:11
Bryan chen
阅读(327)
评论(0)
推荐(0)
摘要：
Here is a piece of code to prevent duplicate data on a specific field on a page grid. You can of course modify it to check for multiple fields or even the whole row./* Check for data duplicates on a grid. */ Local Row&row1,&row2; Local number&r,&r1;&rs=GetLevel0().GetRow(1).GetRo 阅读全文
posted @ 2013-10-24 12:10
Bryan chen
阅读(300)
评论(0)
推荐(0)
摘要：
我们知道，在PeopleSoft HCM里，一般上了薪酬模块的话，都会客户化工资单页面，去匹配公司之前的工资单的报表的格式。有的时候，这个工资单页面又需要打印出来，以供员工的使用。PeopleSoft 中页面的打印，一般是用JavaScript来实现的。这里我详细叙述一下实现的步骤：1.首先要创建一个DerivedRecord ,Record Name 为Print_Record ，里面包含两个字段：一个 long 类型的 HTMLAREA ，一个Char 类型的Z_JS_PRINT.2.创建一个页面，并且在level0 上放置 HTMLAREA字段，并另外放一个ButtonButton 的属 阅读全文
posted @ 2013-10-24 12:05
Bryan chen
阅读(839)
评论(0)
推荐(0)
摘要：
PeopleSoft中对文件附件的处理都是单个文件处理的，虽然在8.52版本新增了MAddAttachment(URLDestination, DirAndFilePrefix, Prompts, &UserFileArray, &ActualSizeArray, &DetailedReturnCodeArrayName [, MaxSize [, PreserveCase[, UploadPageTitle[, AllowLargeChunks[, StopOnError]]]]]) Function 实现了一次上传多个附件的功能，但是在下载附件的时候，还是只能单个下 阅读全文
posted @ 2013-10-24 11:54
Bryan chen
阅读(697)
评论(0)
推荐(0)
摘要：
As shown in Image to create related content link in Dropdown we need to follow below steps.Assumption:Component is created and Related content setup is done.Below steps need to be done to use Related content in drop down.Step1: Adding HTML Area to page.Place a HTML area in the page to the created co 阅读全文
posted @ 2013-10-24 11:52
Bryan chen
阅读(358)
评论(0)
推荐(0)
摘要：
Here, PeopleCode sets the logic that determines when the JavaScript code will run.This is not as simple as dropping a HTML Area on your page and setting the script in PeopleCode. This is because the value in the HTML Area field remains and the JavaScript code will keep executing at subsequent page r 阅读全文
posted @ 2013-10-24 11:50
Bryan chen
阅读(413)
评论(0)
推荐(0)
浙公网安备 33010602011771号