For more information, please refer to this announcement explaining best practices for getting answers to questions.
Use of SubQuery in report
Summary
Use of SubQuery in reportContent
Hello,
I need to use a subquery inside a main query to retrieve the person ID of the performance document manager.But its not allowing me to use the subquery in the usual way (like we do in database)
As I am new to the reporting,Can anybody please advise the step to use subquery inside the main query in oracle cloud pls
- Following is my sql>>
SELECT "Workforce Performance - Performance Task Status Real Time"."Performance Document Details"."Performance Document Manager Identifier",(SELECT "Workforce Performance - Performance Task Status Real Time"."Assignment Manager List Unsecured"."Manager Person Number" FROM "Workforce Performance - Performance Task Status Real Time" WHERE "Workforce Performance - Performance Task Status Real Time"."Assignment Manager List Unsecured"."Manager Identifier"="Workforce Performance - Performance Task Status Real Time"."Performance Document Details"."Performance Document Manager Identifier") s_1, FROM "Workforce Performance - Performance Task Status Real Time"