dbo.QER_ZPersonFindGenerateFunct

1    create   procedure QER_ZPersonFindGenerateFunct (@SlotNumberDummy int , @dummy1 varchar(38) , @dummy2 varchar(38) , @dummyGenProcID varchar(38
2) ) as begin declare @DisabledBy varchar(1024) = dbo.QBM_FGIConfigparmValue('QER\Person\PasswordResetAuthenticator\DisabledBy') declare @EnabledBy varchar
3(1024) = dbo.QBM_FGIConfigparmValue('QER\Person\PasswordResetAuthenticator\EnabledBy') declare @SearchColumn varchar(1024) = dbo.QBM_FGIConfigparmValue
4('QER\Person\PasswordResetAuthenticator\SearchColumn') declare @SearchTable varchar(30) = dbo.QBM_FGIConfigparmValue('QER\Person\PasswordResetAuthenticator\SearchTable'
5) declare @DisabledConverted nvarchar(max) declare @EnabledConverted nvarchar(max) declare @PersonColumnName varchar(30) declare @FunctionName varchar(30
6) = 'QER_FTPersonFindByTSProp' declare @FunctionBody nvarchar(max) declare @header nvarchar(max) = 'create or alter function dbo.QER_FTPersonFindByTSProp( @CompareValue nvarchar(400) 
7											)
8	returns @erg table (UID_Person varchar(38) 
9						)
10as 
11begin
12	insert into @erg(UID_Person)
13'
14 declare @footer nvarchar(max) = '
15
16return
17
18end
19
20' declare @DebugSwitch int = 0 declare @ResetMessage nvarchar(4000) BEGIN TRY if @DebugSwitch > 
210 begin select @SearchColumn = 'cn|DistinguishedName|GivenName' select @SearchTable = 'ADSAccount' select @DisabledBy = 'AllowDialIn|IsGroupAccount'   
22    end select top 1 @PersonColumnName = r.ChildColumn from QBM_VQBMRelation r join QBMModuleDef d on dbo.QBM_FCVGUIDToModuleOwner(r.UID_QBMRelation) =
23 d.ModuleName where r.ChildTable = @SearchTable and r.ParentTable = 'Person'  order by d.SortOrder asc if @SearchTable = 'Person' begin select @PersonColumnName
24 = 'UID_Person' end  select @DisabledConverted =  concat('
25	-- disabled
26	and ' , replace(@DisabledBy, '|', ' = 0 and ') , ' = 0' ) select @EnabledConverted
27 =  concat('
28	-- enabled
29	and ' , replace(@EnabledBy, '|', ' = 1 and ') , ' = 1' )  if @SearchColumn > ' ' and @SearchTable > ' ' begin select @FunctionBody
30 = concat( @header, '
31	select ', @PersonColumnName , ' 
32	from ', @SearchTable , ' 
33	where ', ( select concat( '(', String_agg(concat(s.Parameter1 , 
34' = @CompareValue ') , ' or '), ')' ) from dbo.QBM_FCVStringToList_i(@SearchColumn, '|', 1, 0, '') s ), '  
35		', case  when @EnabledBy > ' ' then @EnabledConverted
36 else '' end , case when @DisabledBy > ' ' then @DisabledConverted else '' end , @footer )  end else begin  select @FunctionBody = concat(@header, ' select p.UID_Person
37	from Person p
38	where p.CentralAccount = @CompareValue
39
40	'
41, @footer ) end if @DebugSwitch > 0 begin print @functionbody end BEGIN TRY    if dbo.QBM_FGIDBOwner() = 'CCC' begin select @FunctionBody = dbo.QBM_FSQRemoveComment_i
42(@FunctionBody, 1) end exec QBM_PExecuteSQLWithRetry_LLP @SQLStatement = @FunctionBody , @LockTimeout_ms = default , @MaxWaitTimeForLock_s = default , 
43@ProcIDForJournal = default , @HandleErrorSilent = 0 , @ExecuteWithTransact = 0 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage
44 = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec QBM_PDBQueueCurrentResetNGen @SlotNumberDummy , @ResetMessage , @@PROCID END CATCH END TRY
45 BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
46