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
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Date:
Wed, 8 Dec 2021 16:39:46 -0500
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Re: artist with most object records
MIME-Version:
1.0
Message-ID:
<[log in to unmask]>
In-Reply-To:
<[log in to unmask]>
Content-Type:
multipart/alternative; boundary="000000000000c3b98805d2a9547a"
From:
Chad Petrovay <[log in to unmask]>
Parts/Attachments:
text/plain (1041 bytes) , text/html (1852 bytes) 
External Email - Exercise Caution
TMS search functionality does not have any aggregate functions that allow you to perform the search you described.

You will only be able to do this sort of search using SQL.


On Wed, Dec 8, 2021 at 4:32 PM Mary Douglas <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hello,
I want to know which artists have the most artworks in our collection. How to do that query in TMS? How to connect object related constituent with number of object records?
Thank you for your suggestions and help.
Mary Douglas

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.

ATOM RSS1 RSS2