1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Custom Reports for Outstanding Reviews with Remaining Reviewers

Discussion in 'Oracle Development General' started by karnakar, Jun 2, 2010.

  1. karnakar

    karnakar Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hi
    am trying build SQL query to get custom reports for outstanding reviews.
    I can display outstanding reviews, but how to get remaining reviewers .
    we use to write SQL queries to build custom queries for data base table.
    I could not find any workflow table in DB having field Remaining reviewers.
    can anyone suggest me how to this?




    thanks,
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Perhaps if you could share your SQL, someone can take a look and suggest how you can get what you are missing, the remaining reviewers.
     
  3. karnakar

    karnakar Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    sadik,
    my sql query is
    SELECT A.DID, A.DDOCNAME, A.DSTATUS, A.DINDATE,A.DOUTDATE
    FROM REVISIONS A, DOCMETA B
    WHERE A.DID = B.DID
    AND A.DSTATUS = 'REVIEW'


    in report i can display ddocname,id,and review date.
    i want to add one column for remaining reviewers.
    i can get workflow and work flow step that doc is in,
    but am not able to get remaining reviewers
    since there is no coloumn reminning revires in workflow tables in DB