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:
SV: Querying on a null/empty field
From:
Mette Korsholm <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 2 Feb 2016 14:59:03 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (24 kB) , text/html (14 kB) , image002.gif (14 kB) , image003.png (24 kB) 
And I have the problem with "Current location", that I cannot search on an empty value. :)

Thanks,
Mette

Mette Korsholm
Registrar
[log in to unmask]<mailto:[log in to unmask]>

The David Collection
Kronprinsessegade 30-32
1306 Copenhagen K
Denmark
+45 33 73 49 49
www.davidmus.dk<http://www.davidmus.dk>

[The David Collection]




Fra: The Museum System (TMS) Users [mailto:[log in to unmask]] På vegne af Cousins Ewan, Janette
Sendt: 2. februar 2016 15:55
Til: [log in to unmask]
Emne: Re: Querying on a null/empty field

I'd like to know how to do this, too. I've also tried to search for other fields using the "Is Empty" value in the query, but can't seem to make that work.

Thanks,
Janette

Janette Cousins Ewan
Art Registrar, Museum London
421 Ridout Street North, London ON N6A 5H4
e. [log in to unmask]<mailto:[log in to unmask]>
t. 519.661.2500 x 4269  f. 519.661.2559
www.museumlondon.ca<http://www.museumlondon.ca>

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Monday, February 01, 2016 5:42 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Querying on a null/empty field

Is there a way to query on this field (Accession Value) if there is no value? I have a group of records, some of which do have a value, and some do not. I'd like to segregate those that don't from those that do.

Christine

Christine Droll
Registrar, Database & Collections
The Nelson-Atkins Museum of Art
4525 Oak Street | Kansas City, MO 64111
p 816.751.1333 | f 816.751.0499
[log in to unmask]<mailto:[log in to unmask]>


[cid:image003.png@01D15DD2.A15C2160]


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]<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.

________________________________
Denne mail er blevet scannet for virus af TDC Mailfilter.
________________________________

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