PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Is it possible to dynamically create the drilling URL in PS Query

edited Feb 6, 2020 4:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered

I have a query that lists all AR groups that haven't been completed and would like to use drilling URL to go directly to the component of the transaction.

The query currently has 3 unions and I can specify a different URL for each union, however the main query actually returns different group types (external items with and without error, Maintenance and Transfer groups with error as these all exist in GROUP_CONTROL).

Is it possible to dynamically populate the drilling URL based upon 1 or multiple fields in the result, without having to create a separate union for each URL I want to use?

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

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center