TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

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

Print Reply
Mime-Version:
1.0
Content-Type:
text/plain; charset="UTF-8"
Date:
Tue, 14 Nov 2017 11:30:45 -0500
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Searching for Sequentially Numbered Objects that Contain a Hyphen
Content-Transfer-Encoding:
quoted-printable
Message-ID:
<[log in to unmask]>
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
From:
Brad Hubley <[log in to unmask]>
Parts/Attachments:
text/plain (17 lines) 
We seem to be having a problem searching for sequentially numbered objects that contain a hyphen, e.g. TRT-IMG125 to TRT-IMG130.  Each of these object records are in our system and can be retrieved individually but we get the "No matches to these conditions" when trying to search for the range of them.  Putting the object numbers in quotes doesn't work, nor does creating an advanced query with the first condition being Greater than or equal to TRT-IMG125 and the second condition being Less than or equal to TRT-IMG130.

However, I can pull up my six records that are numbered ROME200 to ROME205 by specifying the range so I wonder if having a hyphen in the object number might the issue.

Has anyone else ever experienced this or am I missing something here?

Brad

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