[Pansophy] Quick Open Traveler Query

[Mike Dickey]

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/aaff7146/attachment.html>