Unifier (MOSC)

MOSC Banner

Possible to limit query results to current user?

in Unifier (MOSC) 3 commentsAnswered

Need to create a custom report that returns only the records associated with the user running the report --- WITHOUT having the user select themselves from a query parameter. This could be accomplished with a query parameter that the user selects a report runtime; however, the use case is that the user should not be able to run the report for any other user.

Is there a view or parameter that can be used to get the current user and use that in the data view for the report?

Example: A BP has a user picker - each record is associated with a user (this is not associated workflow or record ownership). When I go into run a "my records" report, the results should only include the records where my user is populated in the user picker.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center