Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Value

Description

{{{USER_NAME}}}

Current user running query

{{{PROJECT_ID}}}

The project name

{{{RESULT_INSTANCE_ID}}}

The result instance ID 

{{{RANDOM_xxx}}}

A random integer where xxx is the max integer size

{{{DATE_xxx}}}

Date/Time format, where xxx can be from the table below.  The string yyyy-MM-dd would output dates that look like 2022-07-26

{{{QUERY_NAME}}}

Query Name

{{{QUERY_STARTDATE}}}

Query Start date/time

{{{QUERY_ENDDATE}}}

Query End date/time

{{{PATIENT_COUNT}}}

Number of patients

{{{FULL_NAME}}}

Fullname of user who ran query

{{{QUERY_MASTER_ID}}}

The query Master ID

{{{QUERY_RUNTIME}}}

Time to run the query

...

ValueDescriptionValueDescription
GeraKhour-of-am-pm (0-11)
uyearkclock-hour-of-am-pm (1-24)
yyyyyyear-of-era4-digit yearHhour-of-day (0-23)
Dday-of-yearmminute-of-hour
M/Lmonth-of-yearssecond-of-minute
dday-of-monthSfraction-of-second
Q/qquarter-of-yearAmilli-of-day
Yweek-based-yearnnano-of-second
wweek-of-week-based-yearNnano-of-day
Wweek-of-monthVtime-zone ID
Eday-of-weekztime-zone name
e/clocalized day-of-weekOlocalized zone-offset
Fweek-of-monthXzone-offset 'Z' for zero
aam-pm-of-dayxzone-offset
hclock-hour-of-am-pm (1-12)Zzone-offset


ppad next

...