Thanks, however I don't seem to have access to the same fields using this method.
SELECT * FROM View_CONTENT_File_Joined
The results of the above query would indicate I have access to the FileAttachment, FileID and FileName properties.
When setting the Document types property within the repeater web part settings, I am able to display these properties using the Eval() method in a transformation.
When setting the Document type using the Where condition as suggested above i.e.
this.WhereCondition = "ClassName='cms.file' "
I am not able to access FileAttachment, FileID or FileName properties.