Hi Julie-

 

When was the last time you ran Maintain Search Terms? My suspicion is that since the group that isn’t coming up in your search results was batch added to the database, the credit lines were not properly indexed for search which is why they aren’t coming up when you search. If you run Maintain Search Terms on the Credit Line field and then try to redo your search, you should get all the records, including those that were batch added.

 

Ashley

 

--

Ashley Hall
Manager of Collection Information
Digital
212 650 2068

The Metropolitan Museum of Art
1000 Fifth Avenue
New York, NY 10028
@metmuseum
metmuseum.org

 

 

 

 

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

P.O. Box 2310

101 Museum Drive

Palm Springs, CA 92263

 

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.