[Pansophy] Quick Open Traveler Query

[Valerie Bookwalter]

Mike,

Good ideas...
Look at the EDIT_Travelers found under TRAVELERS -> USER TOOLS -> BATCH TRAV CLOSING

It selects by project and specific traveler. Maybe your query could be put in place to allow other selections? Like all INV or all L2HE?
Would need to look at the "action" of actually closing to ensure proper date and user.
Brainstorming...

https://pansophydev.jlab.org/pansophydev/Travelers/EDIT_Travelers.cfm?projFilter=C100R&travFilter=C100R-CAV-ASSY



From: Pansophy <pansophy-bounces at mailman.jlab.org> On Behalf Of Mike Dickey
Sent: Thursday, August 19, 2021 12:24 PM
To: pansophy at jlab.org
Subject: [Pansophy] Quick Open Traveler Query

Hi,

Just a brainstorm idea.  Most of our traveler queries are project specific.

A while ago, I created a query to help me check on ALL open travelers that SRFINV is responsible for, RECV & INV.

SELECT  TRAV_ID, Trav_seq_num
from    adapps.trav_owners
where   trav_complete = 'n'
and     obs is null
and     (trav_id like '%INV%' or trav_id like '%RECV%')
and     trav_id not like 'CHL%'
and     trav_id not like '%HLDPT%'
order by trav_id, Trav_seq_num;

I run this every week or so and close traveler as needed.  It has been a busy week and today I ran the query and got 181 records.  This started me think, "Would other groups find this feature handy as a reminder to close open travelers?".  So I modified the query to look at the INSP travelers and found 769 records.  Some may be currently used, but I'm sure not all of them.

SELECT  TRAV_ID, Trav_seq_num
from    adapps.trav_owners
where   trav_complete = 'n'
and     obs is null
and     trav_id like '%INSP%'
order by trav_id, Trav_seq_num;

Due to the nature of INSP travelers in the past, not all of them belong to Aaron & team, but we should be able to tweak the query to filter out extraneous records.

In general, by removing criteria, I found 2535 open travelers across all projects, not counting NCRs & D3s.

I would like your thoughts on possible options for this idea.

Thanks,

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210819/c07cd56d/attachment-0001.html>