vue oracle:donnees non affichees

2009-02-18
2013-05-02
  • mounassib anasse

    Bonjour,
    j'ai créé une vue oracle,et lors d'appel de cette vue sur compiere pour faire une edition d'impression
    j'ai bien les colonnes mes sans données,alors que la vue me retourne bien des données sur oracle
    voici la vue :
    CREATE OR REPLACE VIEW RV_GRAND_LIVRE (AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, 
    UPDATED, UPDATEDBY,GL_CATEGORY_ID,DATEACCT,FACT_ACCT_ID, AMTACCTDR, AMTACCTCR, SOLDE)
    AS 
    SELECT f.ad_client_ID as AD_CLIENT_ID,f.ad_org_ID as AD_ORG_ID,f.IsActive AS IsActive, f.Created AS Created, f.CreatedBy AS CreatedBy, f.Updated AS Updated, f.UpdatedBy AS UpdatedBy,j.GL_CATEGORY_ID as GL_CATEGORY_ID,f.DATEACCT as DATEACCT,
    f.FACT_ACCT_ID as FACT_ACCT_ID,f.AMTACCTDR as AMTACCTDR,f.AMTACCTCR as AMTACCTCR,(f.AMTACCTDR - f.AMTACCTCR) as SOLDE
    FROM fact_acct f 
    inner join gl_category j on ( j.ad_client_ID = f.ad_client_ID) 

    merci de me proposer une solution

     
    • albert

      albert - 2009-02-19

      SELECT f.ad_client_ID as AD_CLIENT_ID,f.ad_org_ID as AD_ORG_ID,f.IsActive AS IsActive, f.Created AS Created, f.CreatedBy AS CreatedBy, f.Updated AS Updated, f.UpdatedBy AS UpdatedBy,j.GL_CATEGORY_ID as GL_CATEGORY_ID,f.DATEACCT as DATEACCT, 
      f.FACT_ACCT_ID as FACT_ACCT_ID,f.AMTACCTDR as AMTACCTDR,f.AMTACCTCR as AMTACCTCR,(f.AMTACCTDR - f.AMTACCTCR) as SOLDE 
      FROM fact_acct f 
      inner join gl_category j on (
      j.ad_client_ID = f.ad_client_ID and
      j.GL_CATEGORY_ID = f.GL_CATEGORY_ID
      )

      Please check last line ,, thanks,,,
      any question call me again...

      Skype: Adempiere/Compiere

       
    • mounassib anasse

      even i put this line it stil dont work in compiere,in oracle i can see datas but not in compiere when i want to create print editor

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks