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
  • URL
  • Download Link
  • Thumbnail Link
  • Inline Thumbnail image
  • etc...

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.
    • Or
  • 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:
SELECT Data.Name,
Data.Run,
Data.DataFileUrl,
Data.InlineThumbnail,
Data.DownloadLink
FROM Data

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:

scans
├───patient1
│ ├───CT
│ └───PET
└───patient2
├───CT
└───PET

The following SQL query harvests out the patient id and the scan type from the directory structure above.

SELECT Data.Name as ScanName,
Data.DataFileUrl,
split_part(DataFileUrl, '/', 8) as Ptid,
split_part(DataFileUrl, '/', 9) as ScanType
FROM Data
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.

Related Topics

Discussion

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand all collapse all