dbo.QBM_FGIConfigparmValue
Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB
Interpretation
- Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.
Relations
- No extracted relations.
Typed Edges
- No typed edges extracted for this source.
References
- No direct source references extracted.
Referenced By
- dbo.ATT_FTOrgAttHighest
- dbo.ATT_FTOrgRulerHighest
- dbo.DPR_FTProjectionRootRunning
- dbo.QER_FTOrgAttHighest
- dbo.QER_FTOrgRulerHighest
- dbo.QER_FTPWOOrderPerson_000
- dbo.QER_FTPWOOrderPerson_001
- dbo.QER_FTPWOOrderPerson_010
- dbo.QER_FTPWOOrderPerson_011
- dbo.QER_FTPWOOrderPerson_100
- dbo.QER_FTPWOOrderPerson_101
- dbo.QER_FTPWOOrderPerson_110
- dbo.QER_FTPWOOrderPerson_111
- dbo.ATT_FGIPWOTaskToUse
- dbo.DPR_FGIProjectionRootRunning
- dbo.QBM_FCVDatetimeToNextWork
- dbo.QBM_FCVJobParamDeflate
- dbo.QBM_FGIDBQueueSlotsCurrent
- dbo.QBM_FSQTriggerPartCEF
- dbo.QBM_FSQWatchRevision
- dbo.QER_FGICultureForPerson
- dbo.QER_FGIITShopNewPersonOrdered
- dbo.QER_FGIPWOTaskToUse
- dbo.QER_FGIPwoValidDateRangeAssign
- dbo.QER_FGIPwoValidDateRangesExist
- dbo.QER_FGIPWOVisibleForPerson
- dbo.ADS_ZAccountInADSGroup
- dbo.ADS_ZADSMachineInADSGroup
- dbo.ADS_ZContactInADSGroup
- dbo.ADS_ZOrgHasADSGroup
- dbo.ADS_ZPersonHasObject
- dbo.ATT_PAttestationCaseDeleteOld
- dbo.ATT_PAttestationHelperFill
- dbo.ATT_RAttestationHelperFill_Cfg
- dbo.ATT_ZAttestationHelperFill_Cfg
- dbo.ATT_ZAttHelperFill_Recalc
- dbo.CPL_ZITShopMakeDecisionCR
- dbo.CPL_ZITShopMakeDecisionOC
- dbo.CPL_ZITShopMakeDecisionOH
- dbo.LDP_ZAccountInLDAPGroup
- dbo.LDP_ZLDPMachineInLDAPGroup
- dbo.LDP_ZOrgHasLDAPGroup
- dbo.LDP_ZPersonHasObject
- dbo.QBM_PDBQCS_SlotRunner
- dbo.QBM_PDBQueueCalculateDelta
- dbo.QBM_PDBQueueInsert_Int
- dbo.QBM_PDBQueuePondTimeOut
- dbo.QBM_PDBQueueReplGenProcID
- dbo.QBM_PDialogProcessGetShrinkDef
- dbo.QBM_PJobCreate
- dbo.QBM_PJobQueueDelete
- dbo.QBM_PJobQueueDelete_Bulk
- dbo.QBM_PJobQueueInit_i
- dbo.QBM_PJobQueueLoad
- dbo.QBM_PJobQueueStatsShrink
- dbo.QBM_PJobUpdateState_Bulk
- dbo.QBM_PJournalShrink
- dbo.QBM_PLoginAuditShrink
- dbo.QBM_PProcessGroupCreate
- dbo.QBM_PScheduleCheck
Complete Source
1CREATE FUNCTION dbo.QBM_FGIConfigparmValue(2 @fullpath nvarchar(512)3) RETURNS nvarchar(10244)5AS6BEGIN7 RETURN(8 SELECT TOP 1 x.wert9 FROM(10 SELECT TOP 1 CASE11 WHEN p.IsEnabledResulting = 1 AND p.Value > N ' ' THEN12 p.Value13 ELSE N ''14 END AS wert, 1 AS Sortierung15 FROM DialogConfigParm p16 WITH(nolock)17 WHERE18 p.FullPath = @fullpath19 UNION all20 SELECT21 N '', 2) AS x22 ORDER BY x.Sortierung)23ENDOpen raw exported source
1 create function dbo.QBM_FGIConfigparmValue ( @fullpath nvarchar(512) ) returns nvarchar(1024) as begin return( select top 1 x.wert from2 ( select top 1 case when p.IsEnabledResulting = 1 and p.Value > N' ' then p.Value else N'' end as wert , 1 as Sortierung from DialogConfigParm p with 3(nolock) where p.FullPath = @fullpath union all select N'', 2 ) as x order by x.Sortierung ) end 4