View Source

Users can import surgical pathology reports at the visit level and additional files using custom form fields if required. It is possible to get a list of participants/visits for which the path reports were uploaded using a query.

How to create the query?

Create a new query and add a filter on the field ‘Path. Report’ under visit form like below.

OpenSpecimen > How to check if path report/custom files are uploaded? > Screen Shot 2019-12-17 at 2.41.34 AM.png

Users can click on get count to find the number of participants that have the report uploaded.

OpenSpecimen > How to check if path report/custom files are uploaded? > Screen Shot 2019-12-17 at 3.56.06 AM.png

On the query result, the user can select the column ‘Path. Report’ to view the file name like below

OpenSpecimen > How to check if path report/custom files are uploaded? > Screen Shot 2019-12-17 at 2.33.00 AM.png

Similarly, users can create a query for the file upload fields at any level. For example, a user needs to find how many participants have a file uploaded under the field of ‘Emergency Contacts’.

Create a query on the field Emergency Contacts =’Exists'

OpenSpecimen > How to check if path report/custom files are uploaded? > Screen Shot 2019-12-17 at 3.58.51 AM.png

Users can view the uploaded file name on the query result page like below.

OpenSpecimen > How to check if path report/custom files are uploaded? > Screen Shot 2019-12-17 at 3.48.53 AM.png