Release v3.2.16

The newest point release of ArkCase version 3.2 was released on October 10th, 2018.  This point version is v3.2.16.  For more information, please review the release notes below.

 

Ticket ID Summary Description Resolution
6791 Issue with adding new charge roles Issue with adding new charge roles. I also should be able to remove charge roles that haven’t ever been used. Fixed
6762 Admin – Cannot add privileges for new created ROLE When new ROLE is created in Admin – Create Role/Select Privileges, user cannot add privileges to that ROLE. Fixed
6746 Error when extension is made from document details If an approver opens a document and checks “Extension” under document details, and then unchecks “Extension” on the request details page and saves, an error is displayed.  The save does not take effect as “Extension” is still checked in the document details.

Steps to reproduce:

1. Open an existing request (not in release status)

2. Open the Request Form document from the request tree

3. Check the “Extension” checkbox under document details and save

4. Go back to the Request page (extension is checked)

5. Uncheck “Extension” and save

6. Error displays in request tree

Fixed
6743 Organization information missing in Request The requester organization information is missing from the organization menu within a request.  See attached.

Steps to reproduce:

1. Click to expand a request tree

2. Click Organization under People

3. Organization is not displayed, but is persisted in the DB and can be found in the Organization Module

Fixed
6741 People details are missing on the Global Header for each Request People details are missing on the Global Header for each Request and missing on the respective tables for each person in the people module. Fixed
6739 SAML – Changes SAML (SSO) – Changes

1. Need to find a way to pass the up to 4 digit prefix, when creating users when SSO is configured.

2. Need to a configuration to hide the Forgot Username, and Forgot Password on the UI when SSO is configured.

3. Need to a configuration to stop all set password emails when new user is created when SSO is configured.

4. Need a configuration to automatically add a new user to a specified group, and ensure users cannot be removed from that group.  The intention of that group is to control which users are synced to ArkCase.  Each SAML site will have a different control group…. This control group is an extra group, so the user should belong to the regular application groups they already belong to, and also to this new control group.  No changes to UI are needed; just ensure the user is always a member of the configured control group.

Fixed
6738 Attachments from portal page not appearing in Documents When a requester attaches a document from the portal page, the attachments should be uploaded to the Request Folder in the Documents module.  The attachments are not being uploaded.

Steps to reproduce:

1. Create new request with attachments

2. Submit request

3. Log into application

4. Open Request Folder in Documents

5. Attached files are missing

Fixed
6735 OnlyOffice – keep ArkCase session live while user is working in OnlyOffice in different tab/window When user is working in Only Office in a different tab or browser window for some time, there is a problem that ArkCase session might expire so the document cannot be saved when editing is finished. We have to keep ArkCase session live all the time Fixed
6734 OnlyOffice – Lock should be removed when the session times-out When the OnlyOffice session is time out without users to leave the session or close the document, the document should unlock and version the document to the next major version. Fixed
6733 FOIA – Requests getting stuck in Billing Queue FOIA – Requests getting stuck in Billing Queue

Steps and Error below.

Steps:

1. Create a new request from the Web Portal

2. Login and find the new request

3. Open the request, assign it to an approver and select an Executive group

4. Now click COMPLETE and move to the Fulfill queue

5. Logout and back in with that approver

6. Open the request and add a word document to the working folder

7. Now open the file and redact and burn it

8. Now drag and drop or cut and past the document from the Working Folder to the Response folder

9. Now click COMPLETE 2x and the request will move from Fulfill to the Billing queue

10. Now open your browser console and click COMPLETE again and the request won’t move out of the Billing queue, because it is now stuck

11. See the error in the console

Fixed
6732 When user closes complaint, task for approval is not created 1: Login as user that have permissions to Complaints.

2: Click on Complaints from left side menu.

3: Open some draft complaint or create new one.

4: Click on “Close Complaint” button.

5: Insert all required data and submit it.

6: Click on tasks sublink.

Expected result: task for reviewing closing complaint is listed in grid.

Actual result: Task for approval is not created.

Fixed
6729 When new case/complaint is created using frevvo form, default pdf file is not created 1: Login as user that have permissions to Cases/Complaints

2: Click on New/Case (forms configuration to be set on Frevvo).

3: Insert all required data and submit it.

Expected result: Case/Complaint is successfully created and default pdf file is created in documents.

Actual result: Default pdf file is not created in documents.

Fixed
6724 FOIA New Request Preview page – Attachments not indicated When the requester attaches documents to a new request, Attachment file(s) name(s) should show on the web portal preview page Fixed
6717 Angular form  for New Time-sheet created from Case or Complaint objects When Time-sheet form is created from parent object (Case or Complaint), it should also be Angular form (if Angular forms are set as default in Admin part). New Time-sheet form created from the object should have prepopulated values for parent (Case or Complaint) Fixed
6716 Angular form  for New Costsheet created from Case or Complaint objects When Cost-sheet form is created from parent object (Case or Complaint), it should also be Angular form (if Angular forms are set as default in Admin part). New Cost-sheet form created from the object should have prepopulated values for parent (Case or Complaint) Fixed
6713 Attachments, Organization, Phone not Showing on the Acknowledgement Letter Correspondence or the Request Form Correspondence emailed to the requester Attachments, Organization, Phone not Showing on the Acknowledgement Letter Correspondence or the Request Form Correspondence emailed to the requester. Fixed
6712 Reduce email footer font-size Please reduce the font-size of the email footer (see attached).  Please make sure this change is done for ALL emails sent from the system. Fixed
6711 FOIA – Request Module – Treeview Filters All Closed filter needs to be removed, because we never have a status of closed in the FOIA solution, which is why it doesn’t show any requests in the tree.  Our final status is Release or Released, which is why we have an All Released filter now.  Please remove All Closed filter from this list. Fixed
6710 FOIA – Timesheet is not loaded and created – frevvo form 1: Login as user that have permissions to Time Tracking module.

2: Click on New/Timesheet

3: Insert all required data and submit it.

Expected result: Timesheet is successfully inserted and opened.

Actual result: Timesheet is not inserted.

Fixed
6708 FOIA – Workflow Issue The request workflow is not going through the workflow correctly.  Sometimes it jumps around from Queue to Queue or goes back to the same queue and doesn’t move forward.

Steps:

1. Create a new request from the web portal

2. Open the request and pick the executive group and click the COMPLETE button and the request moves from Intake to Fulfill

3. Click on some node in the tree view for this same request, like History or Participants, but be sure its a node for the same request.

4. Then click COMPLETE again to move from Fulfill to Approve queue and the queue will flash with Intake and then to Fulfill and it won’t move forward to the Approve queue

Fixed
6707 Missing Requester Title and Prefix in the People Module Missing Requester Title in the People Module even though we collect Requester Title in the request form. The requester titles should be a metadata field on the people module UI. Fixed
6706 FOIA – New appeal can’t be created 1: Login as user that have permissions to Requests.

2: Click on New/Request.

3: Select Appeal in Request Type.

4: Search released request number.

5: Click “Create Request” button

Expected result: new Appeal is successfully created from released request.

Actual result: after click “Create Request” form is not closed and new appeal is not created.

Fixed
6704 Make Fee Waived/Paid optional Client has determined that Fee Waived/Paid should be optional.  They currently do not collect payment, but may decide to use billing in the future.  The checkbox field can remain on the Request Information section.

So the rule that forces the user to select the “Fee Waived/Paid” checkbox should be turned off.  The user should be able to click the complete button when the request is in the billing queue and have the release queue without having to check the “Fee Waived/Paid” checkbox.

Fixed
6703 Change subject of acknowledgement email The subject of the acknowledgement email should be New Request.  Currently, the subject line is “FOIA Extension Notification” Fixed
6700 Move logic for sending emails from UI to Activiti flows Move logic for sending emails from UI to Activiti flows Fixed
6699 Portal – Change Other to Mail In the Delivery Method drop down, change “Other” to “Mail”.  Please change the option in all other places: Acknowledgment Letter, Request Information in Application, etc. Fixed
6697 Exemption codes not displaying When burning a redaction before saving the annotation, we aren’t capturing the exemption code.  The system should force the user to save annotations before they can burn or call the save annotation call before burning. Fixed
6694 Prepopulate Request Status page from link When a requester clicks the link to view the released FOIA documents, the Request ID should be prepopulated on the Request Status page, but the last name should be blank. Fixed
6692 Change subject of extension email When an approver requests an extension, an email is sent to the requester with a subject “New Request”.  This should be changed to “Extension Notification”. Fixed
6672 Global Header labels missing Last Modified By and Last Modified Date are missing labels.  See attached. Fixed
6670 FOIA – Fee Waived/Paid Checkbox not persisting FOIA – Fee Waived/Paid Checkbox not persisting

Steps:

1. Create a new Request on web portal

2. Login in to app and open the new request

3. Click on the “Fee Waived/Paid”

4. Then click COMPLETE

5. Issue = Notice the “Fee Waived/Paid” checkbox is no longer checked (it didn’t persist)

6. Now click on the “Fee Waived/Paid” again

7. Then click COMPLETE and it stays checked (it is persisted)

Fixed
6665 Add Assigned To to request history When Assigned To changes, add it to the request history log. Fixed
6664 Refresh Portal Request Form Client suggests refreshing the page when a user clicks on the New Request link. Fixed
6660 Add Requester Information All of the information inputted in the portal page is not displayed in Request Information.  The user needs to click on People to see who submitted the request, email address, phone number, etc. Fixed
6658 Request History showing incorrect user Request history is only showing Ann Administrator as user. Fixed
6657 Portal Page – Unable to enter Other reason In ArkCase we display “Other reason” but there is no way to enter this on the Portal Page.  We should either remove it from the Request Information or add it to the Portal Page. Fixed
6655 Response Form shows incorrect country The Request Form in documents shows the incorrect country (see screenshot).

Steps to reproduce:

1. Open an existing request

2. Open the Request Form from the Request folder

3. See incorrect syntax

Fixed
6654 Document Created By Incorrect All documents added automatically or manual to a requests are showing created by “Ann Administrator” instead of the correct user.

Steps to reproduce:

1. Create a new request

2. In ArkCase, open a document

3. Created By says Ann Administrator

4. Upload a new document

5. Created By says Ann Administrator

Fixed
6653 Portal Page – Preview Page Errors There are several errors with the Preview:

A) Incorrect Amount Willing To Pay value.
1. Complete form

2. Select “Provide estimate before processing” for Amount Willing To Pay

3. Click submit

4. Amount Willing To Pay displays as $1.00

B) If Fee Waived is checked and a reason is entered, the reason should be deleted if unchecked.

C) Fee waived is checked, do not provide a reason and submit.  Preview says “No”

D) Fee waived is checked and reason is provided, then uncheck checkbox. Preview says “Yes”

Fixed
6640 FOIA – Assignment Emails should only go to the previous and new assignee FOIA – Assignment Emails should only go to the assignee and to the user that was assigned the object prior to the reassignment.

Only when the request is in Intake queue, mail should be sent on clicking “Complete” button. In every other queue, mail should be sent immediately when assignee is changed

Fixed
6638 FOIA – Request – User/Group picker improvement for Saving the change When user/Group picker is used for changing the Assignee or Owning group, 2 back-end calls are initiated for saving the changes. That might cause issues with sending double email to the assignee user. Fixed
6636 FOIA – Running a report for the first time Errors out Running a report for the first time each day errors out. Fixed
6630 FOIA – Issue When Sending a Costsheet for Approval FOIA – Issue When Sending a Costsheet for Approval

When sending a cost sheet for approval, two approval tasks are created.  Only one should be created.

Fixed
6629 FOIA – Appeal Process Issues FOIA – Appeal Process Issues

1. The Subject Field (Mandatory) Field should pre-populated when tabbing out of the Original Request Field.

Fixed
6627 FOIA – Request History Table Updates FOIA – Request History Table Updates

1. Every time the assignee is changed, that needs to be tracked in the Request History Table

a. The original assignee isn’t being tracked on that History Table

b. The some times the assignee is tracked and some times it isn’t

2. When the event Document Emailed, is fired, the event needs to be appended to to say what document was emailed.

Fixed
6626 FOIA – Billing Table Issue FOIA – Billing Table Issue

User can’t add any dollar amount less than $1.00.  For Example, the user can add a line item as $.75, unless they add it as $0.75. The system should allow the user to add an entry as $.75 or $0.75.

Fixed
6625 FOIA – Release Email Changes FOIA – Release Email Changes

1. The “Link” font on the email should be the same size text as the rest of the body.
2. When the user clicks the Link from the email and is taken to the Request Status Page, the Request ID should pre-populated in that field on the Request Status page.

Fixed
6623 FOIA – Request Tree – Change Default Filter and Add New Filter FOIA – Request Tree – Change Default Filter and Add New Filter

– The Default Filter of “All Assigned”, should not show Released Request in that list.

– New Filter = “All Released”, when this filter is selected, it should show only the Requests Released by that user.

Fixed
6621 State dropdown values not alphabetical On the Portal Page, the values for the State dropdown field are not alphabetical.  See screenshot. Fixed
6620 FOIA Email Template – issue with template for Request object Creating or editing Email template for Request object is causing issues. If you try to edit the existing request, it is only adding empty strings/labels in the Template table. When you click on edit icon, email template pop-up is opened, but no object selected.

There must be some issue because of inheriting Request object from Case_File object and handling that object for email configuration.

Fixed
6616 Not receiving Assigned To email After Assigned To is selected, an email is supposed to be sent to the Assignee.  This is not working. Fixed
6615 Select User Error Message When selecting Assigned To, an error message immediately appears after selecting a user, until I select a group.  The error should not appear unless I try to click Confirm.  Also, the error message is not user-friendly.  Basically, we’re throwing an error when in fact the user hasn’t done anything wrong yet. Fixed
6614 FOIA – Web Portal Doesn’t Load in IE FOIA – Web Portal Doesn’t Load in IE Fixed
6613 Fix phone and zip format examples on Portal page Example text should be:

Enter Phone Number (xxx-xxx-xxxx)

Enter Zip Code (xxxxx)

Fixed
6612 FOIA – Can’t Create a Cost Sheet FOIA – Can’t Create a Cost Sheet

1. Login in to FOIA Dev or DC OCFO Dev

2. Select Request that isn’t released

3. Click on Cost Table and click add

4. Populate the costsheet and hit save

5. The costsheet closes but doesn’t save

Fixed
6611 FOIA – Assignment email hyperlink caching issue FOIA – Assignment email hyperlink caching issue

1. Open an assignment email

2. Click on the link

3. User then has to login

4. The page refreshes and the user is on the Dashboard page when they should be on the object page (i.e. the request page)

Fixed
6610 FOIA – Label issue on the Assignment Modal box FOIA – Label issue on the Assignment Modal box Fixed
6608 FOIA – 3 emails are being sent on when user is assigned a Request FOIA – 3 emails are being sent on when user is assigned a Request.  Only one email notification should be sent. Fixed
6606 FOIA Web Portal New Request form – Validation to be done on “Submit” click Web Portal 1. New Request Form on the Web portal should have validation of the mandatory fields on Submit button click.

Submit button should always be enabled, mandatory fields should be marked with start (*) and Red box, but on Submit clicked, validation should be done on all fields and separate messages should be displayed under each mandatory field that didn’t pass the validation. (“Please enter…” or “Wrong format for….”).

2. “NONE” entry in all Drop-boxes in the New Request form should be replaced with “Chose…”. For example: for Prefix it should be “Choose Prefix”. For State it should be “Choose State”….

Fixed
6605 Request Form fields should be read-only All fields inputted by the Requester in the New Request / Request Form should be read-only after creation.  Only an Admin should have the ability to modify those fields.

Only Officers should have the ability to select Assigned To and Executive Group.

Fixed
6601 FOIA – Category Field Needs to be Optional in the Application FOIA – Category Field Needs to be Optional in the Application

The Category field on the web portal form and the application form is optional, but now that we send NONE as the value in the category and not an actual value. the application is saying it is mandatory to move to the next queue/status.  The category should be optional.

Fixed
6600 Request Date To/From Error on Preview Date To/From changes after previewing.

Steps to reproduce:

1. Complete a New Request from Portal page

2. Submit Form

3. Click Cancel on preview screen

4. Submit Form

5. Preview show incorrect dates

Also, the date in the Preview appears to be DD/MM/YYYY but on the form the format is MM/DD/YYYY.  These need to be consistent with each other.

Fixed
6599 Able to update status to Fulfill as an Approver Steps to reproduce:

1. Create a new request

2. Log in as Officer

3. Assign it to an Approver

4. Do not click Complete

5. Log in as assigned Approver

6. Open request and click Complete to move from Intake to Fulfill.

There doesn’t appear to be anything preventing users from changing the status of requests even when it is outside of their role.  Perhaps changes (i.e. assignment) should not take effect until the Complete action.

Fixed
6598 Should not be able to release request unless Fee Waived/Paid is checked The system should not allow me to release a request unless it is either:

a) denied

b) fee waived / paid is checked

Currently, this is not the case.

Fixed
6595 FOIA – New Request created from portal should use system user for communication with the back-end New Request created from portal adds the documents and sets the Modified By field to “Ian Investigator”.

This seems like it should be a system users – “ArkCase Administrator”

Fixed
6591 Reports – No Results return when the From and To Dates are a single day Reports – No Results return when the From and To Dates are a single day.  Also, sometimes you have to pick a week window to get the results for one day to show.

If I run a report for:

From = 9/5/2018

To = 9/5/2018

No results return, even though I know I have data for the day of 9/5/18.  If I change the From date to 9/4/18 or the To date to 9/6/18 the data returns.

Fixed
6589 FOIA – Assignment emails aren’t being sent and they need to be changed to be sent every minute FOIA – Assignment emails aren’t being sent and they need to be changed to be sent every minute

1. *Email Notifications aren’t being sent when a user is assigned a request.* For example, Laverne Lee is assigned all request when they are created and she isn’t getting an email notification.  Also, when I reassign the request to another user, then a new email notification should go out once, but 3 identical emails are being sent.

2. The email notifications should be sent out every minute instead of every 5 mins.

Fixed
6587 FOIA – Biling Issue that need to be fixed FOIA – Biling Issue that need to be fixed

1. Invoice should show the Amount as a full dollar amount ($100.00 not $100.0)

2. The email template use for sending the invoice should follow the normal email template format.  Right now it doesn’t.

3. Need validation on the Amount field

4. Shouldn’t be able to add billing line items after request has been released.

Fixed
6586 FOIA – Request Info – Label missing Fix the missing label on the Request Info page. Fixed
6581 FOIA – Time to Complete issue When Time to complete is changed in the Admin-Time to Complete page, Time to complete value shown on the Request header is not corresponding to the new value.

Steps to reproduce:

1. Go to Admin-Time to complete page

2. Change Intake – Time to Complete value to 6 (or more)..and save changes. Total time to complete should increase (22 or more)

3. Create New Request.

Expected result: New request should have “Time to Complete” value in the header equal to the Total time to complete set in Admin

Actual result: New request has wrong Time to complete (15, as set before changes)

Fixed
6579 “Time to Complete” value in old requests is not changed if user update it in admin 1: Login as user that have permissions to Admin module.

2: Click on Admin from left side menu.

3: Click on Time to Complete.

4: Update some numbers and save it.

5: Click on Requests from left side menu.

Expected result: Validate that for correct object (request or appeal) the “Time to Complete” and  “Due Date” are updated.

Actual result: Time to Complete and Due Date are not updated for old requests. The changes apply only to new requests.

Fixed
6577 FOIA – emails are not sent 1: Login as admin user.

2: Click on Admin/Document Delivery Policy

3: Click on Validate.

4: After “SMTP settings are valid” message click Save button.

5: Click on Requests from left side menu.

6: Click on Documents sublink.

7: Right click on some document and click “Email”

8: Insert your email and click Send.

Expected result: Email is successfully sent.

Actual result: Validation message is displayed informing that email is successfully sent, but the email is not sent.

Any email is application is not sent.

Fixed
6576 FOIA – 403 error occurs when user try to add new billing 1: Login as user that have permissions to Requests

2: Click on Requests from left side menu.

3: Click on Billing sublink.

4: Click on + to add new billing.

5: Insert all data and submit it.

Expected result: Billing is successfully inserted.

Actual result: 403 error occurs/ billing is not inserted.

Fixed
6573 FOIA Request Due Date Incorrect The FOIA Request Due Date should = Today + 15 business days (excludes holidays).  The current setting is incorrect. Fixed
6572 Web Portal – After Submitting a Request Take User to Top of New Request Page Web Portal – After Submitting a Request Take User to Top of New Request Page Fixed
6570 Reports – All Reports need to use the same fonts, sizes, and style of tables Reports – All Reports need to use the same fonts, sizes, and style of tables.

Right now the reports are all different as it pertains to fonts and sizes.  The lines on the tables are also all different sizes.

Fixed
6569 Report – Report Titles in Header need to be Capitalized Report – Report Titles in Header need to be Capitalized.  The follow reports need to be capitalized. Fixed
6568 Reports – Old Duplicate Reports Need to be Deleted Reports – Old Duplicate Reports Need to be Deleted Fixed
6566 FOIA – Dashboard – Wrong Widgets show on First time new user logs in FOIA – Dashboard – Wrong Widgets show on First time new user logs in.  The users dashboard should show empty. Definitely shouldn’t load with widgets that aren’t available in Admin Dashboard configurations. Fixed
6564 FOIA Portal – Unable to submit request when Waiver checked When Check to Request a Waiver is checked, unable to submit form.  The page keeps spinning. Fixed
6563 FOIA Portal attachments error In Section 2, when selecting to add attachments, it is not clear how to select multiple attachments.  Furthermore, you can only add multiple attachments from one folder directory.  If you attach one file and then click to attach another, it will replace the existing attachment.

Steps to test:

1. Click Add Attachment

2. Add another attachment (from either the same or different folder)

3. The original attachment is replaced with the new one

Fixed
6561 Set Request Title to Request ID Set Request Title = Request ID Fixed
6549 FOIA – Can’t create appeal from FOIA portal – “Request doesn’t exists or is not in Released status” is displayed even though released request is searched 1: Open FOIA External Portal.

2: Click on “New FOIA Request” from left side menu.

3: Select “Appeal” in Request Type drop down list.

4: Insert request id which is in released status.

Expected result: data are auto populated.

Actual result: Pop up is displayed “Request doesn’t exists or is not in Released status”

Fixed
6548 FOIA – New requests inserted from FOIA portal does not enter in FOIA 1: Open FOIA external portal.

2: Click on “New FOIA Request” from left side menu.

3: Select “New Request” in Request Type.

4: Insert all required data and submit it.

5: Login to FOIA application with user that have permissions to Requests.

6: Click on Requests from left side menu.

Expected result: new inserted request is inserted in FOIA application.

Actual result: New inserted request is not successfully inserted.

Fixed
6523 Email configuration API exposes sensitive information The application leaked sensitive information by means of response back from a request to configuration file.  Such detailed information could be used by an attacker on later stages in the attack.

API: /arkcase/api/latest/plugin/admin/email/configuration

This API:

1. Doesn’t enforce ‘admin’ only permission  and allows any attacker gain access to this information by being a valid user in the application. Need to add appropriate Spring Security @PreAuthorize checks.

2.  Change admin email configuration functionality to not need to expose sensitive data (i.e. passwords)

Fixed
6522 Profile Image API allows non-image file uploads The image upload for profiles allows for attackers to upload non-image files which are then delivered to users an re-interpreted as an image in the browser. This can be used to execute arbitrary code client side through image manipulation. See attached image of a payload executed when retrieving images for the profile. Fixed
6519 FOIA – Web portal – Submission Preview page Create Submission preview page that will be opened on “Preview” button on the New Request page. This should be done again after latest changes on the New Request form . Fixed
6516 FOIA – Request name in the header should not be editable 1: Login as user that have permissions to Requests.

2: Click on Requests module

3: Delete request subject and save it.

Expected result: Request subject cannot be deleted (edited)

Actual result: Request name is deleted

Fixed
6513 FOIA – Move Core implementation for editing Person/Requester in the Request-People node 1: Login as user that have permissions to Requests.

2: Click on Requests from left side menu.

3: Click on People sublink.

4: Click on edit button next to record.

5: Change the Person Assocition Type and save it.

Expected result: record is successfully saved.

Actual result: record is not successfully saved, 500 error occurs.

If Requester should not be edited or deleted, edit and delete buttons should be removed.

Fixed
6508 403 error occurs when user try to subscribe to task or create folder 1: Login as user that have permissions to Tasks.

2: Click on Tasks from left side menu.

3: Open some task or create new (current user is assignee).

4: Click Subscribe button.

Expected result: User successfully subscribe to task.

Actual result: 403 error occurs.

Please note that this works for cases and complaints.

Fixed
6507 Change all FOIA reports to accept startDate and dueDate variables and show the selection in the reports Change all FOIA reports to accept startDate and dueDate variables and show the selection in the reports Fixed
6506 Setup configuration of FOIA reports and the date search types (Date Range or Fiscal Years ) Setup configuration of FOIA reports and the date search types (Date Range or Fiscal Years ) Fixed
6505 Add support for Date Range and Fiscal Years as reports configuration on Core Add support for Date Range and Fiscal Years as reports configuration on Core Fixed
6500 UI Changes in the Yearly Reports Change the Search criteria and Pentaho report for Yearly reports only

Instead of From and To fields, there will be only one drop-down with Years (2018, 2017, 2016, 2015.)….values to be set in lookups

Fixed
6499 Date Range to the report header Add the Date Range to the report header under the Report Name Fixed
6493 When a Document is locked, all the other write actions on the document should be greyed out When a Document is locked, all the other write actions on the document should be greyed out

When a user locks a document for “Edit”, “Co-Edit”, or “Collaborate”, then all the write actions on that document should be greyed out.

Fixed
6492 OnlyOffice – Viewing Version History Functionality hangs OnlyOffice – Viewing Version History Functionality hangs

Steps:

1. Login to CORE Dev

2. Go to Case module and select a case

3. Now find a word document and right click and select co-edit

4. When the new OnlyOffice window opens, click on the File icon and Version History option.

Now notice the Version History just hangs.  We need to fix that, so it loads.

Fixed
6491 Tasks – Documents Under Review Change Task Module

Change Documents under review section to a Document Tree Directive with all the same controls as our normal doctree

Only the document under review should show in that Document Tree

Fixed
6485 On IE dashboard changes are saved but not rendered properly On IE dashboard changes are saved but not rendered properly Fixed
6483 Reports – Remove the Section Number from All Reports Reports – Remove the Section Number from All Reports Fixed
6476 Provision ActiveMQ, using TLS and MySQL Data folder under /opt/data/activemq. Fixed
6458 Permission evaluator: Check Solr access only for assignable objects In ArkPermissionEvaluator, we check Solr access for all object types, even for objects like USER and QUEUE that are not assignable (that is:  they do not implement AcmAssignedObject).  Update the evaluator to check Solr only for AcmAssignedObjects. Fixed
6454 Make Angular Forms to be default choice in Admin/Forms Type configuration Make Angular Forms to be default choice in Admin/Forms Type configuration Fixed
6451 FOIA – When user click to edit Statute, drop down list has not selected previous Statut 1: Login as user that have permissions to Queues module.

2: Click on Queues from left side menu.

3: Click on some request by clicking on it.

4: Redact and add X3 exemption code and Statute.

5: Click on Documents tab.

6: Click on edit button next to record in Exemption Codes grid.

Expected result: In drop down list is displayed previous inserted Statute.

Actual result: drop down list is empty.

Fixed
6448 Admin > Reports Scheduling    Reports created unde… Admin > Reports Scheduling

Reports created under Reports Configuration do not display in the list of reports that can be scheduled.

Fixed
6446 Search by Queue Due Date, Days in Queue, Time to complete and group is not working 1: Login as user that have permissions to Queues module.

2: Click on Queues from left side menu.

3: Insert some date in “Queue Due Date From” and “to” and click Enter.

Expected result: Grid is filter by due date within entered dates

Actual result: whole grid is displayed.

For searching Days in Queue, Time to Complete and Group, no results are displayed even though there is records in grid that should be listed.

Fixed
6444 FOIA – Exception occurs when user try to send document by email on automatically added recipients 1: Login as user that have permissions to Requests module.

2: Click on Requests from left side menu.

3: Click on Documents sublink.

4: Right click on some document and click Email.

5: Click on “Send Email” button.

Expected result: Email is successfully sent.

Actual result: Exception occurs, email is not sent.

Fixed
6440 FOIA – Creating a new workflow task from a request – Issue with Task Title FOIA – Creating a new workflow task from a request – Issue with Task Title

This is an issue in CORE and FOIA.

Steps:

1. Login

2. Open a case or request

3. Go to the document tab and select a document click new task

4. Create a task and notice the Task Title adds the work “REVIEW” to the beginning of your task title

Fixed
6439 Update Application Request Form to Match New Web Form Update Application Request Form to Match New Web Form

latest requirements.

Fixed
6431 When user try to insert new timesheet with not selected charge role, timesheet is not inserted 1: Login as user that have permissions to Time Tracking module.

2: Click on New/Timesheet, insert all required data (don’t select charge role) and submit it.

Expected result: Timesheet is successfully inserted.

Actual result: Timesheet is not inserted.

Fixed
6430 Proxy error occurs when user try to login to FOIA test 1: Try to login with valid user name and password

Expected result: user successfully logins.

Actual result: 502 error occurs.

Fixed
6413 FOIA – User can save empty or 0 value in Time to Complete which cause Total -Time to complete to be not calculated 1: Login as user that have permissions to Admin module.

2: Click on “Time To Complete” under “Queues”.

3: Insert 0 or empty in some field.

4: Click Save button.

Expected result: If 0 or empty is not allowed user can’t Save the configuration.

Actual result: Configuration is successfully saved and Total Time to Complete is empty.

Fixed
6408 FOIA – Requests are inserted with Unknown owning group and no user can’t make changes 1: Login as user that have permissions to Requests module.

2: Click on Requests from left side menu.

Expected result: Request is successfully opened.

Actual result: 403 error occurs, owning group is: Unknown

Fixed
6407 FOIA – 500 error occurs when user try to open queues module 1: Login as user that have permissions to Queues module.

2: Click on FOIA Queues module from left side menu.

Expected result: Queues are successfully opened.

Actual result: 500 error occurs.

Fixed
6387 Participants table from right-click in doc-tree – Front end issue Participants Table opened by right-clicking on the Folder or file in doc-tree is not extended properly. Columns are shrink and not opened OK. Fixed
6383 Implement the Extension Checkbox Implement the Extension Checkbox

Requirement – The system shall allow authorized user the ability check an ‘Extension’ checkbox that will add 10 business days to the request due date.

Fixed
6376 FOIA – Request Form Fixes FOIA – Request Form Fixes

See marked Up attachment for detailed changes.

Request Form.docx

Fixed
6367 Pictures are not displayed in grid 1: Login as user that have permissions to People module.

2: Click on New/Person.

3: Insert required fields, add picture and save it.

4: Click on Pictures sublink.

Expected result: Picture is listed in grid.

Actual result: Grid is empty.

Fixed
6366 500 error occurs when user click subscribe 1: Login as user that have permissions to Cases/Complaints etc.

2: Click on Cases from left side menu.

3: Click Subscribe button.

Expected result: User successfully subscribe to object, button text is changed to Unsubscribe,

Actual result: 500 error occurs.

Fixed
6351 FOIA – Request Viewer Details Page – all Tabs not opening tables correctly All Tabs (Tasks, Tags, Reference, History, and Notes) should be clicked twice (or double click) to see the empty or populated table. Fixed
6349 FOIA – Request Viewer Details page – Document tab issue When request is opened from some Queue – Request Viewer Details Page – Documents Tab – When adding documents to the tree, after adding the document tree auto refreshes and shows 2 root folders . Fixed
6348 FOIA – Queue module, Start Working button functionality Logic that needs to be implemented for Start Work and Next buttons:

– Start Work- should open the oldest request (per oldest queue due date) in that queue that is assigned to the users group(s), that is not assigned to another user already.

– Next – same logic as above.

Fixed
6343 FOIA – Admin – State of ArkCase Missing FOIA – Admin – State of ArkCase Missing

Steps to Reproduce:

1. Login to FOIA environment

2. Go to admin module

3. No “State of ArkCase” section in FOIA Admin like we can on core.

Fixed
6334 Uploading video issue For some videos, there is a problem when uploading them. Possible issues is not recognizing the file format (metadata) because of invalid date of the video.

Please try to reproduce the issue with video attached to this ticket

Fixed
6329 Cannot add file under Attachments in Task module Adding documents in doc-tree under attachments in Task Module is throwing error Fixed
6299 FOIA – Organizations are not persisting FOIA – Organizations are not persisting

Steps to Reproduce:

1. Login to FOIA Dev

2. Click on Organization Module

3. See that there are not Organizations in the tree

4. Go to global new and create a new Organization

5. See that the new organization is in the Organization Module

6. Now navigate away from the Organization Module and then back to it and your new organization is gone.

Fixed
6289 When user click on Assignee in document repository “Change Assignee” modal is not opened 1: Login as user that have permissions to Document Repository.

2: Click on Documents from left side menu.

3: Click on Assignee link on ribbon data.

Expected result: “Change Assignee” modal is opened.

Actual result: “Change Assignee” modal is not opened.

New approach should be implemented for using User/Group picker, same as we have in Case module.

This implementation (User/Group picker) should be implemented for all modules: Complaints, Tasks, Documents and Cases

Fixed
6287 Exception occurs when user try to insert person with more than one picture 1: Login as user that have permissions to People.

2: Click on New/Person

3: Insert required data and upload 2 pictures.

Expected result: Person is successfully inserted.

Actual result: Error occurs

Fixed
6283 In Locations, edit and delete buttons are not visible 1: Login as user that have permissions to Complaints module.

2: Click on Complaints from left side menu.

3: Click on Locations sublink.

4: Add new location.

5: Refresh the page. (or click on another object and go back)

Expected result: buttons for editing are deleting are visible.

Actual result: buttons for editing or deleting locations are not visible.

Fixed
6254 When user search existing user to add as initiator on case, 403 error occurs 1: Login as user that have permissions to Cases.

2: Click on New/Case

3: Insert all required data and click on Initiator

4: Search existing user and try to add it.

Expected Result: Initiator is successfully added.

Actual Result: 403 error occurs.

Fixed
6225 FOIA – Report 5: Dispositions of FOIA Requests Number of Times Exemptions Applied Report Name = *Dispositions of FOIA Requests Number of Times Exemptions Applied*

Note: This report exist in the FOIA application, but it needs be re-written with the web reports tool because it is currently a rpt.  The title needs to be changed from “FOIA Exemption Report” to “Dispositions of FOIA Requests – Number of Times Exemptions Applied”.

Fixed
6177 Locks should be released after defined time to live is expired Locks which are created and specified expiry time, are not released after that time passed. Fixed
6154 FOIA – Route the Deny button action to Approval Queue Directly and then from there to Release FOIA – Route the Deny button action to Approval Queue Directly and then from there to Release

This would be for any partial or full denial, when the user clicks the “Deny” button from any queue.  The request should go from whatever queue it was in to the Approve Queue and then once completed, it will go to the Release Queue.

Fixed
6130 Incorporate JWT with communication between ArkCase and Onlyoffice Incorporate JWT with communication between ArkCase and Onlyoffice.

There is not much information provided in onlyoffice documentation except following links:

https://api.onlyoffice.com/editors/security

https://api.onlyoffice.com/editors/signature

This implementation should be of two tasks:

1. Sign JSON from ArkCase which is needed for config when is initially send to onlyoffice.

2. Configure Onlyoffice to sign callback requests, and also implement verification on ArkCase side.

Fixed
6124 Implement locking documents for onlyoffice Implement locking documents for onlyoffice.

We need to use shared lock for this purpose.

Fixed
6123 Implement JWT for the onlyoffice config what needs to be done is described in following link:

https://api.onlyoffice.com/editors/signature/browser

Fixed
6121 Implement new ArkCase form for the current Frevvo “Change Case Status” form Implement new ArkCase form for the current Frevvo “Change Case Status” form Fixed
6119 Implement new ArkCase form for the current Frevvo “New Timesheet” form Implement new ArkCase form for the current Frevvo “New Timesheet” form Fixed
6117 Implement new ArkCase form for the current Frevvo “New Case” form Current Frevvo “New Case” form should be replaced with Angular form within the application. Make research and propose a form designer tool to be used as substitute for plain form designer.

Also automatically generated PDF file should be created based on the “New Case” form.

Please note that new forms would not include the part with adding attachments/files.

Fixed
6094 Simultaneous Editing Audit to be captured on Co-Edit Implement an audit event every time a user clicks the Co-Edit option on the document tree. Fixed
6085 FOIA – Initiate PDF conversion of the final response documents and create ZIP file with all converted documents, when entire request moves to RELEASE status The system shall convert all documents, in the response folder, to readable PDFs. Conversion should be initiated when the entire Request moves to RELEASED status and when additional files are uploaded to the response folder and the status is already RELEASED. Fixed
6071 Adjust Java Example from OnlyOffice to work with ArkCase Adjust Java Example from OnlyOffice to work with ArkCase Fixed
6032 Admin/Link/Form Workflow is not successfully opened – only on cloud 1: Login as user that have permissions to Admin module.

2: Click on Admin from left side menu.

3: Click on Links/Forms/Workflow under Form/Workflow Link.

Expected result: grid is successfully opened.

Actual result: Empty page is opened, 500 error occurs.

Fixed
6020 CMIS configuration can’t be added – 500 error 1: Login as user that have permissions to Admin module.

2: Click on Admin from left side menu.

3: Click on CMIS Configuration under Document Management.

4: Click on “Add new CMIS config” link

5: Insert all required fields and click OK button,

Expected result:CMIS configuration is successfully added.

Actual result: 500 error occurs.

Fixed
6015 Can’t create report schedule – 500 error occurs – only on Cloud 1: Login as user that have permissions to Admin module.

2: Click on Admin from left side menu.

3: Click on Report Scheduling under Reports

4: Insert all required fields and submit report schedule.

Expected result: Schedule is successfully created and added in the grid.

Actual result:500 error occurs.

Fixed
5999 On clicking the Deny button, there is not prompt to entire denial reason (the denial letter is created and the appeal is moved to release queue, which is correct.) On clicking the Deny button, there is not prompt to entire Disposition Type (Drop down), Disposition SubType (Drop down) (If FULL DENIAL is selected on Disposition Type), and Other Reason (If OTHER is selected on the Disposition SubType drop downs) Fixed
5916 Enabling/Disabling widgets in Preferences is not working 1: Login with valid user.

2: Click on down arrow next to username

3: Click on Preferences.

4: Click on some module.

5: Enable or Disable all widgets and then refresh the page.

Expected result: widgets are with same value after refresh (all enabled/disabled).

Actual result: Most of the widgets are not enabled/disabled successfully.

Fixed
5899 Snowbound – Cannot select multiple document versions to be opened in separate tabs After changing the document that is opened in Snowbound and after saving and burning the changes, new version of the document is created. Snowbound view is refreshed and new version of the document is opened (as a single tab in Snowbound), but there is no more possibility to select/open previous versions of the document (in a separate tabs). Fixed
5880 When application and report is run for the first time daily, “failed at query” error occurs 1: Login as user that have permissions to Reports.

2: Click on Reports from left side menu.

3: Run some report.

Expected result: Report is successfully generated.

Actual result: “failed at query” error occurs.

Fixed
5787 Update Password to meet FedRAMP Requirements Update Password to meet FedRAMP Requirements Fixed
5771 Refresh button in Tasks is not working Steps to reproduce:

1.Create new Task

2. Go to the created task page.

3. Click on the refresh button (next to the unclaim button)

When the refresh button is clicked error is thrown in the console “vendors.min.js:312 TypeError: taskCache.clear is not a function”.

The data is not refreshed.

Fixed
5728 Admin – Report Scheduling Page – Clean it up Admin – Report Scheduling Page – Clean it up Fixed
5726 Fix fields in “Add New Directory” form Attached are screenshots of “Add New Directory” form which can be accessed if you go to Admin Module -> Security/Ldap Configuration -> Add New Configuration button in right corner.

Issues found:

1. The ID input field has some validation on it and won’t accept certain characters. As shown in first image, the field is populated with “prc-ext” and remains red because it does not meets the required pattern. However, there is no info of which characters are not allowed.

2. The password field should be of type password. That way the password string won’t be exposed as plain text.

3. The User Domain field should be required. Also, the note above is misleading and should be removed. This suffix now is always appended to users/groups names.

Fixed
5718 When user search some object id, some reference empty row is returned 1: Login as user that have permissions to cases.

2: Click on Search from left side menu.

3: Insert some case id for searching.

Expected result: all files/objects that are connected to this id are listed.

Actual result: Some reference empty row is displayed.

Fixed
5713 When there is 2 files with same name, only one will be sent in email as attachment 1: Login as user that have permissions to Cases/Complaints.

2: Click on Cases/Complaints from left side menu.

3: Click on Documents sublink.

4: Upload 2 same files (or merge 2 cases/complaints)

5: Select all files and click “Send Email” link.

6: Insert your email, select “Send Email with Attachment” and click Send.

Expected result: all files are sent.

Actual result: if there is 2 files with name “Case File” or “Close Complaint” only one will be attached to the email.

Fixed
5694 FOIA – Report 22: FOIA Personnel and Costs Report Name = *FOIA Personnel and Costs* Fixed
5689 FOIA – Report 17: Processed Requests Granted Expedited Processing — Response Time in Day Increments Report Name = *Processed Requests Granted Expedited Processing — Response Time in Day Increments* Fixed
5688 FOIA – Report 16: Processed Complex Requests — Response Time in Day Increments Report Name = *Processed Complex Requests — Response Time in Day Increments* Fixed
5687 FOIA – Report 15: Processed Simple Requests — Response Time in Day Increments Report Name = *Processed Simple Requests — Response Time in Day Increments* Fixed
5680 FOIA – Report 8: Reasons for Denial on Appeal — Number of Times Exemptions Applied Report Name = *Reasons for Denial on Appeal — Number of Times Exemptions Applied” Fixed
5667 FOIA – Convert All Final Response Documents to Readable PDFs The system shall convert all documents, in the response folder, to readable PDFs. Fixed
5581 BA suggestion for the position of the “Save” and “Cancel” buttons. In the Frevvo form, the “Cancel ” button is on the right of the “Save” button but , in the angular modal box the “Cancel ” button is on the left of the “Save” button.

Suggestion: is to display “Cancel” button on the right side on all the screens (to mainatain consistency).

Fixed
5485 Report of investigation can not be added in Cases 1: Log into the application.

2: Click on Case Files in left navigation menu.

3: Scroll down to the Documents header, click on the black arrow down button.

4: Right click on the folder.

5: Select New Document and select Report of Investigation from the menu.

6: Insert all required data: Report title, Approver and click Submit button.

Actual Result:

Report of investigation documents is not uploaded and no error are displayed in the console.

Expected Result :

Documents is successfully uploaded.

Fixed
5425 Person and Organization – Creator to be “Owner” by default and new group/role “Entity Administrator” to be created for Owning Group The user that creates an Organization is not added as the Owner.  Also, the Owning Group defaults to Administrators and if the Creator is not in the Administrators group they cannot update the Organization.

On Creation of an Organization:

– make the Creator the Owner

– Create another role/group called Entity Administrator which is different than Administrators of ArkCase

– Set Entity Administrator as the Owning Group

We should do the same for People.  Entity Administrator can manage Organizations and People

Fixed
5408 Tags in Simple Search Issue When tags appear in the simple search results, the hyperlink “title” column does not do anything.  Let’s go to the Tags module and display the results of the tag. Fixed
5143 System notifications are not displayed when object is created or updated 1: Login as user that have permissions to Cases.

2: Click on New/Case

3: Insert all required data and submit it.

Expected result: notification message is displayed “Case File with id (id) was created”,

Actual result: Notification message is not displayed.

Fixed
5142 403 error occurs when user try to declare record in tasks attachments 1: Login as user that have permissions to tasks.

2: Click on New/Task

3: Insert all required fields and submit it.

4: Click on Attachments sublink.

5: Add document, right click on it and click “Declare as record”.

Expected result: Status is changed into RECORD.

Actual result: Status remains ACTIVE, 403 error occurs even though task is assigned to logged in user.

Fixed
4166 Edit Cost/Time sheet – Details are lost When you push Edit Time-sheet or Cost-sheet button, an appropriate “time-sheet” or “cost-sheet” form opened, but previously saved “Details” info is lost, and after saving new changes, there is no details

Steps to reproduce:

1. Go to Cost Tracking page.

2. Select some costsheet.

3. Enter details and save it.

4.Click on the Edit button.

Actual Result:

When the costsheet from is opened for editing the details area is empty.

Expected Result:

Saved details should be displayed for editing.

Fixed
3293 Complaint – Close Complaint – Open New Investigation – No Case File PDF Complaint – Close Case – Open New Investigation – No Case File PDF

Steps

1. Login to Dev App

2. Create new complaint

3. Close complaint and open investigation

4. Approve task

5. New Case is created, but not Case file in the document folder

The issue appears only when we use frevvo forms.

Fixed