exp.Datas in Query Schema Browser

LabKey Support Forum (Inactive)
exp.Datas in Query Schema Browser jdutra  2011-12-19 09:43
Status: Closed
 
Is there any documentation anywhere on what is included in the exp.Datas built-in query? I would like to use that to detect files automatically generated by labkey that we want to delete (the ones in assaydata, for example). The query seems to be picking up most of the files in a project, including js libraries, css files, specimen upload files, etc. However, it is not picking up any of the files in unzip, a directory that I believe was created automatically when the study was imported.

If anyone could tell me how I can figure out what files I should expect to show up in that query, and which ones won't show up, it would be a big help.

Thanks,
Jen
 
 
jeckels responded:  2011-12-22 16:33
Hi Jen,

There are two general categories of files that will end up with rows in the exp.datas query:

1. Files that have been uploaded to the server using WebDav, including those uploaded by the standard file management UIs. We use the row to keep track of who uploaded the file and other metadata.

2. Files that have been referenced from assay runs and/or are referenced by runs generated by an analysis pipeline (such as MS2 or MS1 searches).

If you drop files onto the server's file system by some other mechanism, they won't automatically get a row. Also, most other server processes that produce files (such as unzipping a study archive, as you noticed) won't create rows.

I hope this helps.

Thanks,
Josh