Scenarion for Savable DataPage For Fetching and Saving Updated Data Back to DB.

-

 Hi All,

In this Blog we will see real time implementation of Savable Data Page.


1) DEV Studio ---> Data Types --->Add data type



2) Add Data Type ---> Label = TVSerialDetails


Parent class =>  HDFC-HDFCAuto-Data

Add to ruleset = HDFCAuto


3) Go To Data Type ---> Click on Add field Button  

Add field according to requirement.


4) Now Go to Records Tab ---> Actions Button --->Edit Columns   

Make one field as Primary according to requirement.



5) In Sources Tab we can see 3 data pages automatically created by PRPC


a) Read-Only  Data Page ---> Page list structure --->Source = Report definition              

This data page does not have any parameter defined


b) Savable Data Page ----> Page Structure ---> Source = Lookup ; Data save options = Database save

Savable Data Page also have parameter, i.e primary key


c) Read-Only Data Page ---> Page Structur ---> Source = Lookup 

This data page also have parameter, i.e primary key



6) Put some test data for testing purpose


7) Now, go to case type and stage--->process--->Add Step




8) Now open Process


9) Open Connector Property dialog box, by clicking outward connector.

Now give flowaction name and click on glass icon to open/create a rule



10) In Flow Action in Layout tab,  

Page context = Use current page context

Applies to = Work Class

Section Name = ViewUpdateTVChannelDetails

click on glass icon to open/create section rule




11) Before Adding controls in section, Create a Page property in Work Class and give page definition class as Data Class





12) Now, go back to ViewUpdateTVChannelDetails Section and add controls

a) Dropdown   Property = PageName.PropertyName    Source = Data Page  D_TVSerialDetailsList


b) Embed section By name

Source => ChannelDetailsUpdate {Section}

Page context = Data Page

Context value  = D_TVSerialDetailsSavable

Parameter = pyWorkPage.TVChannelDetails.ChannelNumber










13) In ChannelDetailsUpdate {Section} add control and set property



14) Now come back to our Flow Action = ViewUpdateTVChannelDetails

Actions tab ----> Post-processing

Savable data pages

Give When rule = ChannelNumberExist 

according to requirement

Data Page = D_TVSerialDetailsSavable

Parameters = Primary.TVChannelDetails.ChannelNumber





15) Now go back to flow and save your flow.





16) Go to Case type --> Refresh ---> Save--->Save and Run

17) Select value from dropdown And update Channel name hit submit












18) Now Go to data type to check updated value



Comments

Post a Comment

Popular posts from this blog

pxSubscript and pxListSubscript Properties In Pega

-
Image
  .pxSubscript   And  .pxListSubscript Property-Set                         CasePg.Stakeholderlist Param.Indexpurpose  = "Index_Stakeholderlist" Param.InsIndexedKey  =  "CIGNA-CIGNAAUTO-WORK"+CasePg.pyID local.cnt  =   .pxListSubscript Param.IndexCount = local.cnt-1 How to get index value from pagelist?  The property pxListSubscript will hold the index of the current page that you are in How to get index in a pagelist during iteration While iterating in a pagelist Example : EmployeeList To refer to page at that point: we use EmployeeList(<CURRENT> ) But how to get the index if we have to write some condition, like at index= nth position => achieve some logic. Answer : pxListSubscript Pega provides one property called pxListSubscript which is declaratively calculated and kept at each page level in a pagelist. We can use it instead of setting  a property a...
Read more

Frequently Used Date Expressions In Pega

-
Image
 Hi, In this post I will show some of the frequently used date expressions in pega. Before starting we will see some of the date subscripts used in date functions. For Ex:   If date is =  05/March/2023 yyyy = Year => 2023 YYYY => 2023 MM = Month => 03 M=> 3 MMMM  ===> March MMM ====> Mar dd = Date/day  => 05 d ===> 5 1) pxFormatDateOnly(CurrentDateTime(),"yyyyMMdd","MM/dd/yyyy")   Here, CurrentDateTime()  = 20230618T025027.005 GMT                                                                                CurrentDateTime() returns the current date and time. pxFormatDateOnly() = Format/reformat a Date Time string using a specified parameters. Output  =  06/18/2023  { which is 18 June 2023} 2)...
Read more

pyForEachCount In Pega

-
Image
pyForEachCount holds the current iteration number. You can examine (but not alter) this value in the step.                 When processing the For loop or iterating over a Value List or Page List property, the parameter param.pyForEachCount holds the current iteration number.  You can examine (but not alter) this value in the step. For example, to iterate only over the first ten  pages or values, you can exit the iteration when pyForEachCount is greater than 10. In below example we will see how we can use pyForEachCount in data transform and set value in .pxResults.
Read more