1
0
-1

I have a data list with multiple items pending approval

I want to do the following, filter and find several rows in the datalist,  then select/check one or more rows in the datalist then i need to bulk change the status of some processes to "rejected".  I have this part working using a JDBC DataList Action

Now i need to filter the datalist again (done) but now i need to select all of the resulting rows and bulk "Complete" them and as part of the process the non-rejected ones as completed as Approved.

I've got the 2 possible ways partially working #1 with JDBC DataList Action 

UPDATE app_fd_tablename_here SET c_approval_status = "rejected" WHERE id = "{id }"

this will run on all of the selected rows (ie checkboxes that are checked)


How do i bulk "Complete" a set of tasks, i can get the ids,  i can also use a Bean Shell DataList Action to get the the ids of the rows i can even make a comma delimited list of the ids BUT i don't know where/how i can call the Complete Action on the tasks. I don't mind looping if i have to.


Thanks,


    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      If you use "Process List" userview menu found in Process Enhancement Plugin, you can perform bulk assignment action. Process Enhancement Plugin

      There is a demo app at the end of the KB article.

      1. Daniel Fung

        This looks promising, I will test it, Thanks

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi, I believe there is some related sample code in Demonstration Multiple Approval App For Joget DX#UpdateApplication. There is also a Process Monitoring Utility app in the marketplace that allows for batch completion of activities so you could also try to adapt it for your use.

      1. Daniel Fung

        The Processing Monitoring App appears to be broken in DX 7.

      CommentAdd your comment...