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: Report | Packages Sort Order
From:
"Garton, Susan" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 6 Aug 2021 18:17:07 +0000
Content-Type:
multipart/mixed
Parts/Attachments:
text/plain (9 kB) , text/html (23 kB) , image002.png (9 kB) , image004.png (9 kB) , image011.png (9 kB) , image012.png (9 kB) , image013.png (9 kB) , image014.png (76 kB) , image015.png (5 kB) , image016.png (5 kB) , image017.png (5 kB) , image018.png (5 kB) , image019.png (5 kB) , image020.png (5 kB) , image021.png (103 kB) , ObjPkgOrderPos4.rpt (30 kB) 
Hi Marie-Élaine,

Attached is a sample report that you could use if you modify the Constituents sub-report.

Best,
Sue

Susan Garton
Collections Information Officer
Smithsonian
National Portrait Gallery

[log in to unmask]<mailto:[log in to unmask]>  |  202.633.8554


[cid:image002.png@01D78ACD.BBE53B10]

[Inline image 2]<https://www.facebook.com/npg.smithsonian/>  [Inline image 3] <https://twitter.com/NPG>   [Inline image 4] <https://www.instagram.com/smithsoniannpg/>   [Inline image 5] <https://www.youtube.com/user/NatlPortraitGallery>

npg.si.edu<http://npg.si.edu/>

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Pogány Ádám
Sent: Friday, August 6, 2021 12:38 PM
To: ListServ tmsusers <[log in to unmask]>
Subject: Re: Report | Packages Sort Order

External Email - Exercise Caution
Hi Marie-Élaine,

It is possible by making the package name a parameter of the report. Thus you can join Packages, PackageList and use the orderpos field for sorting.

It’s not really user friendly and prone to typing errors - but it works.

best,
Adam


From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Mathieu, Marie-Élaine
Sent: 2021. augusztus 6., péntek 15:36
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Report | Packages Sort Order

External Email - Exercise Caution
Hello,

I would like to know if anyone has developed a report that respects the sorting order of the items in the packages?
I would like to know how it is possible to achieve this.

[cid:image014.png@01D78ACD.BBE53B10]

Thank you,

Marie-Elaine







[Musées de la civilisation]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2F%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dlogo&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259028465%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=he%2FLxLC%2BU2cDm1HiTei8VZfdELI32aqHheiNyXjBkPw%3D&reserved=0>

Marie-Élaine Mathieu - T. 418 643-2158, poste 825
Technicienne en documentation
Direction des collections
MUSÉE DE LA CIVILISATION
16, rue de la Barricade, Québec (QC) G1K 8W9 Canada

mcq<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2F%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259028465%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=9UfkkqFaGmQIs4hRSlfG90nDpy8ScxBIdpnGeoJcLlA%3D&reserved=0>.<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2F%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259038458%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=B5ctkZO9qITuVGPWuv2A5uLh9Nz4pBeDwVtW1599BLk%3D&reserved=0>org<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2F%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259038458%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=B5ctkZO9qITuVGPWuv2A5uLh9Nz4pBeDwVtW1599BLk%3D&reserved=0>       [Google Maps] <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmapsengine.google.com%2Fmap%2Fviewer%3Fmid%3DzIyJ1odA15Zs.kcPuns8EA06k&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259048453%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=lug0uEqF52sN4NSwZ4014UKlKtYNzQByKahiLdJ5iHQ%3D&reserved=0>   [Facebook] <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fmcqorg&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259058448%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=UC51vUhOcWF3nWLfglpwJ4YKQRTZ6TR2FCQVGhL5%2Bkc%3D&reserved=0>   [Twitter] <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fmcqorg&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259058448%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=i1f5Z4tMd52gVUAQFoBieeJBq8UoNSzxHtndWHDP4vc%3D&reserved=0>   [Flickr] <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.flickr.com%2Fphotos%2Fmuseedelacivilisation%2F&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259068441%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=6ftH9BEvMWjbyF8T64iJ%2FX%2FK4Nub58MV5eKefjpC1mw%3D&reserved=0>   [Youtube] <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.youtube.com%2Fmcqpromo&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259068441%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=ShXKC%2Fcu3qvoYm%2FlIL2OurupVWFthEpqDXN6VrY06eI%3D&reserved=0>

[cid:image021.png@01D78ACD.BBE53B10]<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2Fexposition%3Fid%3D868631%26intcid%3Dban%257Caccueil%257Cboites%257CMAYA&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259078436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=kLs2jn4a7M8S2V1NAGUhd8eMw1E7xTu3bzyHf8Qc3m8%3D&reserved=0>
Avis : Ce message est confidentiel et ne s’adresse qu’aux destinataires. Si vous le recevez par erreur, veuillez le supprimer et nous en aviser.
Politique de confidentialité<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2Fpolitique-de-confidentialite%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259078436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=LDh01JlR%2FAudJv97YWE4PvGa6L7nBmIlipusJvxsRsk%3D&reserved=0> | Se<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2Femarketing%2Fdesabonnement%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259088428%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=nRP5PU53159%2FYiHctFRlBr73vQQB%2BM7NkQOKvQSye5I%3D&reserved=0> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2Femarketing%2Fdesabonnement%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259088428%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=nRP5PU53159%2FYiHctFRlBr73vQQB%2BM7NkQOKvQSye5I%3D&reserved=0> désabonner<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2Femarketing%2Fdesabonnement%3Futm_source%3Dmcq%26utm_medium%3Dcourriel%26utm_campaign%3Dsignature-outlook%26utm_content%3Dtexte&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259098422%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=aP4vUbjUKWO%2F%2B2ygT7MsXtFWE%2BXv%2FBUMADhXToZ12jM%3D&reserved=0> | Inscription à l'INFO-MUSÉE<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.mcq.org%2Ffr%2Finfo-musee&data=04%7C01%7CGartonS%40si.edu%7C935925d52dae453a1ee808d958f8917f%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637638649259108414%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=h9AYl0wr%2FhCdhZu9JFYbvgNS8po6mAXJcvVyAMZZb1s%3D&reserved=0>

🌲 Avant d'imprimer, pensez à l'environnement
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.

ATOM RSS1 RSS2