LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

This search is pretty tricky outside of SQL. The easiest way to do this is to use a Package.

Make an Constituent Package with all the records that have a Gender Attribute set (ThesXrefType = 'Gender') and give it a meaningful name, like "Has Gender"

Now exclude that package from your result set, either by searching for Constituents where the PackageName IS NOT "Has Gender" (or whatever you named the package) or using the "Remove List From Current Selection" action in Package Explorer.

On Fri, Sep 13, 2013 at 11:55 AM, Rhodes, Jane <[log in to unmask]> wrote:

Hello TMS Users,

I need to search constituents for records where attribute type does not exist. Specifically, I’m trying to identify records that don’t contain “gender” as an attribute type in order to update those records. Does anyone know how to isolate records that don’t contain a particular attribute type?

Many thanks.

Jane Rhodes

Jane Rhodes

Collection Information Specialist

AGO - Art Gallery of Ontario

416-979-6660 x 259

[log in to unmask]

www.ago.net

Discover the wildly creative artworks of China’s most famous artist and activist. Ai Weiwei: According to What? is on now until October 27 at the Art Gallery of Ontario. Also, don’t miss the spectacular David Bowie is exhibition at the AGO beginning September 25.

This message is a private communication. It may contain information that is privileged or confidential. If you are not the intended recipient, please do not read, copy or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you.

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.