Constrain PickList On Applet "Query" Mode (Doc ID 2133047.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

Constrain PickList on Applet "Query" Mode

Context:
Pick List on HLS Case that presents Account records. The Pick List is constrained by the following logic:
HLS Case.Primary Organisation Id = Account.Primary Organisation Id
When the user goes to pick an Account against a Case, the list of accounts is correctly constrained to show only those that have the same Primary Orgs.
HOWEVER, when the user enters query mode on the Case applet, users are able to invoke the Pick Applet again in order to choose an Account to use in their search criteria. In this situation, the list of Accounts is unconstrained. That is, users are able to see Accounts that belong to all Organizations - presumably because there is no relevant Case record on which to derive the constraint.

This, however, gives our users 'visibility' of data they should not be able to see, even though the result of the Case query are correct and won't return any records if a non-visible account is used in the search criteria.

Requirement:
When editing a Case record, the Account Pick List should be constrained by the Case Primary Org Id
When querying for a Case record, the Account Pick List should be constrained by the logged in user Primary Org Id

Question:
Is this possible?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.