spGetFieldTree
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @clientsID | int | IN | |
| @fieldType | int | IN |
Definition
Copy
CREATE procedure dbo.spGetFieldTree
(
@clientsID int,
@fieldType int
)
as
select * from vwCategorizedFields where parentfieldid is null and (clientsid = @clientsid or clientsid=0) and fieldtype=@fieldtype order by [Sequence]
select * from vwCategorizedFields where parentfieldid > 0 and (clientsid = @clientsid or clientsid=0) and fieldtype=@fieldtype order by [Sequence], FieldName