Versions Compared

Old Version 9

changes.mady.by.user Shraddha Ranpise

Saved on

compared with

New Version Current

changes.mady.by.user Srikanth Adiga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Introduction

Currently, you can download the specimen cart report with a default set of columns. But most of the biobanks may want to include different columns or the custom fields to be included in the exported cart report. From v5.1, OpenSpecimen allows you to configure the columns in the CSV file export of the 'Specimen Cart'. This is configured at the system level settings via a "saved query".Until v5.1, the columns of the specimen cart export was fixed. Starting v5.1, you can configure the columns using a saved query at the system level. 

Step 1: Create a Query

Create a saved query with columns that you want to be displayed in the cart report.

Note this feature won't work unless you include the "specimen cart name" in the results view.
  1. (displayed with the title in the query list page)
Expand
titleClick here to view the steps...
  1. Login as super admin user and navigate to ‘Queries’
  2. Create a query, add filters and define desired columns.
  3. Important: Ensure that you include the "Specimen Cart" field in the query results view.
  4. Refer wiki page to create a new query
  5. Save the query and note the identifier of the query
Info

Step 2: Configure the Query

...

  1. Go to the specimen carts list page and click on the cart whose report has to be exported
  2. Select the specimens from a list whose details has to be exported (supported from v5.1)
  3. Click on ‘More’ button and select ‘Download Report’ to export the cart specimens report

  4. Check the columns from the exported file. It should be the same as columns defined in the query