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

Restricting BIP Data Model to signed in user

Summary:

Trying to use the data model to restrict the signed in user to only their information in projects.
I'm trying to do this so that project managers when the open the report they are restricted to only seeing projects where they are listed as the project manager. We're using this subquery to call the PM:

(
SELECT
ppn.full_name
FROM
pjf_project_parties ppp,
per_person_names_f ppn
WHERE
1 = 1
AND ppa.project_id = ppp.project_id
AND ppp.resource_source_id = ppn.person_id
AND ppn.name_type = 'GLOBAL'
AND ppp.project_role_id = 1 --project manager
AND trunc(SYSDATE) BETWEEN trunc(ppp.start_date_active) AND trunc(nvl(ppp.end_date_active, SYSDATE + 1))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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