3 Replies Latest reply on Apr 27, 2014 9:26 PM by TexasApexDeveloper

    get page item status

    Johan 12045295

      I have an application with table ISSUES. This table has a column ASSIGNEE_ID, which holds the ID of the user that has been assigned an issue.

       

      Requirement: we want to send a mail to the assignee when an issue has been created or when the assignee_id has been updated. So the process SEND_MAIL is conditional.

       

      What is the syntax for checking that the condition that page item ASSIGNEE_ID has been updated?

        • 1. Re: get page item status
          fac586

          user12045295 wrote:

          Please se update your forum profile with a real handle instead of "user12045295".

          I have an application with table ISSUES. This table has a column ASSIGNEE_ID, which holds the ID of the user that has been assigned an issue.

           

          Requirement: we want to send a mail to the assignee when an issue has been created or when the assignee_id has been updated. So the process SEND_MAIL is conditional.

           

          What is the syntax for checking that the condition that page item ASSIGNEE_ID has been updated?

          There is no basic built-in syntax in APEX or Oracle for this. Create another page item to hold the original ASSIGNEE_ID value (set it's condition to Never so it is not rendered in the page), store the original value using a page show computation/process, and make the SEND_MAIL process conditional on the original and submitted ASSIGNEE_ID being different.

          1 person found this helpful
          • 2. Re: get page item status
            GhanaApexDeveloper

            Hi,

            you employ the service or trigger like this

            create or replace trigger UPDATE_MAIL
            before update on ISSUES
            for each row
            begin
            if inserting then 
            SEND_MAIL(p_assignee_id => :new.assignee_id
              ... );
            elsif updating then
            SEND_MAIL(p_assignee_id => :old.assignee_id 
              ... );
            
            end if;
            end;
            

             

            Hope this helps

            Thanks

            Benjamin

            • 3. Re: get page item status
              TexasApexDeveloper

              I Would NOT suggest using an e-mail in a trigger.. Please note the issue posted in a previous thread.. What happens when you rollback a transaction?  Base the e-mail being sent via a page process instead....

               

              Thank you,

               

              Tony Miller
              LuvMuffin Software
              Ruckersville, VA