view -> executa essa query SELECT        T.tocid AS IdDocLf, T.parentid, T.name AS Titulo, T.modified AS DataModificacao, T.created AS DataCriacao, T.pagecount, PD.prop_name AS Propriedade, COALESCE (COALESCE (COALESCE (PV.str_val, 
                         PV.short_str_val), CAST(PV.num_val AS varchar)), CAST(PV.date_val AS varchar)) AS Valor
FROM            LSLASERFICHE.DBSRC.dbo.toc AS T INNER JOIN
                         LSLASERFICHE.DBSRC.dbo.propval AS PV ON T.tocid = PV.tocid INNER JOIN
                         LSLASERFICHE.DBSRC.dbo.propdef AS PD ON PV.prop_id = PD.prop_id