Page Comparison

Example 1: Age as of today 

Example 2: Age at collection

Temporal Expression: "years_between( Specimen.extensions.SpecimenCollectionEvent.time, Participant.dateOfBirth) any"

Example 3: Age at collection

Temporal Expression: "years_between( Specimen.spmnCollRecvDetails.collTime, Participant.dateOfBirth) any"

Example 4: Time difference between frozen and received time

Image Removed

Image Added

Example 5: Tissue specimens collected in the last 2 months

Example 6: Calculating the sample amount

Example 7: Count of specimens collected per month

Example 8: Count of specimens collected after a particular date

Example 9: Age in years (rounded off)

Example 10: Number of participants enrolled and parent samples entered per week.

Result view:

Example 11: Finding percent from 2 numbers in custom form

In the above example, number1 and number2 are two numeric fields defined in a form attached at 'Registration Forms' level. There is no % function in temporal queries, but the formula to find percent can directly used to calculate the same. 

Example 12: Calculating the initial cell value from the volume processed and initial concentration, where the volume processed and initial concentration are specimen custom fields.

In the above expression,

1. aj_specimen_form is the variable name of the custom form.

2. initial_processing_volume and initial_cell_volume are the variable names of the volume processed and initial concentration custom fields.

Example 13: Average of 2 custom fields.

In the above expression,

1. 'skin_cancer_registration_custom_field_form' is the variable name of the form name.

2. ‘number_field_1' and 'number_field_2’ are variable names of the custom fields.

3. The CP (e.g. 'Skin Cancer Study') must be selected, for custom forms and fields.