dbo.QBM_FGIPrepropConditionDeactiv
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_ZAttestationObjectPreProp
- dbo.ATT_ZAttestationWzParmPreProp
- dbo.QBM_ZPrePropColumn
- dbo.QBM_ZPrePropColumnFK
- dbo.QBM_ZPrePropCustomizer
- dbo.QBM_ZPrePropDashBoardDef
- dbo.QBM_ZPrepropGenerateFunction
- dbo.QBM_ZPrePropGroup
- dbo.QBM_ZPrePropJob
- dbo.QBM_ZPrePropJobChain
- dbo.QBM_ZPrePropObject
- dbo.QBM_ZPrePropReport
- dbo.QBM_ZPrePropSheet
- dbo.QBM_ZPrePropTable
- dbo.QBM_ZPreProptableFK
- dbo.QBM_ZPrePropTree
- dbo.QBM_ZPrePropTreeResult
- dbo.RPS_ZPrePropRPSReport
- dbo.ATT_TIDialogTable
Complete Source
1CREATE FUNCTION dbo.QBM_FGIPrepropConditionDeactiv(2 @PreProcessorCondition nvarchar(max)3) RETURNS BIT4 WITH schemabinding5AS6BEGIN7 RETURN(CASE isnull(@PreProcessorCondition, '')8 WHEN '' THEN9 010 WHEN 'UNSB' THEN11 012 WHEN 'TIMETRACE' THEN13 114 WHEN 'SOURCEDETECTIVE' THEN15 016 WHEN 'SOFTWAREDISTRIBUTION' THEN17 118 WHEN 'RISKINDEX AND ORG' THEN19 020 WHEN 'RISKINDEX AND ESET AND ORG' THEN21 022 WHEN 'RISKINDEX AND ESET' THEN23 024 WHEN 'RISKINDEX' THEN25 026 WHEN 'REPORT_SUBSCRIPTION' THEN27 028 WHEN 'QERPOLICY AND ORG' THEN29 030 WHEN 'QERPOLICY AND ATTESTATION' THEN31 032 WHEN 'QERPOLICY' THEN33 034 WHEN 'PERSONAL' THEN35 136 WHEN 'OutOfUse' THEN37 138 WHEN 'ORG AND RISKINDEX' THEN39 040 WHEN 'ORG AND ITSHOP' THEN41 042 WHEN 'ORG AND ESET' THEN43 044 WHEN 'ORG' THEN45 046 WHEN 'NOT ARS_SSM' THEN47 048 WHEN 'Not AOB' THEN49 050 WHEN 'NOT ADS' THEN51 152 WHEN 'MAC' THEN53 054 WHEN 'LDAP AND ITSHOPSOURCE' THEN55 156 WHEN 'LDAP AND ITSHOP' THEN57 058 WHEN 'LDAP AND (ITSHOP OR ACCOUNTING)' THEN59 060 WHEN 'LDAP' THEN61 062 WHEN 'ITSHOPSOURCE AND LDAP' THEN63 164 WHEN 'ITSHOPSOURCE AND ADS' THEN65 166 WHEN 'ITSHOPSOURCE' THEN67 168 WHEN 'ITSHOP OR ATTESTATION OR QERPOLICY' THEN69 070 WHEN 'ITSHOP OR ATTESTATION' THEN71 072 WHEN 'ITSHOP OR ACCOUNTING' THEN73 074 WHEN 'ITSHOP AND LDAP' THEN75 076 WHEN 'ITSHOP AND ESET' THEN77 078 WHEN 'ITSHOP AND ADS' THEN79 080 WHEN 'ITSHOP' THEN81 082 WHEN 'GROUPEXCLUSION' THEN83 084 WHEN 'GroupAutoPublish' THEN85 186 WHEN 'EXCLUDE_STRUCTURES' THEN87 088 WHEN 'ESETEXCLUSION' THEN89 090 WHEN 'ESET AND RISKINDEX' THEN91 092 WHEN 'ESET AND ORG' THEN93 094 WHEN 'ESET' THEN95 096 WHEN 'DELEGATION' THEN97 098 WHEN 'COMPLIANCE_SIMPLEMODE' THEN99 0100 WHEN 'COMPLIANCE OR ITSHOP OR SOURCEDETECTIVE' THEN101 0102 WHEN 'COMPLIANCE Or ATTESTATION Or QERPOLICY' THEN103 0104 WHEN 'COMPLIANCE AND RISKINDEX' THEN105 0106 WHEN 'COMPLIANCE AND ORG' THEN107 0108 WHEN 'COMPLIANCE AND ITSHOP' THEN109 0110 WHEN 'COMPLIANCE' THEN111 0112 WHEN 'ATTESTATION OR ITSHOP' THEN113 0114 WHEN 'ATTESTATION AND ITSHOP' THEN115 0116 WHEN 'ATTESTATION AND COMPLIANCE' THEN117 0118 WHEN 'ATTESTATION' THEN119 0120 WHEN 'ASSET' THEN121 1122 WHEN 'ARS_SSM' THEN123 1124 WHEN 'ARS AND ARS_SSM' THEN125 1126 WHEN 'ARS' THEN127 0128 WHEN 'ADS AND ITSHOP' THEN129 0130 WHEN 'ADS' THEN131 0132 WHEN 'ACCOUNTING OR ITSHOP' THEN133 0134 WHEN '(COMPLIANCE Or ATTESTATION or QERPOLICY) and RISKINDEX' THEN135 0136 ELSE 1137 END)138ENDOpen raw exported source
1 create function dbo.QBM_FGIPrepropConditionDeactiv (@PreProcessorCondition nvarchar(max) ) returns bit with schemabinding as begin return( case2isnull(@PreProcessorCondition, '') when '' then 0 when 'UNSB' then 0 when 'TIMETRACE' then 1 when 'SOURCEDETECTIVE' then 0 when 'SOFTWAREDISTRIBUTION' 3then 1 when 'RISKINDEX AND ORG' then 0 when 'RISKINDEX AND ESET AND ORG' then 0 when 'RISKINDEX AND ESET' then 0 when 'RISKINDEX' then 0 when 'REPORT_SUBSCRIPTION'4then 0 when 'QERPOLICY AND ORG' then 0 when 'QERPOLICY AND ATTESTATION' then 0 when 'QERPOLICY' then 0 when 'PERSONAL' then 1 when 'OutOfUse' then 1 when5'ORG AND RISKINDEX' then 0 when 'ORG AND ITSHOP' then 0 when 'ORG AND ESET' then 0 when 'ORG' then 0 when 'NOT ARS_SSM' then 0 when 'Not AOB' then 0 when6'NOT ADS' then 1 when 'MAC' then 0 when 'LDAP AND ITSHOPSOURCE' then 1 when 'LDAP AND ITSHOP' then 0 when 'LDAP AND (ITSHOP OR ACCOUNTING)' then 0 when7'LDAP' then 0 when 'ITSHOPSOURCE AND LDAP' then 1 when 'ITSHOPSOURCE AND ADS' then 1 when 'ITSHOPSOURCE' then 1 when 'ITSHOP OR ATTESTATION OR QERPOLICY'8then 0 when 'ITSHOP OR ATTESTATION' then 0 when 'ITSHOP OR ACCOUNTING' then 0 when 'ITSHOP AND LDAP' then 0 when 'ITSHOP AND ESET' then 0 when 'ITSHOP AND ADS'9then 0 when 'ITSHOP' then 0 when 'GROUPEXCLUSION' then 0 when 'GroupAutoPublish' then 1 when 'EXCLUDE_STRUCTURES' then 0 when 'ESETEXCLUSION' then 0 when10'ESET AND RISKINDEX' then 0 when 'ESET AND ORG' then 0 when 'ESET' then 0 when 'DELEGATION' then 0 when 'COMPLIANCE_SIMPLEMODE' then 0 when 'COMPLIANCE OR ITSHOP OR SOURCEDETECTIVE'11then 0 when 'COMPLIANCE Or ATTESTATION Or QERPOLICY' then 0 when 'COMPLIANCE AND RISKINDEX' then 0 when 'COMPLIANCE AND ORG' then 0 when 'COMPLIANCE AND ITSHOP'12then 0 when 'COMPLIANCE' then 0 when 'ATTESTATION OR ITSHOP' then 0 when 'ATTESTATION AND ITSHOP' then 0 when 'ATTESTATION AND COMPLIANCE' then 0 when 13'ATTESTATION' then 0 when 'ASSET' then 1 when 'ARS_SSM' then 1 when 'ARS AND ARS_SSM' then 1 when 'ARS' then 0 when 'ADS AND ITSHOP' then 0 when 'ADS' 14then 0 when 'ACCOUNTING OR ITSHOP' then 0 when '(COMPLIANCE Or ATTESTATION or QERPOLICY) and RISKINDEX' then 0 else 1 end ) end