2 Replies Latest reply: Mar 13, 2014 2:02 PM by Steve T.-Oracle RSS

    Refinement Issue in EQL View Join

    Michelle-Oracle

      Hi Experts,

       

      We have one EQL view(CCJoin) which is a join of two record types:

       

      ----

      DEFINE Cal1 AS SELECT
      COMMISSION_API_ID AS COMMISSION_API_ID,
      CREDIT_RECEIVER AS CREDIT_RECEIVER
      FROM Base
      WHERE RECORD_TYPE= 'CALCULATE'
      GROUP BY COMMISSION_API_ID;

       

       

      DEFINE Col AS SELECT
      RECORD_TYPE AS RECORD_TYPE ,
      COMMISSION_API_ID AS COMMISSION_API_ID ,
      COMMISSION_HEADER_ID AS COMMISSION_HEADER_ID
      FROM Base
      WHERE RECORD_TYPE= 'COLLECT'
      GROUP BY COMMISSION_API_ID;

       

       

      DEFINE CCJoin AS SELECT
      Col.RECORD_TYPE as RECORD_TYPE,
      Cal1.CREDIT_RECEIVER as CREDIT_RECEIVER,
      Col.COMMISSION_API_ID AS COMMISSION_API_ID,
      Col.COMMISSION_HEADER_ID AS COMMISSION_HEADER_ID
      FROM Col
      LEFT JOIN Cal1
      ON (Col.COMMISSION_API_ID=Cal1.COMMISSION_API_ID)

       

      ---

       

      The results look fine when there's no filter. However, when click on any credit_receiver in the results table, there's no record rendered in the refinement (I can't upload the screenshot here). Could you please let me know what I need to change here?

       

      Thanks for your help.