• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Jun 092011
 

If you want to know which file types are in a particular FSA File Type Group, you can run the following types of query :

 

SELECT     FileGroup.FileGroupName AS FileGroupName,
FSP.FileTypeExtension AS FileExt
FROM       FileGroup INNER JOIN
FileGroupFile ON FileGroup.FileGroupEntryId = FileGroupFile.FileGroupEntryId
INNER JOIN  FileSpecification FSP
ON FSP.FileTypeIdentity =  FileGroupFile.FileTypeIdentity

The one above lists all file type groups, and the file extensions associated with them.

SELECT     FSP.FileTypeExtension AS FileExt
FROM       FileGroup INNER JOIN
FileGroupFile ON FileGroup.FileGroupEntryId = FileGroupFile.FileGroupEntryId
INNER JOIN  FileSpecification FSP
ON FSP.FileTypeIdentity =  FileGroupFile.FileTypeIdentity
WHERE       FileGroup.FileGroupName = ‘Office Files’

The one above lists the file extensions belonging to the Office Files file type group.  The output looks like this :

FileExt
———–

*.doc
*.xls
*.ppt
*.pps
*.mdb
*.docx
*.docm
*.dotx
*.dotm
*.xlsx
*.xlsm
*.xltx
*.xltm
*.xlsb
*.xlam
*.pptx
*.pptm
*.potx
*.potm
*.ppam
*.ppsx
*.ppsm

(22 row(s) affected)

Of course you can also look them up in the VAC.

Props to Nathan Clark for the original query.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)