Pooling Part 2 (Web) – Search and View

Introduction – 00:00

Hi there, welcome to the Freezerworks 2022 Learning Series, your visual guide to our sample management software. Today, we will continue our deep dive into the exciting, brand new feature, Pooling. In Pooling Part 1, we created a pooling workflow, processed it, and took a quick look at what a Pooled Sample is like in Freezerworks. In this video, we will discuss how to search for Pooled Samples and their Source Aliquots on the Web Client, including a new form of Saved Searches specially designed for finding Pooled Samples. We will also go into detail about viewing Pooling data through two new Samples Entry Form tabs: Pool Details and Pools.

Pooling Fields – 01:00

Finding Pooled Samples and Source Aliquots is actually quite simple through the use of two new System True/False Fields: the Aliquots Field “In Pool” and the Samples Field “Pooled Sample”. These Fields can be used in all types of searches to find both Aliquots that were used to make Pooled Samples, and the Pooled Samples themselves. If I just want to pull up all Pooled Samples in my database, I can run a search for Samples where Pooled Sample is equal to TRUE. I can then use the filter tools to cut my list down to just Pooled Samples that came from a specific Facility, or had a specific test result. The same can be done for Source Aliquots – I can pull up all Aliquots that are involved in Pools by searching for Aliquots where “In Pool” is equal to TRUE. I can then filter the list down to just Source Aliquots that are in a specific Freezer, or have a specific amount left. Again, these Fields will be usable throughout the program to make finding Pooled data very simple.

Saved Searches – 02:10

However, there is an extra feature we added to Saved Searches to make searching for Pooled Samples more robust. If you set the Return Records in dropdown to “Pooled Samples”, two tabs will appear on the search form: Pooled Sample Criteria and Source Aliquots Criteria. First, using the Pooled Sample Criteria tab, you determine what attributes of Pooled Samples themselves you are looking for: the date it was pooled, the Initial Volume Pooled, the Number of Sources, which Group is the owner, etc. Next, you determine what attributes you’re looking for in the Source Aliquots that created the desired Pooled Samples, since Source Aliquots have their own separate data and origin Samples which will probably factor into your search. For example, what is the type of Aliquot, what facility was its Sample originally collected at, who was the doctor that collected it, how much volume did it have to start, etc. Essentially, you’re taking two distinct searches and combining them to find Pooled Samples that match all criteria. An example of a Pooled Sample search might be “I want Pooled Samples pooled in the last twenty days that come from Source Aliquots collected at the University of Washington of type Nasal Swab.” It should also be noted that both tabs need to have an expression to run the search.

Pool Details, Pools, and Traceability – 03:32

Let’s run our search now and open a Pooled Sample. As I mentioned in Part 1, all Pooled Samples will have a new page: Pool Details. This page includes data points for the Pooled Sample (Initial Volume Pooled and Date Pooled), but most importantly, it lists all Source Aliquots that were combined to create the Pooled Sample. The list displays metadata for each Source Aliquot, based on the selected List View Format (just like the inventory list view). If you’d like to trace an Aliquot back to its origin Sample or Patient, highlight the desired Aliquot and choose the desired action. You can open the Aliquot’s Patient or Sample, or open it in the inventory list view to quickly see everything related to the Source Aliquot. If you highlight a selection of the Source Aliquots and select View Aliquots in List View again, you will open all selected Aliquots in the inventory list view, making it very easy to trace all Patients and Samples that went into making the Pooled Sample. Not to mention, the inventory list view gives you access to all the tools Freezerworks has to offer.

Let’s go back to the Pool Details page and open a Source Aliquot’s origin Sample to see another Pooling-related page you will come across. If a Sample has Aliquots that are sources for Pooled Samples, the Pools page will appear. This page will display each Source Aliquot that comes from the Sample you have open. The Source Aliquots are identifiable by their Unique Aliquot IDs by default, but you can switch the display field if you’d like with this dropdown. Click a Source Aliquot in the list to see each Pooled Sample it is a part of. Alternatively, you can use the Expand All and Collapse All buttons to affect everything in the list. The Pooled Samples are identifiable by their Freezerworks IDs by default, but again you can easily change the display field. Select a Pooled Sample and its details will display on the right. If you click the Open Sample button at the bottom of the details box, its entry form will open. As you can see, traceability exists in both directions.

Conclusion – 06:00

And that about does it for Pooling in the Freezerworks Web Client! Please note that everything discussed today exists in the Desktop Client too. You can learn how to search for and view Pooling data there in Part 2, but know that these tools function nearly identically in both clients. If you have any questions, consult our User’s Guide or contact Freezerworks Support staff. As always, thank you for watching, and see ya next time!