Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Wed, 6 Feb 2019 09:58:32 +0000 |
Content-Type: | multipart/related |
Parts/Attachments: |
|
|
Hi Julie
I'm currently running a data cleaning project in the Credit Line field and was encountering similar issues searching until I realised there are some records that have a second empty line to the credit line that's invisible unless you actually click into the field itself.
I've been working off a long spreadsheet exported from a report covering the whole database that makes it clear to me when this has happened (removing duplicates) but since you're only interested in a specific query you might have success just changing your Advanced Query to "Contains" (and maybe also remove a character from the end of the quoted phrase).
Apologies if I'm stating the obvious and you've already tried that.
Kind regards,
Thomas
[ACC_Crest_for mac email]
Thomas Megaw | Documentation Officer
Aberdeen City Council | Museums & Galleries | Place | City Growth
Aberdeen Treasure Hub | Granitehill Road | Aberdeen | AB16 7AX
Direct Dial: 01224 523709
www.aberdeencity.gov.uk | Twitter: @AberdeenCC | Facebook.com/AberdeenCC
For Aberdeen Art Gallery & Museums: 03000 200 293 | www.aagm.co.uk<http://www.aagm.co.uk/> |
Twitter: @AbdnArtMuseums | Facebook.com/AbdnArtMuseums
Aberdeen Art Gallery is undergoing a major redevelopment. Support our Inspiring Art and Music fundraising campaign today at www.aagm.co.uk/donate<http://www.aagm.co.uk/donate>
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Julie Hoogland
Sent: 05 February 2019 23:06
To: [log in to unmask]
Subject: Advanced query in Credit Line
Hello all,
I have a strange thing happening when running an Advanced Query on the credit line. I'm trying to pull all of the gifts donated by a specific donor. When I run the Advanced Query using their last name, not all of the records come up. I've checked and double checked spelling. I've used * and the full credit line in quotes. The only difference I know of is that the group that isn't being pulled was batch added to the database. I don't know why that would matter but I can't think of any other reason. I have searched using Constituents, the only problem with that is many of the donors are also lenders or financial contributors and those records would show up as well. Any suggestions would be appreciated.
Thanks,
Julie Hoogland
Collections Manager
(760) 322-4810
[Description: Description: Palm Springs Art Museum logo on white bacground]
P.O. Box 2310
101 Museum Drive
Palm Springs, CA 92263
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
|
|