You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can i integrate the p_start_date and p_end _date parameters into this query in BI Publisher?

edited May 7, 2025 1:03AM in BI Publisher Learning Center

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')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!