UFN_EXPORTDEFINITION_SMARTFIELDVALUEGROUPISINUSEBY
Examines the XML definition of each export definition in the database to determine whether the given smart field value group is in use.
Return
| Return Type |
|---|
| nvarchar(200) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OBJECTNAME | nvarchar(128) | IN | |
| @VALUEGROUPFIELDNAME | nvarchar(255) | IN |
Definition
Copy
create function dbo.UFN_EXPORTDEFINITION_SMARTFIELDVALUEGROUPISINUSEBY
(
@OBJECTNAME nvarchar(128),
@VALUEGROUPFIELDNAME nvarchar(255)
)
returns nvarchar(200)
as
begin
declare @RETURNVALUE nvarchar(200);
select @RETURNVALUE = [EXPORTDEFINITION].[NAME]
from dbo.[EXPORTDEFINITION]
where exists ((select 1
from EXPORTDEFINITIONXML.nodes('ExportDefinitionQueryViewNode/Nodes/n[@ObjectName=sql:variable("@OBJECTNAME")]/Fields/f[@Name]') as T(c)
where
(T.c.value('@Name', 'nvarchar(max)') = isnull(@VALUEGROUPFIELDNAME, ''))));
if @RETURNVALUE is null set @RETURNVALUE = '';
return @RETURNVALUE;
end;