Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Embedded report in workspace - no table join - pass search variable? — Cloud Customer Connect
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

Embedded report in workspace - no table join - pass search variable?

Received Response
15
Views
2
Comments
edited Nov 5, 2019 4:01PM in Reporting & Analytics for B2C Service 2 comments

Summary

Pass a variable from one table into an embedded workspace report to present data from an un-joined table

Content

We have two custom objects that do NOT have a relationship:

  • Add
  • Data

Agents use the "Add" table, and view records in a workspace. 

"Data" also contains records, but this table is not joined to "Add". 

There is a field in both tables called "Pr_ID".

Is it possible to embedded a report on the "Add" workspace, that uses "Add.Pr_ID" to search for records on the "Data" table where "Data.Pr_ID" matches "Add.Pr_ID"??

I thought that using a variable (replacement value) would work i.e. variable "$id = Add.Pr_ID" and then set a filter "Data.Pr_ID = $id", but this then asks us to specify a table join.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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