Question

bulk approve Agenda Manager items pending approval

Agenda Manager

Updated February 17, 2015

asked on February 9, 2015

I have a client who hasn't gone through the process of "approving" agenda items since 2008, although they've submitted/recorded them there. So the approver has a queue of 6 years worth of items to review/approve.

The structure of the db was just complex enough that it wasn't immediately apparent how to do this directly in the database. Does anyone have insight, or provide the SQL statement necessary to approve outstanding items in bulk, so that they don't have to review/approve each item independently through the AM interface...

I've recommended just performing a fresh AM install with a clean DB, but the client doesn't want to go that direction.

0 0

Replies

replied on February 9, 2015

Backup the Agenda Manager database first. Then query the SubmittedItem table and update the relevant rows by setting the "Status" column equal to 3.

1 0

replied on February 10, 2015

The client indicates he tried this, but they still show up in the user's list of items to approve. The app pool was recycled just in case data was cached/stored in session.

Other suggestion

0 0

replied on February 10, 2015

So to clarify, you have confirmed that items are still showing up in the user's "approve item" page, but the corresponding rows in the SubmittedItem table for those exact items have the value in the "Status" column set to 3? And restarting the Agenda Manager service and logging back into the Agenda Manager site still shows the same thing?

If that's the case, please open a support case and provide screenshots confirming this so we can investigate further.

0 0

replied on February 17, 2015

Alex, the client noted he ultimately had to also make the change to the following table as well.

I found another table that needed the status changed. Changed status to 3 in the dbo_ApprovalTaskAssignment table

Updating here for future reference for other folks looking for the same info. Thanks!

1 0

replied on February 9, 2015

If there's no need to actually approve these old items, it will be easier to just delete the approval tasks. After backing up your database, try deleting from the ApprovalTaskAssignment table. You can make an educated guess on the right ApproverId based on count, or you can use the Approver table to track down the UserId. A particular user might have several ApproverIds, at least one for each approval process they are involved in.

0 0

replied on February 10, 2015

Thanks Brian, but the client has indicated he doesn't want to remove those items from the db and lose record of them; instead he's just looking to mark them approved so that they no longer show up in the user's pending approval list.

0 0

You are not allowed to follow up in this post.

Question

Question

bulk approve Agenda Manager items pending approval

Replies

Sign in to reply to this post.