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

    Advanced Participant Query with Different visits

    Technical Questions
    #1

    Hi,
    How can we find the patient set with following two conditions in OS query tool:

    1. In a visit a patient must have benign liver tissue which means pathological status is one of ([“Non-Malignant”, “Non-Malignant, Diseased”, “Pre-Malignant”]

    AND

    1. Same patient but must have different visit, he/she must has plasma sample

    Basically how can we restrict the different visit in query tool? We are using OS 3.4
    Jennifer

    #2

    Jennifer,

    Yes, this is possible. You can do it using the “intersection” type.

    The following resources should help you:
    a. AQ training video: http://www.openspecimen.org/video/advanced-query-training/
    b. Example query on demo site: http://demo.openspecimen.org/openspecimen/#/queries/addedit?queryId=60
    c. Help page: https://openspecimen.atlassian.net/wiki/x/EEb9B

    ~Sri