Что такое findslide.org?

FindSlide.org - это сайт презентаций, докладов, шаблонов в формате PowerPoint.


Для правообладателей

Обратная связь

Email: Нажмите что бы посмотреть 

Яндекс.Метрика

Презентация на тему AQL functions for state

instruction-aggregate-state(instruction_identifier)Returns the aggregated state of the given INSTRUCTION as a String current-state(activity_identifier) Returns the current state of the given ACTIVITY as a String Two functions for state
AQL functions for state instruction-aggregate-state(i)current-state(ac)Bjørn Næss, DIPS ASA instruction-aggregate-state(instruction_identifier)Returns the aggregated state of the given INSTRUCTION as a String current-state(activity_identifier) Examples SELECT 	i FROM 	INSTRUCTION i WHERE	instruction-aggregate-state(i) = 'ACTIVE'SELECT  acFROM PRE-ACTIVEinitial stateNo activity in active, inactive or terminated stateACTIVEAt least one Activity ACTIVITY – CURRENT STATE Functions in SELECT and WHERE SELECT current-state(ac) FROM   EHR e
Слайды презентации

Слайд 2 instruction-aggregate-state(instruction_identifier)
Returns the aggregated state of the given INSTRUCTION

instruction-aggregate-state(instruction_identifier)Returns the aggregated state of the given INSTRUCTION as a String

as a String
current-state(activity_identifier)
Returns the current state of

the given ACTIVITY as a String

Two functions for state


Слайд 3 Examples
SELECT i
FROM INSTRUCTION i
WHERE instruction-aggregate-state(i) =

Examples SELECT 	i FROM 	INSTRUCTION i WHERE	instruction-aggregate-state(i) = 'ACTIVE'SELECT acFROM INSTRUCTION

'ACTIVE'
SELECT ac
FROM INSTRUCTION i CONTAINS ACTIVITY

ac
WHERE current-state(ac) = 'ACTIVE'

Слайд 4 PRE-ACTIVE
initial state
No activity in active, inactive or terminated

PRE-ACTIVEinitial stateNo activity in active, inactive or terminated stateACTIVEAt least one

state
ACTIVE
At least one Activity is active
INACTIVE
All Activities are

inactive
TERMINATED
All Activities are terminated (completed, cancelled, aborted )

INSTRUCTION AGGREGATED STATE


Слайд 5 ACTIVITY – CURRENT STATE

ACTIVITY – CURRENT STATE

id="524" rubric="initial"/>

rubric="postponed"/>








Returns the ‘rubric’ of the instruction states terminology


  • Имя файла: aql-functions-for-state.pptx
  • Количество просмотров: 94
  • Количество скачиваний: 0