Also, the SiteMap Gizmo that existed the "Classic Dashboards" prior to LabVantage 8 let you hide individual tramlines and tramstops when the Sitemap was included in the Dashboard. This capability is supported and continues to function when executing the older "Classic Dashboards". However, it is not supported in LabVantage 8 Dashboards.

Where Clause: {|createdt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1 and completedt > duedt|}

Where Clause: {|coalesce(templateflag,'N') = 'N' and completedt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1|}

The OOB SamplesCompleted Gizmo supports Departmental Security and excludes Sample Templates.

Where Clause: {|templateflag = 'N' and createdt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1 and completedt is not null|}

The OOB SamplesTimeToCompletion Gizmo supports Departmental Security and excludes Sample Templates.

Where Clause: {|coalesce(templateflag,'N') = 'N' and completedt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1|}

The OOB SamplesByProduct Gizmo supports Departmental Security and excludes Sample Templates.

Where Clause: {|completedt is null and sysdate > duedt|}

Where Clause: {|coalesce(templateflag,'N') = 'N' and createdt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1|}

The OOB SamplesCreated Gizmo supports Departmental Security and excludes Sample Templates.

Select and Where Clause: from connectionlog where connectioncreateddt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1

Select and Where Clause: from connectionlog where connectioncleareddt is not null and connectioncreateddt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1

Select and Where Clause: from connectionlog where connectioncreateddt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1

Select and Where Clause: select count(*) as measurevalue from Connection where deletedt is null

Where Clause: s_datasetstatus IN ('Initial','InProgress') and availabilityFlag='Y' AND sdcid = 'Sample' AND EXISTS (SELECT 1 FROM S_SAMPLE S WHERE keyid1=S.s_sampleid AND S.samplestatus NOT IN ('Cancelled','Reviewed','Disposed','Completed') AND coalesce(S.templateflag,'N') = 'N')

The OOB AnalystAssignment Gizmo supports Departmental Security.

Where Clause: workitemstatus <> 'Completed' and sysdate > duedt|}

Where Clause: {|(s.expirationDT < sysdate or s.certificationstatus = 'Invalid') or i.instrumentstatus in ('Initial', 'Unavailable')|}

Where Clause: s_datasetstatus IN ('Initial','InProgress') and AvailabilityFlag='Y' AND sdcid = 'Sample' AND EXISTS (SELECT 1 FROM S_SAMPLE S WHERE keyid1=S.s_sampleid AND S.samplestatus NOT IN ('Cancelled','Reviewed','Disposed','Completed') AND coalesce(S.templateflag,'N') = 'N')

The OOB InstrumentAssignment Gizmo supports Departmental Security.

Where Clause: createdt between trunc(to_date('[startdate]', 'mm/dd/yy hh:mi:ss am')) and trunc(to_date('[enddate]', 'mm/dd/yy hh:mi:ss am'))+1 and workitemstatus='Completed' and moddt > duedt

Lock Dashboard

Turn Off Admin Mode

Turn Off Admin Mode