Did you know that you can include Carts in queries?

[Prathamesh_Sontakke]

There could be many reasons to see Cart information in a query. For example:

1. See how many carts a specimen is present in.
2. See the number of carts vs the number of specimens in it.
3. Circumvent the limitation of configuring columns per cart
4. Circumvent the limitation of carts displaying only 100 specimens at a time

You can work around this by utilizing the Query module, where you can do the following:

• Retrieve all specimens from one or more carts.
• Ability to choose fields from different levels
• Add advanced filters such as calculated fields and parameterized search
• Run count-based queries

Sample output: Show carts to which the specimen is added.

For more detailed information on creating these queries, please refer to this wiki page.

Thanks,
OpenSpecimen Team