• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
    •

    Query patients in multiple collection protocol

    Technical Questions
    #1

    Hi, just wondering is there anyway to search for patients who participate in multiple collection protocol?

    Let’s say I have collection protocol A, B and C in my system. I want to know who participates in collection protocol A alone, who participates in both A and B and who participates in all three collection protocols. How can I form a query so that it shows patients who participates in these group of collection protocols?

    Many thanks.

    #2

    Hi @Samuel_Leung,

    Yes, you can use the pivot table option in the query. Please refer to the user manual page - Query for participants registered to multiple CPs.

    Thanks,
    Neha