Issue on Alerts v3

Yan
2008-08-21
2013-05-02
  • Yan
    Yan
    2008-08-21

    Hi,

    I try to implement alerts in compiere3 but i got an issue.
    My goal is to have the next date of the accounting process.

    I copy settings from v261 where it works fine.

    Sql SELECT : name as "Client :", TO_CHAR(datenextrun,'DD/MM/YYYY HH24:MI:SS') as "Next Run :"
    Table : C_AcctProcessor
    Sql FROM : c_acctprocessor

    In v3, it gave me this error message :

    Select=(SELECT name as "Client :", TO_CHAR(datenextrun,'DD/MM/YYYY HH24:MI:SS') as "Next Run :" FROM c_acctprocessor WHERE .AD_Client_ID IN(1000001,0) AND .AD_Org_ID IN(1000001,0))
    ORA-00936: missing expression

    The problem is that Compiere add a "." in front fo AD_Client_ID and AD_Org_ID

    Have you got an idea from where it could come ?

    Thanks,
    Regards,

    Yan

     
    • Jorg Janke
      Jorg Janke
      2008-08-21

      Select the table in the drop down or indicate that it is not a compiere table. fixed in current version

       
      • Yan
        Yan
        2008-08-25

        I have selected the table in the drop down list but i got the same error.

        I try to copy an existing alert (Open Items over 100 days) and still have the "." in front of AD_Client_ID and AD_Org_ID.

        What do you mean by "current version" ? 3.1 ?

        Regards,

        Yan

         
    • DMF
      DMF
      2008-09-01

      Hi,

      I carry on his thread to ask if anybody know how to use "Action SQL Set Processing" and "Action SQL Row Processing" fields ?
      What is their purpose ?

      thanks,

      DMF