@parulb50

To display the result of the differenceInDays function alias in a Report Definition (RD) with a table layout in Pega, follow these steps:

1. Create the Function Alias:

   • Ensure you have created the differenceInDays function alias in Pega. This function calculates the difference in days between two dates.

2. Add the Function Alias to the RD:

   • Open your Report Definition.
   • In the Columns tab, add a new column where you want to display the difference in days.
   • In the Column Source field, use the differenceInDays function alias. For example:

     @differenceInDays(.StartDate, .EndDate)
     

3. Map the Function Result to a Property:

   • Ensure that the result of the function alias is mapped to a property in your data model. This property will hold the calculated difference in days.

4. Configure the Table Layout:

   • In the section where your table layout is defined, add a column to display the property holding the result of the differenceInDays function.
   • Bind this column to the property that stores the result.

5. Update the UI:

   • Ensure your UI section is configured to display the table layout with the new column. The table layout should now show the difference in days between the specified dates.

Example

Here’s a step-by-step example:

1. Function Alias:

   • Assume you have a function alias differenceInDays that calculates the difference between two dates.

2. Report Definition:

   • In the Columns tab of your RD, add a new column:

     Column Source: @differenceInDays(.StartDate, .EndDate)
     

3. Property Mapping:

   • Ensure the result is mapped to a property, e.g., .DaysDifference.

4. Table Layout:

   • In your section, add a column to the table layout:

     Property: .DaysDifference
     

5. UI Configuration:

   • Ensure the section is updated to display the table layout with the new column.