Reporting: LDP-based Reports (UXPROD-1319)

[UXPROD-2032] RA-Slips Notices Report Cluster Created: 28/Aug/19  Updated: 13/Jun/23  Resolved: 13/Jun/23

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: None
Parent: Reporting: LDP-based Reports

Type: New Feature Priority: TBD
Reporter: Angela Zoss Assignee: Angela Zoss
Resolution: Won't Do Votes: 0
Labels: report-cluster, reporting, round_iv
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Blocks
is blocked by REPTOOLS-177 LDP 1.2 features (placeholder) Open
Defines
is defined by LDPQURY-40 Prototype for RA Slips Notices Cluster Closed
Relates
relates to REP-146 List of reminders from that day Closed
relates to REP-238 Patron Notice Statistics Closed
Epic Link: Reporting: LDP-based Reports
Back End Estimate: XXL < 30 days
Development Team: Reporting
Report Functional Area(s):
Resource Access
Rank: Chalmers (Impl Aut 2019): R1
Rank: Chicago (MVP Sum 2020): R1
Rank: Cornell (Full Sum 2021): R1
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R1
Rank: FLO (MVP Sum 2020): R2
Rank: GBV (MVP Sum 2020): R2
Rank: Lehigh (MVP Summer 2020): R2
Rank: TAMU (MVP Jan 2021): R1
Rank: U of AL (MVP Oct 2020): R1

 Description   

Current situation or problem:

In scope

Out of scope

Use case(s)

Proposed solution/stories

Links to additional info

Questions



 Comments   
Comment by Angela Zoss [ 24/Jan/20 ]

three areas for notices & reporting: urgent errors (notices are failing), emails were bounced (problem with email address, less urgent, run periodically), look at user record to see what notices were sent (definitely not LDP)

these are all in-app needs, no need to cover in LDP

still a need for general notice statistics; see REP-238 Closed

Comment by Sharon Beltaine [ 16/Sep/20 ]

Cornell: For notices sent to patrons, we need a date field to show when the notice was sent. Darcy Branchini is checking on this.

Comment by Darcy Branchini [ 16/Sep/20 ]

Sharon Beltaine Vandana Shah At this point in time, we are only capturing the following in mod-email regarding a notice. This is limited because it's only the log from the SMTP server which means it's only capturing emails that are sent or fail after being sent due to a non-existent recipient email address or the recipient's server rejecting the email (i.e., attachment too large). This does not capture any errors on the FOLIO processing side of notices.

{
      "notificationId": "6fa31937-e6e1-4feb-941d-7b1e47b8d695",
      "from": "fse.hosting@ebsco.com (FSE Hosting Team)",
      "to": "fse.hosting@ebsco.com",
      "header": "Page request received",
      "outputFormat": "text/html",
      "body": "<p>Dear Rosina Aarons,</p><p><br></p><p><strong>10,000 garden questions answered by 20 experts.F.F. Rockwell, editor; associate editors: Montague Free, T.H. Everett [and] Esther C. Grayson. With over 400 illus. and temperature and planting maps.</strong> by Rockwell, F. F. (Frederick Frye), 1884-1976 (book) was successfully paged. We'll let you know as soon as it's available at Social Service Administration Library, your requested pickup service point.</p><p><br></p><p><strong>Other details about this item:</strong></p><p>Call number: -SB453.R681-</p><p>Enumeration: ---</p><p>Description:  pieces/</p><p><br></p><p>Thank you,</p><p>Your university library</p>",
      "attachments": [],
     "status": "DELIVERED",
      "message": "The message has been delivered to fse.hosting@ebsco.com",
      "date": "2020-08-03T19:18:33.987+0000",
      "metadata": {
        "createdDate": "2020-08-03T19:18:33.948+0000",
        "createdByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684",
        "updatedDate": "2020-08-03T19:18:33.948+0000",
        "updatedByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684"
      },
      "deliveryChannel": "email",
      "id": "4c91d00b-331c-4da5-ac75-67e468e3d97e"
}

NOTES: Date is available; however, location is not available. There is no notion of a specific from location/library at this time in FOLIO. Status is either DELIVERED or FAILURE.

Comment by Angela Zoss [ 05/Feb/21 ]

This report requires data from mod-notify and possibly mod-email. Neither of these tables will appear in the LDP until version 1.2.

Comment by Angela Zoss [ 13/Jun/23 ]

The use cases described seem like they will be satisfied by either:

  • going to a patron's circulation log and filtering for notices
  • exploring the native tables in LDP1 (email_emails, circulation_scheduled_notices) or Metadb (folio_email schema, folio_notify schema, folio_circulation)

Don't see a need to create a derived table or even a cookbook entry.

Generated at Fri Feb 09 00:20:33 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.