Issue on Alerts v3

  • Yan

    Yan - 2008-08-21


    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 ?



    • 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 ?



    • DMF

      DMF - 2008-09-01


      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 ?




Log in to post a comment.

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks