Often you need to create queries where some of the fields will be entered by the users when running it. E.g. show specimens collected for a certain date range. Here the collection date will be entered by the user during executing the query.
This is achieved by "parameterizing' the query filters. Using the parameterized filters, users can create a single query, save it and use the filters runtime to query for data.
Steps to create a parameterized filter:
Return all samples for a particular "SPR number" (here SPR number is to be parameterized)
2. Add another filter for clinical diagnosis with "is one of" for 5 fields as in the screenshot below
The filters that are parameterized are now available in the left side. Users can now select one or more values and results on the right grid is displayed accordingly.
On expanding the filter, users can type in the path number they are looking for at that particular time.
Same for the clinical diagnosis field