We are also on 2012, and we do not have "Is Current" available in the Hierarchy either. We have updated the service pack yet. -Suzanne Stephens, Birmingham Museum of Art
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Frances Francis
Sent: Monday, October 28, 2013 3:22 PM
To: [log in to unmask]
Subject: Re: Current Value Query
Michelle - we encounter the same inaccurate query results as you described earlier, and "Is Current" does NOT appear in our Object Value hierarchy. We are running TMS 2012 . There's probably more like us out there...
Frances
Frances R. Francis | Senior Registrar
High Museum of Art | 1280 Peachtree Street, NE | Atlanta, GA 30309
tel: 404.733.4480 | fax: 404.733.4502 | [log in to unmask]<mailto:[log in to unmask]>
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Monday, October 28, 2013 3:22 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Current Value Query
[cid:image001.png@01CED3FB.CC3A2DE0]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA
Sent: Monday, October 28, 2013 12:05 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Current Value Query
I've searched all over the data configuration to add 'is current' to my query options but I can't find it. Any clues under which hierarchy it is located?
Thanks,
Michelle
Michelle Gallagher Roberts
Chief Registrar
New Mexico Museum of Art
505.476.5066
505.476.5076 fax
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Monday, October 28, 2013 10:46 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Current Value Query
Here's the query:
[cid:image002.jpg@01CED3FB.CC3A2DE0]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA
Sent: Monday, October 28, 2013 11:00 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Current Value Query
I'm running TMS 2010 but I'm not trying to run a report just the query.
Thanks,
Michelle
Michelle Gallagher Roberts
Chief Registrar
New Mexico Museum of Art
505.476.5066
505.476.5076 fax
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Monday, October 28, 2013 9:44 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Current Value Query
If you are running TMS2012 (maybe even TMS2010?), there is a Gallery System Crystal Report OB.Valuation Latest (assuming the current is the lastest) that will give you this information.
There is also a tick box for current value (in TMS2012) that you can put into a report with the select expert, comme ça:
[cid:image003.jpg@01CED3FB.CC3A2DE0]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA
Sent: Monday, October 28, 2013 10:30 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Current Value Query
I'm trying to query only the current value of objects but can't quite get what I want. I'd like to pull up every object which has a current value of over $100,000 (see below). This query is pulling every object which has ever had a value of $100,000 even if the most current value is less. Any ideas on how to solve this problem?
[cid:image004.jpg@01CED3FB.CC3A2DE0]
Thanks,
Michelle
Michelle Gallagher Roberts
Chief Registrar
505.476.5066
505.476.5076 fax
[cid:image005.jpg@01CED3FB.CC3A2DE0]
It's About Time: 14,000 Years of Art in New Mexico
Back in the Saddle - The horse as icon of the Southwest
Georgia O'Keeffe - Selected Works
Collecting Is Curiosity/Inquiry
A Life in Pictures: Four Photography Collections
50 Works for 50 States: The Herbert & Dorothy Vogel Collection
[cid:image006.jpg@01CED3FB.CC3A2DE0]<https://urldefense.proofpoint.com/v1/url?u=https://www.facebook.com/NewMexicoMuseumArt&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=wTtSrhG%2FvGKx5QHkZTn%2FQRhbhR7WYcOnxy2xGwFekDQ%3D%0A&s=47f3a81361b7f531274b9a3ff9742497c0b247fc5ed414797e2433f4f76a93d1>find us on facebook or check our website www.nmartmuseum.org<https://urldefense.proofpoint.com/v1/url?u=http://www.nmartmuseum.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=wTtSrhG%2FvGKx5QHkZTn%2FQRhbhR7WYcOnxy2xGwFekDQ%3D%0A&s=d544c8d6fa7efaaf28da21a105b4146972dff4c5e7f7af223ea7297cb650d0a0>
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.
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.
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.
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] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
