Posts

Showing posts from July, 2016

Show/Hide Grid Fields in Peoplesoft Pages

Hello, You can use bellow code for this subject; Local Grid &MYGRID; Local GridColumn &COLUMN; &MYGRID = GetGrid(Page."PAGE_NAME", "GRID_NAME"); If some_conditions.. Then    &MYGRID.GetColumn("FIELD_NAME").Visible = True;    &MYGRID.GetColumn("FIELD_NAME2").Visible = True; Else    &MYGRID.GetColumn("FIELD_NAME").Visible = False;    &MYGRID.GetColumn("FIELD_NAME2").Visible = False; End-If; Loves,

Invalid Value Error in Dropdown List

Image
Hello, Sometimes,  when you use dynamic drop down list with peoplecode, having trouble with invalid value become unavoidable. When I click "Getir" button, Class Name field change invalid value even before using that button I could see true value for that field. I just only check my code that class name is changed. The value that comes in drop down list for class name doesn't pair to the value that comes from Getir button.  You can also control character length of field of drop down list. I checked values with winmessage function and I aware both of values doesn't match. That's all.  Loves,

Collapsible Group Box in Peoplesoft Pages

Image
Hello, With using collapsible Group boxes you can minimize all fields and free up space in your pages. If your page has lots of field and you can make it understandable. Before use it, you should decide to where you want to use Collapsible Group Boxes. In your page; Add a new group box which include your fields that you want to hide or show all of them. Double click head of group box and open Group Box Properties. Give a name for group box's label in Label tab.

Hide Grid Column in Peoplesoft Pages

Hello, There are lots of script that indicate how you can do that but there is a trick that you need to give a name for specified column. You can use following script; Local Grid &MYGRID; Local GridColumn &COLUMN; &MYGRID = GetGrid(Page."YOUR_PAGE_NAME", "GRID'S_NAME"); If &v_SSR_RES_MARK_OPT = "Y" Then    &MYGRID.GetColumn("COLUMN_NAME").Visible = True; Else    &MYGRID.GetColumn("COLUMN_NAME").Visible = False; End-If; Before using this script change grid's column name. To do that double click column and open page field properties. On General tab, change name of Page Field Name as you want than use this name in bellow row in your code and use it instead of COLUMN_NAME &COLUMN = &MYGRID.GetColumn("COLUMN_NAME"); PS: Do not use table/view's field name for column_name. Loves,

PLS-00371

Hello, If you get this error, there are some multiple declarations for the identifications like below code. DECLARE zip_code INTEGER; Zip_Code INTEGER; -- duplicate identifier, despite Z/z case difference BEGIN zip_code := 90120; -- raises error here because of duplicate identifiers END; / Check your declarations and delete reiterated declaration one. Loves,

Generating Page Anchor in Peoplesoft Pages

Image
Hello, If you want to use page anchor in your pages, you need to add two push button. Insert a push button in your page.  Choose hyperlink in Type tab in general properties for first push button and add record name. We will fill Related control field later. Now, you should skip it.