TMSUSERS Archives

The Museum System (TMS) Users

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

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

Print Reply
Message-ID:
<[log in to unmask]>
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Object Value for Advanced Query
From:
Mary Douglas <[log in to unmask]>
Date:
Fri, 13 Jan 2023 16:42:15 +0000
MIME-Version:
1.0
Content-Type:
multipart/alternative; boundary="_000_DM6PR06MB4476478E70B426C0478D686CBEC29DM6PR06MB4476namp_"
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Parts/Attachments:
text/plain (854 bytes) , text/html (2975 bytes) 
External Email - Exercise Caution
Hello,
I am doing advanced query and want to search for the latest object value. But, the results are pulling from not the latest or current value but from the first value that was entered into the object record. I went to configuration to look for a "latest value" but that term isn't there to add. How to fix this? I'm doing a query for artworks that have a current (latest) value under $5000 and with an object number of less than 2000.1

Thank you for your help. Mary
Mary Douglas
Collections Manager
Kamm Teapot Foundation
1950 Flintstone Drive
Statesville NC 28677
704-876-1180 office
704-881-4664 cell

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