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.
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.
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
Thanks! I’ll work on a combination of both.