This list includes all Arezzo functions and operators, and all Arezzo terms that represent information about a MACRO study element.
|
Function/Operator |
Description |
| abs | An arithmetic function used to return the absolute value of an expression |
| and | A logical operator |
| any | A set operator used to test a set of responses to a many-valued question |
| average | A set function used to return the arithmetic mean of a set of numbers |
| between | A comparison operator used to compare values in a numerical range |
| case | A conditional function equivalent to nested 'if' expressions |
| count | A set function used to return the number of items in a set |
| date | A date/time function used to represent a date |
| dateof | A date/time function used to return the time at which a question response was entered |
| datepart | A date/time function used to return an integer representing one part of a date/time expression |
| datenow | A date/time function used to represent the current date |
| datetime | A date/time function used to represent a date and time |
| date_diff | A date/time function used to return an arithmetical calendar difference |
| every | A set operator used to test a set of responses to a many-valued question |
| form | A MACRO term that represents the code of the current eForm |
| form:cycle | A MACRO term that represents the cycle number of the current eForm |
| form:date | A MACRO term that represents the date of the current eForm |
| format_date | A date/time function used to display dates in a format of your own choosing |
| full_date | A date/time function used to convert a partial date to a full date |
| if | A conditional function |
| includes | A set operator used to test set membership |
| isafter | A date/time comparison operator used with a single date/time |
| isbefore | A date/time comparison operator used with a single date/time |
| isduring | A date/time comparison operator used with a date/time period |
| isknown | A general function used to check for the existence of a value |
| is_partial_date | A date/time function used to identify if a date is partial |
| len | A text function used to return the length of the given text string |
| like | A comparison operator use to compare text values |
| log | An arithmetic function used to return the base 10 logarithm of an expression |
| max | A set function used to return the maximum value or latest date/time in a set |
| me:value | A MACRO term that represents the value of the question being validated |
| min | A set function used to return the minimum value or earliest date/time in a set |
| neg | An arithmetic function used to return the negative value of an expression |
| not | A logical operator |
| now | A date/time function used to represent the current date and time |
| oneof | A set operator used to test set membership |
| or | A logical operator |
| person:clinicaltrialname | A MACRO term that represents the code of the current study |
| person:trialsite | A MACRO term that represents the site code of the current subject |
| person:personid | A MACRO term that represents the integer identifier assigned to the current subject |
| person:subjectidentifier | A MACRO term that represents the text identifier assigned to the current subject during registration |
| person:country | A MACRO term that represents the name of the country to which the current site belongs |
| question | A MACRO term that represents the code of the current question |
| question:ctcgrade | A MACRO term that represents the CTC grade of the named laboratory test question |
| question:cycle | A MACRO term that represents the cycle number (i.e. row number) of the current question |
| question:nrstatus | A MACRO term that represents the Normal Range status of the named laboratory test question |
| question:username | A MACRO term that represents the full name of the user who has answered the specified question |
| read_date | A date/time function used to return a date/time value from a text string |
| round | An arithmetic function used to round the value of an expression to a specified number of decimal places |
| sqrt | An arithmetic function used to return the square root of an expression |
| substring | A text function used to return characters from a text string |
| sum | A set function used to return the sum of a set of numbers |
| time | A date/time function used to represent a time |
| timenow | A date/time function used to represent the current time |
| time_diff | A date/time function used to return elapsed time, in whole time units |
| user:username | A MACRO term that represents the full name of the currently logged-on user |
| user:userrole | A MACRO term that represents the user role of the currently logged-on user |
| valid_date | A date/time function used to check a text string for a valid date/time |
| visit | A MACRO term that represents the code of the current visit |
| visit:cycle | A MACRO term that represents the cycle number of the current visit |
| visit:date | A MACRO term that represents the date of the current visit |