View's Calculated Fields
I want to query the repository in order to retrieve all the view's calculated fields (not necessarily being used in reports).
i tried the following query with no luck:
WHERE ViewId = 3470127
AND FieldTemplateId NOT IN ( SELECT FieldTemplateId
FROM dbo.ReportField )
AND RefRltshpTypeCode = 'CALCFIELDSIMPLE'