Back to OIM Explorer

dbo.QBM_FCVJobParamOptions

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 711 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVStringToJobParameter source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL29 lines
1CREATE FUNCTION dbo.QBM_FCVJobParamOptions(2  @componentclass nvarchar(255),3  @taskname nvarchar(255),4  @parametername nvarchar(255)5) RETURNS nvarchar(max6)7AS8BEGIN9  RETURN(10  SELECT dbo.QBM_FCVStringToJobParameter(CASE11  WHEN bu.IsHidden = 1 AND bu.IsCrypted = 1 THEN12  'HIDDEN|CRYPTED'13  WHEN bu.IsHidden = 1 THEN14  'HIDDEN'15  WHEN bu.IsCrypted = 1 THEN16  'CRYPTED'17  ELSE ''18  END)19  FROM(20  SELECT21    TOP 1 isnull(isHidden, 0) AS isHidden, isnull(isCrypted, 0) AS isCrypted22  FROM jobcomponent c23  JOIN jobtask t24    ON c.uid_jobcomponent = t.uid_jobcomponent25  JOIN jobparameter p26    ON t.uid_jobtask = p.uid_jobtask27  WHERE28    c.componentclass = @componentclass AND t.taskname = @taskname AND p.name = @parametername) AS bu)29END
Open raw exported source
SQL ยท Raw6 lines
1     create   function dbo.QBM_FCVJobParamOptions (@componentclass nvarchar(255), @taskname nvarchar(255), @parametername nvarchar(255) ) returns2 nvarchar(max) as begin return( select dbo.QBM_FCVStringToJobParameter( case when bu.IsHidden = 1 and bu.IsCrypted = 1 then 'HIDDEN|CRYPTED' when bu.IsHidden3 = 1 then 'HIDDEN' when bu.IsCrypted = 1 then 'CRYPTED' else '' end ) from ( select top 1 isnull(isHidden, 0) as isHidden , isnull(isCrypted, 0) as isCrypted4 from jobcomponent c join jobtask t on c.uid_jobcomponent = t.uid_jobcomponent join jobparameter p on t.uid_jobtask = p.uid_jobtask where c.componentclass5 = @componentclass and t.taskname = @taskname and p.name = @parametername ) as bu ) end 6