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:
Re: artist with most object records
From:
Chad Petrovay <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 8 Dec 2021 16:39:46 -0500
Content-Type:
multipart/alternative
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