# Patrons With Non-Blocking Notes

**URL:** https://forum.innovativeusers.org/t/patrons-with-non-blocking-notes/1239
**Category:** Polaris Repository
**Tags:** polaris-patrons, cp-migration
**Created:** [June 2, 2023, 9:05pm UTC](https://forum.innovativeusers.org/t/patrons-with-non-blocking-notes/1239 "2023-06-02T21:05:24Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![system](https://forum.innovativeusers.org/uploads/db7787/original/2X/8/8519ee8eef6492f310ea87d4ce482d931f01eef2.png) [@system](https://forum.innovativeusers.org/u/system)
#### Post date: [June 2, 2023, 9:05pm UTC](https://forum.innovativeusers.org/t/patrons-with-non-blocking-notes/1239/1 "2023-06-02T21:05:24Z")

</div>

# Patrons With Non-Blocking Notes

Get a list of patrons with non-blocking notes. Pulls the patron ID, barcode, name, note text, and last updated date.

```SQL
SELECT
    pn.PatronID AS "Patron ID",
    p.Barcode AS "Barcode",
    pr.PatronFullName AS "Name",
    pn.NonBlockingStatusNotes as "Notes",
    pn.NonBlockingStatusNoteDate 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.NonBlockingStatusNotes) > 0
    
ORDER BY
    pn.NonBlockingStatusNoteDate DESC

```