88 lines
4.6 KiB
Plaintext
88 lines
4.6 KiB
Plaintext
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[foo_DBExportTestSetupFields]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
|
|
DROP FUNCTION [dbo].[foo_DBExportTestSetupFields]
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[foo_DBExportTestSetupFields]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
|
|
BEGIN
|
|
execute dbo.sp_executesql @statement = N'CREATE FUNCTION [dbo].[foo_DBExportTestSetupFields]
|
|
(
|
|
@TestSetupId int
|
|
)
|
|
RETURNS xml
|
|
AS
|
|
BEGIN
|
|
RETURN isnull((
|
|
SELECT [TestSetupName] as SetupName
|
|
,[SetupDescription]
|
|
,[AutomaticTestProgression]
|
|
,[AutomaticProgressionDelayMS]
|
|
,[InvertTrigger]
|
|
,[InvertStart]
|
|
,[ViewDiagnostics]
|
|
,[VerifyChannels]
|
|
,[AutoVerifyChannels]
|
|
,[VerifyChannelsDelayMS]
|
|
,[RecordingMode]
|
|
,[SamplesPerSecond]
|
|
,[PreTriggerSeconds]
|
|
,[PostTriggerSeconds]
|
|
,[StrictDiagnostics]
|
|
,[RequireConfirmationOnErrors]
|
|
,[ROIDownload]
|
|
,[ViewROIDownload]
|
|
,[DownloadAll]
|
|
,[ViewRealtime]
|
|
,[RealtimePlotCount]
|
|
,[ROIStart]
|
|
,[ROIEnd]
|
|
,[ViewDownloadAll]
|
|
,[Export]
|
|
,[ExportFormat]
|
|
,[LabDetails]
|
|
,[UseLabDetails]
|
|
,[CustomerDetails]
|
|
,[UseCustomerDetails]
|
|
,[AllowMissingSensors]
|
|
,[AllowSensorIdToBlankChannel]
|
|
,[LocalOnly]
|
|
,[LastModified]
|
|
,[LastModifiedBy]
|
|
,[TurnOffExcitation]
|
|
,[TriggerCheckRealtime]
|
|
,[TriggerCheckStep]
|
|
,[PostTestDiagnostics]
|
|
,[ExportFolder]
|
|
,[DownloadFolder]
|
|
,[CommonStatusLine]
|
|
,[SameAsDownloadFolder]
|
|
,[UploadData]
|
|
,[UploadDataFolder]
|
|
,[Settings]
|
|
,[WarnOnBatteryFail]
|
|
,[Dirty]
|
|
,[Complete]
|
|
,[ErrorMessage]
|
|
,[TestEngineerDetails]
|
|
,[UseTestEngineerDetails]
|
|
,[UserTags]
|
|
,[DoAutoArm]
|
|
,[CheckoutMode]
|
|
,[QuitTestWithoutWarning]
|
|
,[ISFFile]
|
|
,[NotAllChannelsRealTime]
|
|
,[NotAllChannelsViewer]
|
|
,[SuppressMissingSensorsWarning]
|
|
FROM [dbo].[TestSetups]
|
|
where [TestSetupId] = @TestSetupId
|
|
for xml path(''''), BINARY BASE64, root (''Fields'')), ''<Fields />'')
|
|
END
|
|
|
|
|
|
'
|
|
END
|
|
|
|
GO
|