vwCategorizedFields

Fields

Field	Field Type	Null
FieldID	int
ParentFieldID	int	yes
FieldName	nvarchar(50)	yes
Sequence	int	yes
HasMultiples	bit
Searchable	bit
PrivateShowByDefault	bit	yes
NeverPrivate	bit
FieldType	int
CategorySequence	int	yes
Category	nvarchar(50)	yes
FormField	bit
HTMLEncode	bit
AttribTypeID	int
DataType	int
CodeTableID	int
AttribRequired	int
ClientsID	int
StaticCodeTable	bit
UseShortDescription	bit
RowNumber	int	yes
IsLoop	bit	yes
CounterFieldID	int
StripSpanTags	bit
ToolTip	nvarchar(1024)	yes

Definition

Copy



            CREATE view dbo.vwCategorizedFields as
                select
                    Fields.FieldID, 
                    Fields.ParentFieldID, 
                    Fields.FieldName, 
                    Fields.Sequence, 
                    Fields.HasMultiples, 
                    Fields.Searchable, 
                    Fields.PrivateShowByDefault, 
                    Fields.NeverPrivate, 
                    Fields.FieldType, 
                    Category.Sequence CategorySequence, 
                    Category.FieldName Category, 
                    Fields.FormField, 
                    Fields.HTMLEncode, 
                    Fields.AttribTypeID, 
                    Fields.DataType, 
                    Fields.CodeTableID, 
                    Fields.AttribRequired, 
                    Fields.ClientsID, 
                    Fields.StaticCodeTable, 
                    Fields.UseShortDescription, 
                    Fields.RowNumber, 
                    cast(0 as bit) IsLoop, 
                    0 CounterFieldID,
                    Fields.StripSpanTags,
                    Fields.ToolTip
                from
                    dbo.ApplicationFields Fields
                    inner join dbo.Clients on 1 = 1
                    left outer join dbo.ApplicationFields Category on Fields.ParentFieldID = Category.FieldID
                where
                    Fields.CountryMask & Clients.RECountryMask = Clients.RECountryMask;