Per visualizzare se un utente lims è gia presente sul db
SELECT * FROM LOGIN_LOG ll WHERE USER_NAME = 'USR03415' ORDER BY LOGIN_TIME
Per visualizzare i Lims User membri di una serie di gruppi appartenenti al sito RD
SELECT ur.USER_ROLE , lu.USER_NAME , lu.FULL_NAME, lu.EMAIL_ADDR , lu.USER_DISABLED ,
lu.C_TEST_LOC_FILTER , lu.C_INV_TYPE_FILTER, lu.C_INVEST_FILTER , lu.C_CRO , lu.T_SITE , lu.LANGUAGE_PREFIX , lu.LDAP_SERVER , lu.LDAP_UID
FROM LIMS_USERS lu INNER JOIN USER_ROLE ur
ON lu.USER_NAME = ur.USER_NAME
WHERE ur.USER_ROLE in ('RD_QC','RD_REVIEW','RD_SMP_MGR','RD_SMP_MGR_DEV','RD_STAB_MONITOR')
AND lu.T_SITE = 'RD'
ORDER BY lu.USER_NAME
per visualizzare …
SELECT prj.name, prj.c_study_name, prj.c_protocol_code, prj.title, prj.description, prj.c_study_monitor, prj.TEMPLATE, prj.GROUP_NAME, 'ext_certificate - small.png'
FROM project prj
where prj.TEMPLATE LIKE '%STABILITY%' and prj.GROUP_NAME LIKE '%STABILITY%' and CLOSED = 'F'
AND (prj.GROUP_NAME IN ( SELECT ge.name FROM GROUP_ENTRY ge WHERE ge.USER_NAME = 'DOI_STAB_MGR' ))
SELECT T_USE_INTERVAL, T_USE_INT_TYPE, NAME ,
FROM STOCK s INNER JOIN INVENTORY_ENTRY ie INNER JOIN INVENTORY_ENTRY ie2
WHERE name = 'BR_17_MONOP_BECLOMET'
SELECT T_USE_INTERVAL, T_USE_INT_TYPE, NAME, ii.ITEM_NAME ,
ie.ENTRY_NAME , s.T_USE_INT_TYPE , ie.T_USE_START_DATE
FROM STOCK s
INNER JOIN INVENTORY_ITEM ii ON ii.STOCK = s.NAME
INNER JOIN INVENTORY_ENTRY ie ON ii.ITEM_NUMBER = ie.ITEM_NUMBER
WHERE ii.ITEM_NAME = 'BR_17_MONOP_BECLOMET-0002'
SELECT * FROM INVENTORY_ITEM ii WHERE ii.ITEM_NUMBER = 152587
SELECT *
FROM INVENTORY_ENTRY ie, INVENTORY_ITEM ii
WHERE ii.STOCK = 'BR_17_MONOP_BECLOMET'
AND ii.LOCATION LIKE 'ARMARIO_PA%'
AND ii.ITEM_NAME = 'BR_17_MONOP_BECLOMET-0002'
AND ie.ITEM_NUMBER = 152587 AND ii.item_number = 152587
AND ie.ENTRY_NAME LIKE 'BR_17_MONOP_BECLOMET-0002%'
AND ie.QUANTITY = 300
SELECT * FROM INVENTORY_TRANS it
WHERE it.ENTRY_NAME LIKE 'BR_17_MONOP_BECLOMET-0002%'
AND it.TRANSACTION_COMMENT IS NOT NULL
AND it.QUANTITY = 300
WHERE ie.T_STORAGE_LOCATION LIKE '%ARMARIO_PADR%'
AND ie.ITEM_NUMBER = 152587 AND ie.ENTRY_NAME LIKE '%BR_17%'
AND ii.UNITS = 'MG' AND ii.ITEM_NAME LIKE '%BR_17_MONO%'
SELECT NAME, DESCRIPTION FROM INSTRUMENTS
WHERE (INST_GROUP = 'INCUBATOR' or INST_GROUP = 'INCUBATORS')
and REMOVED = 'F' AND C_STATUS IN ('IN_USE', 'IN_CHECK')
ORDER BY 1
SELECT * FROM SAMPLE s /*WHERE text_id LIKE '%EMPTY%'*/
WHERE s.T_EM_PLAN = '202404890'
ORDER BY SAMPLE_NUMBER DESC
select prj.NAME, prj.TITLE, 'vwstablabel.png', 'vwtimezerolabel.png', 'vwstablabel.png'
from PROJECT prj inner join PROTOCOL pro on prj.NAME = pro.STUDY
where pro.STATUS IN ('N','A')
and prj.DATE_CREATED > to_date('29/12/2019 00:00:00','DD/MM/YYYY HH24:MI:SS')
and prj.CLOSED = 'F'
and prj.TEMPLATE IN ('RD_STABILITY','DOI_STABILITY')
and pro.APPROVED = 'T' AND (prj.GROUP_NAME IN ( 'DOI_LAV' , 'BACKGROUND' , 'CLEANING' ,
'LOCAL' , 'RD_INSTRUMENT' , 'DOI_VI' , 'RD_STANDARD' , 'GLOBAL' , 'BR_STABILITY' , 'RD_DEV' ,
'DOI_LCM' , 'BR' , 'CERTIFICATE' , 'GICT' , 'DOI_STABILITY' , 'FR' , 'DEFAULT' , 'STATIC' ,
'DOI_INSTRUMENT' , 'EM' , 'FR_EM' , 'BR_EM' , 'STABILITY' , 'RD_ODP' , 'RD_CLEANING' , 'RD_IPC' ,
'BR_INSTRUMENT' , 'ELN_LCH' , 'RD_OOX' , 'BR_STANDARD' , 'DOI_LMB' , 'DOI_OOX' , 'FR_STANDARD' ,
'RU' , 'ELN_RD_DEV' , 'DOI_EM' , 'DOI' , 'MFG_GMD_INSTR' , 'RD_IPC_QC' , 'DOI_INVESTIGATION' ,
'STATIC_STAB' , 'DOI_STANDARD' , 'DOI_CLEANING' , 'FR_CLEANING' , 'RD_TIMETABLE' , 'RD_INVESTIGATION' ,
'TEMPLATE' , 'DOI_LCH' , 'ARTWORK' , 'FR_OOX' ,
'RD_STABILITY' , 'GMD_RD' , 'RD_RIL' , 'SYSTEM' , 'RD' , 'RETAIN' , 'CIA' , 'ELN_LAV'))
order by prj.DATE_CREATED DESC
select sample_number, TEST_LOCATION from sample
where PARENT_ALIQUOT > 0 and PROJECT = 'CL-24-0001'
--and (TEST_LOCATION IN ('LCH','DOI_CLEANING') or ALIQUOT_GROUP IN ('LCH','DOI_CLEANING'))
and (GROUP_NAME IN (SELECT NAME FROM GROUP_ENTRY ge WHERE USER_NAME = 'DOI_VERIFIER' ))
order by original_sample asc, sample_number ASC
--INC0088729
select prj.NAME, prj.TITLE, 'vwstablabel.png', 'vwtimezerolabel.png', 'vwstablabel.png'
from PROJECT prj inner join PROTOCOL pro on prj.NAME = pro.STUDY
--where pro.STATUS IN ('N','A')
WHERE pro.STATUS = 'N'
--and prj.DATE_CREATED > to_date('29/12/2019 00:00:00','DD/MM/YYYY HH24:MI:SS')
--and prj.CLOSED = 'F'
and prj.TEMPLATE IN ('RD_STABILITY','DOI_STABILITY')
and pro.APPROVED = 'T' AND (prj.GROUP_NAME IN (SELECT name FROM GROUP_ENTRY ge WHERE user_name = 'DOI_STAB_MGR'))
order by prj.DATE_CREATED DESC
SELECT * FROM stock
WHERE GROUP_NAME = 'FR_STANDARD'
AND ACTIVE = 'F'
AND READY_FOR_APPROVAL = 'F'
ORDER BY CHANGED_ON DESC
--
AND changed_on > to_date('08/12/2024 00:00:00','DD/MM/YYYY HH24:MI:SS')
SELECT SAMPLE_NUMBER, STATUS FROM "RESULT" r WHERE SAMPLE_NUMBER = 1413508
SELECT SAMPLE_NUMBER, APPROVED, READY_FOR_APPROVAL, APPROVAL_GROUP, STATUS FROM sample WHERE SAMPLE_NUMBER = 1413508
SELECT * FROM TEST t WHERE SAMPLE_NUMBER = 1413508
SELECT * FROM APPROVAL a WHERE TABLE_NAME = 'STOCK' AND RECORD_KEY LIKE '%TEST_JA%'