Exemples de requêtes
Recherche d’un médicament
Recherche par UCD
BrandedDrug
{
branded_drug(where: { codings: { code: { _eq: "9202254" } } }) {
designation
clinical_drug {
designation
form {
designation
}
clinical_drug_component {
clinical_drug_component {
strength {
value
}
ingredient {
designation
}
}
}
}
packaged_drugs {
packaged_drug {
designation
}
}
}
}Recherche par CIP
BrandedDrug
{
branded_drug(
limit: 5
where: {
packaged_drugs: {
packaged_drug: { codings: { code: { _eq: "3400934779619" } } }
}
}
) {
designation
clinical_drug {
form {
designation
}
clinical_drug_component {
clinical_drug_component {
strength {
value
}
ingredient {
designation
}
}
}
}
packaged_drugs {
packaged_drug {
designation
}
}
}
}Recherche par nom
BrandedDrug
{
branded_drug(where: { designation: { _ilike: "%xeplion%" } }) {
designation
clinical_drug {
designation
form {
designation
}
clinical_drug_component {
clinical_drug_component {
strength {
value
}
ingredient {
designation
}
}
}
}
packaged_drugs {
packaged_drug {
designation
}
}
}
}Recherche par molécule
BrandedDrug
{
branded_drug(
where: {
clinical_drug: {
clinical_drug_component: {
clinical_drug_component: {
ingredient: { designation: { _ilike: "%palmitate%" } }
}
}
}
}
limit: 2
) {
designation
clinical_drug {
designation
form {
designation
}
clinical_drug_component {
clinical_drug_component {
strength {
value
}
ingredient {
designation
}
}
}
}
packaged_drugs {
packaged_drug {
designation
}
}
}
}Recherche des alternatives via l’ATC
BrandedDrug
{
branded_drug(
where: {
codings: { code: { _ilike: "N04AA" }, terminology: { _ilike: "ATC5" } }
}
) {
designation
clinical_drug {
designation
form {
designation
}
clinical_drug_component {
clinical_drug_component {
strength {
value
}
ingredient {
designation
}
}
}
}
packaged_drugs {
packaged_drug {
designation
}
}
}
}Obtenir des données pour un médicament
Obtenir la monographie
ClinicalDrug
{
clinical_drug(limit: 1) {
designation
branded_drugs {
documents {
document {
source
sections {
section {
titles {
designation
}
content
}
}
}
}
}
}
}Obtenir l’UCD à partir du CIP
PackagedDrug
{
packaged_drug(where: { codings: { code: { _ilike: "4949770" } } }) {
designation
codings {
code
terminology
}
}
}Obtenir les spécialités à partir d’un médicament virtuel
ClinicalDrug
{
clinical_drug(where: { codings: { code: { _ilike: "MV00000399" } } }) {
designation
branded_drugs {
designation
codings {
code
label
terminology
}
}
}
}Obtenir les interactions
ClinicalDrug
{
clinical_drug(where: { codings: { code: { _ilike: "MV00000399" } } }) {
designation
ingredients_mixture {
designation
ingredients {
ingredient {
designation
origin_of_interactions {
designation
origin_ingredient {
designation
}
origin_group
interaction_origin_excluded_forms {
form {
designation
coding {
code
label
terminology
}
}
}
interaction_origin_excluded_pathways {
pathway {
designation
coding {
code
label
terminology
}
}
}
interaction_origin_included_forms {
form {
designation
coding {
code
label
terminology
}
}
}
interaction_origin_included_pathways {
pathway {
designation
coding {
code
label
terminology
}
}
}
target_ingredient {
designation
}
target_group
interaction_target_excluded_forms {
form {
designation
coding {
code
label
terminology
}
}
}
interaction_target_excluded_pathways {
pathway {
designation
coding {
code
label
terminology
}
}
}
interaction_target_included_forms {
form {
designation
coding {
code
label
terminology
}
}
}
interaction_target_included_pathways {
pathway {
designation
coding {
code
label
terminology
}
}
}
interaction_detail {
type_recommandation_enum {
text
}
risk {
text
}
guideline {
text
}
}
}
}
}
}
}
}Obtenir les indications
ClinicalDrug
{
clinical_drug(where: { codings: { code: { _ilike: "MV00002018" } } }) {
designation
clinical_indication_details {
clinical_indication {
condition {
designation
associated_conditions {
associated_condition {
designation
}
}
modifiers {
modifier {
text
}
}
}
therapeutic_use {
designation
combination_treatment {
ingredients {
ingredient {
designation
}
}
procedures {
procedure {
label
}
}
therapeutic_classes {
therapeutic_class {
label
}
}
}
intents {
intent_enum {
text
}
}
therapies {
therapy_enum {
text
}
}
treatment_types {
treatment_type_enum {
text
}
}
}
patient_criterion {
adjunct_treatment {
ingredients {
ingredient {
designation
}
}
procedures {
procedure {
label
}
}
therapeutic_classes {
therapeutic_class {
label
}
}
}
age_groups {
age_group {
text
}
}
continuous_criterions {
continuous_criterion {
min_value
max_value
unit {
text
}
type {
text
}
}
}
gender {
text
}
}
comment
}
}
}
}Obtenir les effets indésirables
ClinicalDrug
{
clinical_drug(where: { codings: { code: { _ilike: "MV00000399" } } }) {
designation
adverse_effect_details {
adverse_effect {
behaviour
comment
condition {
designation
}
incidence_enum {
text
}
patient_criterion {
gender {
text
}
age_groups {
age_group {
text
}
}
continuous_criterions {
continuous_criterion {
max_value
min_value
type {
text
}
unit {
text
}
}
}
adjunct_treatment {
ingredients {
ingredient {
designation
}
}
therapeutic_classes {
therapeutic_class {
code
label
terminology
}
}
procedures {
procedure {
code
label
terminology
}
}
}
}
}
}
}
}Obtenir les contre-indications
ClinicalDrug
{
clinical_drug(where: { codings: { code: { _ilike: "NV65643371" } } }) {
designation
alerts {
alert {
designation
type_recommandation_enum {
text
}
contra_indication {
condition {
designation
modifiers {
modifier {
text
}
}
associated_conditions {
associated_condition {
designation
}
}
}
level {
text
}
patient_criterion {
adjunct_treatment {
ingredients {
ingredient {
designation
}
}
procedures {
procedure {
label
}
}
therapeutic_classes {
therapeutic_class {
label
}
}
}
age_groups {
age_group {
text
}
}
continuous_criterions {
continuous_criterion {
min_value
max_value
unit {
text
}
type {
text
}
}
}
gender {
text
}
}
}
alert_warnings {
warning {
risk
modifiers {
modifier {
text
}
}
guidelines {
guideline {
text
}
}
}
}
}
}
}
}Obtenir les voies d’adminisatration
Pathway
{
pathway(where: { coding: { code: { _ilike: "ROA%" } } }, limit: 10) {
designation
coding {
code
label
terminology
}
}
}Obtenir des CIM10
Obtenir une CIM10 à partir du code
Coding
{
coding(
where: { terminology: { _eq: "cim10" }, code: { _ilike: "a0%" } }
order_by: { code: asc }
) {
code
label
terminology
}
}Obtenir une CIM10 à partir du nom
Coding
{
coding(
where: { terminology: { _eq: "cim10" }, label: { _ilike: "%infection%" } }
order_by: { code: asc }
) {
code
label
terminology
}
}Obtenir une CIM10 à partir d’un médicament
BrandedDrug
{
branded_drug(where: { codings: { code: { _eq: "9202254" } } }) {
designation
clinical_drug {
designation
clinical_indication_details(
where: {
clinical_indication: {
condition: {
codings: { coding: { terminology: { _eq: "cim10" } } }
}
}
}
) {
clinical_indication {
condition {
codings(where: { coding: { terminology: { _eq: "cim10" } } }) {
coding {
code
}
}
}
}
}
}
}
}