126 lines
4.7 KiB
Plaintext
126 lines
4.7 KiB
Plaintext
|
ALTER PROCEDURE [dbo].[sp_TestSetupsGet]
|
||
|
|
@TestSetupId int = null,
|
||
|
|
@TestSetupName nvarchar(50) = null
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
if(@TestSetupName is not null)
|
||
|
|
begin
|
||
|
|
set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName)
|
||
|
|
end
|
||
|
|
|
||
|
|
SELECT [TestSetupId]
|
||
|
|
,[TestSetupName] as 'SetupName'
|
||
|
|
,[SetupDescription]
|
||
|
|
,[AutomaticTestProgression]
|
||
|
|
,[AutomaticProgressionDelayMS]
|
||
|
|
,[InvertTrigger]
|
||
|
|
,[InvertStart]
|
||
|
|
,[ViewDiagnostics]
|
||
|
|
,[VerifyChannels]
|
||
|
|
,[AutoVerifyChannels]
|
||
|
|
,[VerifyChannelsDelayMS]
|
||
|
|
,[RecordingMode]
|
||
|
|
,[SamplesPerSecond]
|
||
|
|
,[PreTriggerSeconds]
|
||
|
|
,[PostTriggerSeconds]
|
||
|
|
,[NumberOfEvents]
|
||
|
|
,[StrictDiagnostics]
|
||
|
|
,[RequireConfirmationOnErrors]
|
||
|
|
,[ROIDownload]
|
||
|
|
,[ViewROIDownload]
|
||
|
|
,[DownloadAll]
|
||
|
|
,[ViewRealtime]
|
||
|
|
,[RealtimePlotCount]
|
||
|
|
,[RegionsOfInterest]
|
||
|
|
,[ROIStart]
|
||
|
|
,[ROIEnd]
|
||
|
|
,[ViewDownloadAll]
|
||
|
|
,[Export]
|
||
|
|
,[ExportFormat]
|
||
|
|
,[LabDetails]
|
||
|
|
,[UseLabDetails]
|
||
|
|
,[CustomerDetails]
|
||
|
|
,[UseCustomerDetails]
|
||
|
|
,[AllowMissingSensors]
|
||
|
|
,[AllowSensorIdToBlankChannel]
|
||
|
|
,[CalibrationBehavior]
|
||
|
|
,[LocalOnly]
|
||
|
|
,[LastModified]
|
||
|
|
,[LastModifiedBy]
|
||
|
|
,[TurnOffExcitation]
|
||
|
|
,[TriggerCheckRealtime]
|
||
|
|
,[TriggerCheckStep]
|
||
|
|
,[PostTestDiagnostics]
|
||
|
|
,[ExportFolder]
|
||
|
|
,[DownloadFolder]
|
||
|
|
,[CommonStatusLine]
|
||
|
|
,[SameAsDownloadFolder]
|
||
|
|
,[UploadData]
|
||
|
|
,[UploadDataFolder]
|
||
|
|
,[UploadExportsOnly]
|
||
|
|
,[Settings]
|
||
|
|
,[WarnOnBatteryFail]
|
||
|
|
,[Dirty]
|
||
|
|
,[Complete]
|
||
|
|
,[ErrorMessage]
|
||
|
|
,[TestEngineerDetails]
|
||
|
|
,[UseTestEngineerDetails]
|
||
|
|
,[UserTags]
|
||
|
|
,isnull([DoAutoArm], 0) as [DoAutoArm]
|
||
|
|
,isnull([CheckoutMode], 0) as [CheckoutMode]
|
||
|
|
,isnull([ISFFile], 0) as [ISFFile]
|
||
|
|
,isnull([QuitTestWithoutWarning], 0) as [QuitTestWithoutWarning]
|
||
|
|
,isnull([NotAllChannelsRealTime], 0) as [NotAllChannelsRealTime]
|
||
|
|
,isnull([NotAllChannelsViewer], 0) as [NotAllChannelsViewer]
|
||
|
|
,isnull([SuppressMissingSensorsWarning], 0) as [SuppressMissingSensorsWarning]
|
||
|
|
,isnull([DoStreaming], 0) as [DoStreaming]
|
||
|
|
,CASE WHEN [dbo].[TestSetups].[ClockSyncProfileMaster]='None' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Manual' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Slave_E2E' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Master_E2E' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Auto_E2E' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Master_E2E_IRIG' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Master_E2E_IRIG_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Master_E2E_GPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='Master_E2E_GPS_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='IRIG' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='IRIG_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='GPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='GPS_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileMaster]='EXT_PPS'
|
||
|
|
THEN [dbo].[TestSetups].[ClockSyncProfileMaster]
|
||
|
|
ELSE 'None'
|
||
|
|
END as [ClockSyncProfileMaster]
|
||
|
|
,CASE WHEN [dbo].[TestSetups].[ClockSyncProfileSlave]='None' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Manual' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Slave_E2E' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Master_E2E' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Auto_E2E' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Master_E2E_IRIG' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Master_E2E_IRIG_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Master_E2E_GPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='Master_E2E_GPS_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='IRIG' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='IRIG_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='GPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='GPS_EXT_PPS' OR
|
||
|
|
[dbo].[TestSetups].[ClockSyncProfileSlave]='EXT_PPS'
|
||
|
|
THEN [dbo].[TestSetups].[ClockSyncProfileSlave]
|
||
|
|
ELSE 'None'
|
||
|
|
END as [ClockSyncProfileSlave]
|
||
|
|
,[ExtraProperties]
|
||
|
|
,isnull([MeasureSquibResistancesStep], 0) as [MeasureSquibResistancesStep]
|
||
|
|
,[TestSetupUniqueId]
|
||
|
|
,[TestSetup]
|
||
|
|
,[WakeupAndTriggerOn]
|
||
|
|
,[WakeupTrigger]
|
||
|
|
,[WakeUpMotionTimeout]
|
||
|
|
,[TimedIntervalFrequency]
|
||
|
|
,[RTCScheduleStartDateTime]
|
||
|
|
,[RTCScheduleDuration]
|
||
|
|
,[StartWithEvent]
|
||
|
|
from [dbo].[TestSetups]
|
||
|
|
where ((@TestSetupId is null or @TestSetupId= 0) or TestSetupId = @TestSetupId)
|
||
|
|
and (@TestSetupName is null or TestSetupName = @TestSetupName);
|
||
|
|
END
|