V_QUERY_BATCHNUMBERINGSCHEME

Fields

Field	Field Type	Null
ID	uniqueidentifier
NAME	nvarchar(200)
NEXTBATCHNUMBER	nvarchar(100)	yes
ISGLOBAL	bit
ISGLOBALICON	varchar(87)	yes
NUMBERINGSCHEMECODE	tinyint

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:08:40 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BATCHNUMBERINGSCHEME AS



with BATCHNUMBERINGSCHEMES_CTE as (
  select distinct
    BATCHTEMPLATE.BATCHNUMBERINGSCHEMEID,
    case 
      when exists (
            select null  
              from dbo.V_INSTALLED_BATCHTYPECATALOG
              where V_INSTALLED_BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID
              ) then 1
          else 0
          end as INSTALLEDPRODUCT
  from dbo.BATCHTEMPLATE
  where BATCHTEMPLATE.CUSTOM = 0
)
select
  BATCHNUMBERINGSCHEME.ID,
  BATCHNUMBERINGSCHEME.NAME,
  case BATCHNUMBERINGSCHEME.NUMBERINGSCHEMECODE
    when 0 then dbo.UFN_BATCHNUMBERINGSCHEME_GETNEXTBATCHNUMBER(BATCHNUMBERINGSCHEME.ID)
    else '<' + BATCHNUMBERINGSCHEME.NUMBERINGSCHEME + '>'
    end as NEXTBATCHNUMBER,
  BATCHNUMBERINGSCHEME.ISGLOBAL,
  case BATCHNUMBERINGSCHEME.ISGLOBAL
    when 1 then 'catalog:Blackbaud.AppFx.Platform.Catalog.dll,Blackbaud.AppFx.Platform.Catalog.check.png'
    else null
    end as ISGLOBALICON,
  BATCHNUMBERINGSCHEME.NUMBERINGSCHEMECODE
from dbo.BATCHNUMBERINGSCHEME
left join BATCHNUMBERINGSCHEMES_CTE on BATCHNUMBERINGSCHEMES_CTE.BATCHNUMBERINGSCHEMEID = BATCHNUMBERINGSCHEME.ID                
where BATCHNUMBERINGSCHEMES_CTE.INSTALLEDPRODUCT is null or BATCHNUMBERINGSCHEMES_CTE.INSTALLEDPRODUCT = 1