# Search by Fine Waive Note

**URL:** https://forum.innovativeusers.org/t/search-by-fine-waive-note/2481
**Category:** Polaris
**Created:** [May 20, 2025, 2:45pm UTC](https://forum.innovativeusers.org/t/search-by-fine-waive-note/2481 "2025-05-20T14:45:03Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Leenie](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/leenie/32/1193_2.png) [@Leenie](https://forum.innovativeusers.org/u/Leenie)
#### Post date: [May 20, 2025, 2:45pm UTC](https://forum.innovativeusers.org/t/search-by-fine-waive-note/2481/1 "2025-05-20T14:45:04Z")

</div>

Hi all,

Is there a say to search for fines waived that have a particular “waive note”? And also possibly by the username that did the waiving?

Thanks.

---

<div class="post-metadata">

### Author: ![wesochuck](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/wesochuck/32/499_2.png) [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [May 20, 2025, 3:29pm UTC](https://forum.innovativeusers.org/t/search-by-fine-waive-note/2481/2 "2025-05-20T15:29:16Z")

</div>

```auto
SELECT *
  FROM [Polaris].[Polaris].[PatronAccount]
  where FreeTextNote like '%NOTE-TEXT%'

```

You’d need to join in `POLARIS.POLARIS.PolarisUsers` to get the username.

You can also get a different view using: [Get Information About Patron Account Waives](https://forum.innovativeusers.org/t/get-information-about-patron-account-waives/2023)

---

<div class="post-metadata">

### Author: ![Leenie](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/leenie/32/1193_2.png) [@Leenie](https://forum.innovativeusers.org/u/Leenie)
#### Post date: [May 20, 2025, 4:13pm UTC](https://forum.innovativeusers.org/t/search-by-fine-waive-note/2481/3 "2025-05-20T16:13:41Z")

</div>

Thanks! I’ll work on a combination of both.