USP_OLAPCONFIG_GETSMARTFIELDS

Returns the smart fields that are configured for use in the datamart for the given record type.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPENAME	nvarchar(50)	IN

Definition

Copy



CREATE PROCEDURE dbo.USP_OLAPCONFIG_GETSMARTFIELDS
@RECORDTYPENAME nvarchar(50) 

as

select SF.ID,SF.NAME,SFC.SMARTFIELDSPECXML,SF.TABLECATALOGID from dbo.SMARTFIELD AS SF

INNER JOIN dbo.SMARTFIELDCATALOG AS SFC ON SF.SMARTFIELDCATALOGID=SFC.ID

INNER JOIN dbo.RECORDTYPE AS RT ON SFC.RECORDTYPEID=RT.ID

WHERE 

(RT.NAME=@RECORDTYPENAME)

AND 
(
    (SFC.DATATYPECODE IN (1/*int*/,3/*money*/)) and (SF.USEVALUEGROUP=1)
    OR
    SFC.DATATYPECODE IN (
                        4/*bool*/,
                        2/*date*/,
                        0/*string*/
                        )
)

ORDER BY SFC.SMARTFIELDFOLDER,SFC.DISPLAYNAME;