Query for anticipated visits/specimens

The anticipated visits/specimens query is designed for planned participant centric studies. This query will not work for any specimen centric protocol since there are no events or specimen requirements configured on the basis of which the query works.

Based on collection protocol time points, it is now possible to query for anticipated visits and specimens for planned collections. For example, query for expected specimens for participants of a protocol in next week. OpenSpecimen ships a default job and query for anticipated visits and specimens which set to run on demand. The job can be run for the desired CPs since all CPs may not be planned.

Configuring Job

 Click here to expand...
  1. Login as a super administrator user and navigate to 'Jobs'.
  2. Click on edit option of the 'Refresh anticipated specimens' scheduled job.
  3. Include the collection protocol ID for which query on anticipated visits/specimens is to be enabled. The list of CPs is configured by specifying comma separated CP ID values.
  4. The system administrators can configure the job to run every night or every hour depending on the needs of their users


Running query

 Click here to expand...
  1. After the CP is configured and the computation is done at least once, the CP users can start querying anticipated visits using the default query 'Anticipated visits in next month'.
  2. In the below image, the user is interested in knowing the list of participants whose visits are due in the next months
  3. Select the required columns under the node Participant -> Anticipated Specimens in the columns view
  4. Query results will then display the list of anticipated visits and pending primary specimens to be collected from patients in the next 3.5 months


Disable the wide rows option from columns configuration, this will ensure the anticipated visits and specimens are not displayed in one row for each participant on the results view.