When files are added to the File Repository, metadata about each file is recorded in the table exp.Data. The information about each file includes:
- File Name
- Download Link
- Thumbnail Link
- Inline Thumbnail image
To access the table, go to Admin > Developer Links > Schema Browser
and open the query ext.Data, or add a Query web part that exposes the query exp.Data.
To create a grid that shows the metadata columns, do one of the following:
- Create a custom view of the grid exp.Data, and expose the custom view by adding a Query web part.
- Create a custom query using exp.Data as the base query, and add the columns using SQL. For example, the following SQL query adds the columns InlineThumbnail and DownloadLink to the base query:
Pulling Metadata from File Paths
You can pull out more metadata, if you conform to a path naming pattern.
In the following example, CT and PET scans have been arranged in the following folder pattern:
The following SQL query harvests out the patient id and the scan type from the directory structure above.
SELECT Data.Name as ScanName,
split_part(DataFileUrl, '/', 8) as Ptid,
split_part(DataFileUrl, '/', 9) as ScanType
WHERE locate('/@files/scans', DataFileUrl) > 0
The result is a table of enhanced metadata about the files, which provides new columns you can filter on, to narrow down to the files of interest.