UCL WIKI

UCL Logo
Page tree

Versions Compared

Key

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

...

Archivist view (alspac_04_pal):


Anchor

...

==

...

Is equal to

...

!=

...

Is NOT equal to

...

...

Less than

...

Date

...

iconfalse
titleTable 1. Condition Notation

Comparisons

Date
Using Date in condition logic

When dates are represented with numbers they can be represented in different ways. This could make a number of issues when interpreting the data in a later stage. Therefore we adopt ISO 8601 standard to tackle the uncertainty by setting out an internationally agreed way to represent the dates:  YYYY-MM-DD

Example 17 Questionnaire: National Survey of Health and Development (nshd_72_mq)


Questionnaire view:

Image Added



Archivist view (nshd_72_mq):

Image Added


Anchor
Grid Coordinates
Grid Coordinates

Tip
iconfalse
titleTable 1. Condition Notation

Comparisons

==

Is equal to

!=

Is NOT equal to

Less than

Greater than

Joining

&&

To join two comparisons using an AND

||

To join two comparisons using an OR

Qualifiers

‘ (single quote)

Meta value (numeric)

“ (double quote)

Literal string (text, date)

...

When dates are represented with numbers they can be represented in different ways. This could make a number of issues when interpreting the data in a later stage. Therefore we adopt ISO 8601 standard to tackle the uncertainty by setting out an internationally agreed way to represent the dates:  YYYY-MM-DD

Example 17 Questionnaire: National Survey of Health and Development (nshd_72_mq)

Questionnaire view:

Image Removed

Archivist view (nshd_72_mq):

Image Removed

...

||

To join two comparisons using an OR

Qualifiers

‘ (single quote)

Meta value (numeric)

“ (double quote)

Literal string (text, date)



Tip
borderWidth= 500.0px;
iconfalse
titleTable 2

Grid coordinates

$Col;Row

Used to specify a cell or multiple cells of a grid


qc_example$1;1


Example

Col 1

Row 1


Row 2


Row 3



qc_example$1;2

Example

Col 1

Row 1


Row 2


Row 3



qc_example$2;*


Example

Col 1

Col 2

Col 3

Row 1




Row 2




Row 3





qc_example$*;1


Example

Col 1

Col 2

Col 3

Row 1




Row 2




Row 3





qc_example


Example

Col 1

Col 2

Col 3

Row 1




Row 2




Row 3





qc_example$2:3;*

Example

Col 1

Col 2

Col 3

Row 1




Row 2




Row 3





qc_example$1,3;*

Example

Col 1

Col 2

Col 3

Row 1




Row 2




Row 3




...