What's new in Customer Journeys?

Connect and learn more! ×
Queries for Quality Issue related relationships and workflow approvers — 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

Queries for Quality Issue related relationships and workflow approvers

Received Response
95
Views
3
Comments

Summary:

I am trying to build queries to get all the relationships and workflow approvers related to quality issues but i am getting only one of the multiple rows available.

Please help

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DISTINCT

  eiv.name       "IssueName",

  eiv.issue_number   "IssueNumber",

  eab.issue_number   "ItemName",

  ear.src_obj_type   "DestObjType",

  ear.src_obj_id    "DestObjId",

  ear.dest_obj_type   "SrcObjType",

  ear.dest_obj_id    "SrcObjId"

FROM

  enq_issue_relationship_v    ear,

  enq_issues_vl         eiv,

  enq_issues_vl         eab,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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