inst/QueryLibrary/Assign/concept_name/measurement_limit.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

measurement_limit

Description

This query is similar to the "measurement" query but limits the output to a certain number of person_ids (using the offset and limit parameters).

Query

SELECT m_name.concept_name as measurement_name, m_typ.concept_name as measurement_type, m_unit.concept_name as unit, m_visit.concept_name as visit, vo.visit_source_value as visit_label, m.*
FROM @cdm.measurement AS m
INNER JOIN @vocab.concept as m_name ON m.measurement_concept_id = m_name.concept_id
INNER JOIN @vocab.concept as m_unit ON m.unit_concept_id = m_unit.concept_id
LEFT JOIN @vocab.concept as m_typ ON m.measurement_type_concept_id = m_typ.concept_id
LEFT JOIN @cdm.visit_occurrence as vo ON m.visit_occurrence_id = vo.visit_occurrence_id
LEFT JOIN @vocab.concept as m_visit ON vo.visit_concept_id = m_visit.concept_id
WHERE m.person_id IN
    (SELECT person_id FROM (SELECT  person_id FROM  @cdm.person order by 1) a OFFSET COALESCE($1,0) LIMIT $2) 

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | offset| 100 | No | Skip this number of person_id s | | limit | 100 | Yes| Keek only this number of person_ids |

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.