How can i integrate the p_start_date and p_end _date parameters into this query in BI Publisher?
Summary:
I need to integrate the p_start_date and p_end _date parameters into this query in BI Publisher
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
When i mean p_start_date and p_end _date parameters,
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
papf.PERSON_NUMBER,
ppnf_ler.full_name AS Learner_Name,
wlif_tl.name AS Course_Name,
COUNT(DISTINCT CASE
WHEN TRUNC(warf.assigned_on_date) BETWEEN TO_DATE('2024-01-01', 'YYYY-MM-DD')
AND TO_DATE('2025-04-01', 'YYYY-MM-DD')
Tagged:
0