[Wactclc-alma] Process type date filtering

[Guidry, Wade]

And for more analytics resources, see the Analytics Training page on the consortium site:

Analytics Training - Training - LibGuides at Big Bend Community College<https://libguides.bigbend.edu/c.php?g=1142425&p=8334852>



Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<http://www.wactclc.org/>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Thomas, Kirsti
Sent: Tuesday, April 26, 2022 3:04 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Process type date filtering

CAUTION: Originated outside our network. Do not click links or open attachments unless you validate the sender.


Following up on that, there's a really helpful Powerpoint presentation by Yoel on the Ex Libris support site that has examples and step by step instructions:

Alma Training > Extended Training > Presentations and Documents - Analytics
https://knowledge.exlibrisgroup.com/Alma/Training/Extended_Training/Presentations_and_Documents_-_Analytics

Presentation is called:
How to use the TIMESTAMPADD parameter to retrieve by today - X time in an Alma Analytics report


It will be ok!

Kirsti S. Thomas
Library Technical Services Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu<mailto:kirsti.thomas at seattlecolleges.edu>



From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade
Sent: Tuesday, April 26, 2022 13:36
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Process type date filtering

I'll put in this in the meeting notes as well, but for those of you who were on the call today, here is the correct syntax for filtering on process type date in the Physical Items subject area, when you want to filter relative to current date:

"Physical Item Details"."Process Type Date" > (TIMESTAMPADD(SQL_TSI_DAY, -3, CURRENT_DATE))


In this example, the formula will select all process type dates greater than 3 days in the past (current date minus 3 days)

Kudos to Dan, as he was the one who mentioned misplaced or missing parentheses, and that's exactly what I was missing this morning, those outer parens that are underlined above.



Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=05%7C01%7C%7C6228ef974a194d4e5cbd08da27c4b6c1%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637866023834344917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GyiRTs9VvnbE1G1zV2hUdMJKDrsSKwtyq9cBSqmki6o%3D&reserved=0>



CAUTION: This email originated outside of the Seattle Colleges' email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220427/1aea7202/attachment.html>