Patrons with Blocking Notes

Patrons with Blocking Notes

Pull a list of patrons with blocking notes. Gives you the patron ID, barcode, name, note text, and last updated date.

SELECT
    pn.PatronID AS "Patron ID",
    p.Barcode AS "Barcode",
    pr.PatronFullName AS "Name",
    pn.BlockingStatusNotes as "Notes",
    pn.BlockingStatusNoteDate AS "Last Noted"

FROM
    Polaris.Polaris.PatronNotes pn WITH (NOLOCK)

INNER JOIN
    Polaris.Polaris.Patrons p WITH (NOLOCK) ON p.PatronID = pn.PatronID
INNER JOIN
    Polaris.Polaris.PatronRegistration pr WITH (NOLOCK) ON pr.PatronID = pn.PatronID

WHERE
    DATALENGTH(pn.BlockingStatusNotes) > 0
ORDER BY
    pn.NonBlockingStatusNoteDate DESC
1 Like