Get Medications List

Specification

Purpose

This WS is designed to return Medications list by filters.

Input parameters (filters)

• id (optional)
• innm_id (optional)
• name (optional, as `LIKE *`)
• innm_name (optional, as `LIKE *`)
• form (optional)

Logic WS

1. Verify the validity of access token
2. Check user scopes in order to perform this action (scope = 'medication:read')

3. Search Medications by filters in payload

   SELECT * FROM medications MED
   	INNER JOIN medications INNM
   		ON MED.ingredients.id = INNM.id 
   			AND MED.ingredients.is_active_substance = TRUE
   WHERE MED.type == MEDICATION
   	AND (MED.id == $.id OR $.id IS NULL)
   	AND (INNM.id == $.innm_id OR $.innm_id IS NULL)
   	AND (MED.form == $.form OR $.form IS NULL)
   	AND (MED.name LIKE `%$.name%` OR $.name IS NULL)
   	AND (INNM.name LIKE `%$.innm_name%` OR $.innm_name IS NULL)