Question

1
Replies
26
Views
AnandrajT7685 Member since 2018 7 posts
Estes
Posted: September 4, 2020
Last activity: October 29, 2020

Date function in Materialized Views for SQL Server

We plan to leverage the  materialized view for the end user portal that joins data from two tables.  Is there a way to use Date Time functions in the query of the materialized view to pull past week's data? We are using SQL Server as DB.  There are certain restrictions around using GetDate() function in SQL Server, is there any other way to implement this from Pega perspective?

Pega Platform Reporting Other Industry
Share this page LinkedIn