Versions Compared

Old Version 1

changes.mady.by.user Harshita Shivhare

Saved on

compared with

New Version 2

changes.mady.by.user Harshita Shivhare

Saved on

Key

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

Example: User wishes to display the list of specimens that are not reserved for any distribution

The details about ‘Reservation ID’, ‘Reservation DP’ and ‘Reservation Date’ in the subform ‘Reservation Details’ are present only for specimens that are currently reserved for some distribution. These filters can be used to find out the specimens that are/are not reserved for a distribution protocol.Example: User wishes to display the list of specimens that are not reserved for any distribution

Steps to create a query:

  1. Go to ‘Home’ > ‘Queries’ > ‘Create’

  2. Search for ‘Reservation Details’ under ‘Specimen’ filter on the left-hand side

  3. Click on ‘Reservation ID’, select the operator as ‘Not Exists’ and ‘Add’

  4. All other additional conditions can be added along with this filter. This filter will ensure that no reserved specimens appear in the result view.

...