How can we achieve INNER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN from report definitions?
From Data Access tab of Report Definition in Class joins a section
Only Include Matching Rows = INNER JOIN
Include All Rows in this class = LEFT OUTER JOIN
Include All Rows in Joined Class = RIGHT OUTER JOIN
Explain about the Page-Copy method?
The page-Copy method is used to copy the contents of a source clipboard page to a new or previously created destination clipboard page. The source page is not altered. After this method completes, the destination page contains properties copied from the source page and can contain additional properties from a model.
How to call Decision Table and Tree from an Activity?
Use the Property-Map-DecisionTable method to evaluate a decision table rule and save the result as the value of a property.
The Property-Map-DecisionTree method to evaluate a decision tree rule (Rule-Declare-DecisionTree rule type) and store the result as the value of a property.
How can we remove duplicates from a Page-List?
Byusing Pega functions like “RemoveDuplicatesInPageList”, pzRemoveDuplicatesFromListPage and pzRemoveDuplicatesFromListPage
How can we execute report definition from an activity?
By using “Call Rule-Obj-Report-Definition.pxRetrieveReportData activity and passing Parameters Param.pyReportName, Param.pyReportClass, and Param.pyPageName in Property-Set method before calling the activity
How can we parameterize a report definition from an activity?
By setting parameters in Property set method before calling “Call Rule-Obj-Report-Definition.pxRetrieveReportData activity
How can we remove duplicate rows from a report Definition?
Need to check the box (Remove duplicate rows) from Query tab of report definition rule.
For example, a report definition contains 500 max records; how to display the Top 10 records from that report, and what are the necessary steps we need to follow?
We need to do some changes in the Top/Bottom rank section in the Query tab of the report definition rule.
Display Top Ranked10rowsoverallbased property.
Explain something about Associations used in Report definitions?
Associations refer to Rule-Obj-Association instances, which are pre-defined join conditions that the developer can use in multiple reports. Class joins are specific joins that the report would need just for that report (and not reused elsewhere).
Associations are available in the report editor but class joins are not.
Use an Association rule to define a relationship between two classes based on matching values in pairs of properties. A typical use of an association rule is to enable your application to automatically add a join to a report that displays properties from both classes referenced in the association.
How can we filter the report Definition results by using a custom section on the report?
Need to create a custom filter section and reference that in the “Report Viewer” tab of Report Definition rule.
Need to select “Display Filters using custom sections” check box.
How can we open an assignment from JavaScript?
By using openAssignment(); function in JavaScript code.
How to send Email attachments?
Sending pdf attachments in the email is possible by CorrNew activity and passing parameters to AttachmentCategories.
What is the difference between Obj-Open and Obj-Open-By-Handle?
Both used to fetch a single record from the Data table.
Obj-Open use the Class Level primary key to fetch the record
Obj-Open-By-Handy uses the Instance Handler to fetch records. i.e Table level Primary key.
pzInsKey column holds the Table Level Primary and it’s the combination of “Instance Class” and “Class Level Primary Key”
Explain Spin-Off flow?
This option will found under the properties of Sub Process Shape in a Flow.
Once we check the Spin-Off option- the sub-flow and main flow will execute parallel.
Process control will move on to Sub Flow and the main flow will start once the sub-flow execution is completed.
Explain Split Join Shape:
Split Join Shape is an Advanced Shape in PRPC and used to call different Sub-process at a time.
Split Join Shape comes up with 3 different types of Join which are:
All: Main Process waits for completion of all called sub-processes
Any: Control will come back to Main Process when any one of Subprocess execution completed
Some: Based on When Condition or Number of Path count process control moves on to Main flow.
No comments:
Post a Comment