Search by Fine Waive Note

[Leenie (Colleen Gayle Lane)]

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.

[wesochuck (Wes Osborn)]

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

[Leenie (Colleen Gayle Lane)]

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