TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Chad Petrovay <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 13 Sep 2013 13:30:06 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2153 bytes) , text/html (4 kB)
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.
>

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.


ATOM RSS1 RSS2