DESCRIPTION

This formula creates list of options to be shown in a radio, check or combo ITEM type. General use: Stratification form.
Calculated:	On first form open.
Formula:	GET_LIST()
Calculation	Retrieves a list of values from the selected SCOPE. The values returned depend on the type of OBJECT* and the required property (passed as a parameter of the function)*

SCOPE VALUES

The possible SCOPE values are:

The PROTOCOL of the ADMISSION related with the TASK or EVENT the FORM belongs to (be aware that some TASKS or EVENTS may not necessarily be related with an ADMISSION)

SCOPE	DESCRIPTION
ADMISSION	The ADMISSION related with the TASK or EVENT the FORM belongs to (be aware that some TASKS or EVENTS may not necessarily be related with an ADMISSION)
TASK	The TASK the FORM belongs to
PROGRAM	The PROTOCOL of the ADMISSION related with the TASK or EVENT the FORM belongs to.
FORM	The FORM in which the FORMULA is applied

PROPERTIES

The properties to be retrieved from the selected form object are listed in the following table:

SCOPE

PROPERTY

PARAMETER

OPTIONS

DESCRIPTION

COMMENTS

EXAMPLES

"FORM"

"DATA_CODE"

[DATA_CODE]

Ex: "SATO2"

(See CODE OPTIONS)

Recovers a list of values of the ITEMS with the DATA_CODE specified in PARAMETER (it will usually be an ARRAY, or a question with multiple choices like VERTICAL_CHECK or HORIZONTAL_CHECK)

Useful to show as a check list with the values associated to a DATA_CODE.

If the DATA_CODE refers to an array of ITEMs (property ITEM.ARRAY > 0), only the different values will be returned (implementation pending)

If the DATA_CODE refers to an ITEM of TYPE CHECK, a list of the selected options will be returned

If the DATA_CODE refers to an ITEM with a single answer, only that answer will be returned (implementation pending)

We have a FORM with a previous ITEM of type ARRAY:

Question.LITERAL = "PRESCRIPTION:"
Question.TYPE = V_CHECK
Question.DATA_CODE = "DRUGS.ALCANTARA.ACTIVE"
Question.OPTIONS = "DRUG.ALCANTARA" (no está implementado todavía "DRUG.ALCANTARA:root", pero no importa porque todos los códigos son "root")
NUM_ASOCIADAS=1

We define some subsequent ITEM o type VERTICAL_CHECK that should show options based on the answer of the previous ITEM with DATA_CODE="DRUGS.ALCANTARA.ACTIVE":

Question.LITERAL="PRESCRIPTIONS SUMMARY:"
Question.TYPE=V_CHECK
Question.DATA_CODE="DRUGS.ALCANTARA.ACTIVE"
Question.OPTIONS=GET_LIST ("FORM", "DATA_CODE",
"DRUGS.ALCANTARA.ACTIVE")

Returns all values in the FORM with DATA_CODE DRUG.ALCANTARA.ACTIVE

Returns:

TEXT	VALUE
PARACETAMOL	968818
ASPIRINE	969196

[CODE]

Ex: "DRUG.ALCANTARA"

(This value corresponds to the name of the ID_STANDARD_CODE in CODES OBJECT)

To convert the list of value retrieved into a list values with the description of the CODE

Previously, there is an ITEM in the FORM of type ARRAY:

LITERAL="PRESCRIPTION:"
TYPE=CODE
DATA_CODE="DRUGS.ALCANTARA.ACTIVE"
OPTIONS="DRUG.ALCANTARA" (no está implementado todavía "DRUG.ALCANTARA:root", pero no importa porque todos los códigos son "root")
NUM_ASOCIADAS=1

The entry:

LITERAL="PRESCRIPTIONS SUMMARY:"
TYPE=V_CHECK
DATA_CODE="DRUGS.ALCANTARA.ACTIVE. CODES"
OPTIONS=GET_LIST ("FORM", "DATA_CODE","DRUGS.ALCANTARA.ACTIVE", "DRUGS.ALCANTARA")

Returns all values in the FORM with DATA_CODE DRUG.ALCANTARA.ACTIVE with the description associated to the DRUGS.ALCANTARA CODE:

TEXT	VALUE
CICLOCHEM VAGINAL, 1 tubo de 40 g	968818
PERSANTIN 100 mg comprimidos recubiertos, 50 comprimidos	969196
FUNGOWAS 1% 30ML SOLUCION DERMATOLOGICA	969345
NOIAFREN 20MG 20 COMPRIMIDOS	969386
SUPREFACT 5,5ML 2 VIALES MULTIDOSIS SOL INYECTABLE	969626

[PARENT_CODE] < [CHILDREN_CODE]

Ex: "DRUG.ALCANTARA.CLASS < DRUG.ALCANTARA"

To convert the list of value retrieved into a list of parents of the CHILDREN:CODE

LITERAL="PRESCRIPTION":
TYPE=CODE
DATA_CODE="DRUGS.ALCANTARA.CLASS.ACTIVE"
OPTIONS="DRUG.ALCANTARA" (no está implementado todavía "DRUG.ALCANTARA:root", pero no importa porque todos los códigos son "root")
NUM_ASOCIADAS=1

GET_LIST ("FORM", "DATA_CODE", "DRUGS.ALCANTARA.ACTIVE", "DRUG.ALCANTARA.CLASS < DRUG.ALCANTARA")

El valor DRUG.ALCANTARA.CLASS < DRUG.ALCANTARA convierte los valores extraídos del DATA_CODE "DRUGS.ALCANTARA.ACTIVE" del tipo DRUG.ALCANTARA en sus correspondientes padres en DRUG.ALCANTARA.CLASS.

Es decir, con el contenido del DATA_CODE indicado, se buscan los CODES del ID_STANDARD_CODE "DRUG.ALCANTARA.CLASS", y a partir de ellos obtiene sus padres:

CODE = DRUG.ALCANTARA	CODE = DRUG.ALCANTARA.CLASS
968701	BRONCODIL
968818	BETABLOCK
969196	BRONCODIL
969345	BRONCODIL
969386	BRONCODIL

Pero solo aparecen los valores que no están repetidos:

DESCRIPTION	VALUE
BRONCODILADATOR	BRONCODIL
BETABLOQUEANTE	BETABLOCK

TASK

DATA_CODE

[DATA_CODE]

Recovers the description of the elements with the DATA_CODE (it will usually be an ARRAY) using as value the VALUE of the DATA_CODE

To show as a check a list of values associated to a DATA_CODE

Same example that FORM

CODE

Recovers the description of the elements with the DATA_CODE (it will usually be an ARRAY) using as value the VALUE of the DATA_CODE

To convert the list of value retrieved into a list values with the description of the CODE

PARENT_CODE < CHILDREN_CODE

Recovers the description of the elements with the DATA_CODE (it will usually be an ARRAY) using as value the VALUE of the DATA_CODE

To convert the list of value retrieved into a list of parents of the CHILDREN:CODE

TASK_CODE

[TASK_CODE]

Recovers name of the TASKs with the TASK_CODE indicated

Literal in language of session

GET_LIST ("TASK", "TASK_CODE","SPIRO:MANEUVER:BAS")

FORM_CODE

[FORM_CODE]

Recovers forms from TASK with FORM_CODE indicado

Literal in language of session

GET_LIST(“TASK”,”FORM_CODE”,”MANEUVER:BAS”)

ADMISSION

DATA_CODE

[DATA_CODE]

Recovers the description of the elements with the DATA_CODE (it will usually be an ARRAY) using as value the VALUE of the DATA_CODE

To show as a check a list of values associated to a DATA_CODE

Same example that FORM

CODE

Recovers the description of the elements with the DATA_CODE (it will usually be an ARRAY) using as value the VALUE of the DATA_CODE

To convert the list of value retrieved into a list values with the description of the CODE

PARENT_CODE < CHILDREN_CODE

Recovers the description of the elements with the DATA_CODE (it will usually be an ARRAY) using as value the VALUE of the DATA_CODE

To convert the list of value retrieved into a list of parents of the CHILDREN:CODE

TASK_CODE

[TASK_CODE]

Recovers name of the TASKs with the TASK_CODE indicated

Literal in language of session

GET_LIST ("ADMISSION", "TASK_CODE",”SPIRO:MANEUVER:BAS”)

FORM_CODE

[FORM_CODE]

Recovers forms from ADMISSION with FORM_CODE indicado

Literal in language of session

GET_LIST(“ADMISSION”,”FORM_CODE”,”MANEUVER:BAS”)

PROGRAM

PROTOCOLS

Recovers the name of the PROTOCOLS included in the PROGRAM that belongs the FORM were the FORMULA is inserted.

Literal in language of session

GET_LIST ("PROGRAM", "PROTOCOLS")

CODE

CODE OPTIONS

"VALUE"|"DESC"

(If not indicated, by default is "VALUE")

Evaluates a CODE or CODE tree expression and returns in answer the result/s.

GET_LIST("CODE","#RELATIVE[id=$1])>#GENDER",VALUE)

Returns all the children of RELATIVES with id=$1 related with GENDER in a CODE_TREE

Browser not supported