Data type formatting
This table shows how data types are formatted:
| Data type | Formatted as string in CSV | Condition example CSV |
|---|---|---|
| STRING | The string as is. Double quotes are not allowed. |
EQUALS This is a string |
| INTEGER | Number as string. | <EQUALS 100 |
| DECIMAL | Number as represented in the UI. The browser locale must match the system locale where the CSV file was created. | >EQUALS 3.14 |
| BOOLEAN | TRUE or FALSE | EQUALS TRUE |
| DATETIME (UTC) | Time that is converted to UTC. Expressed in this
format:
|
< 2017-06-10 12:24:33 |
| DATE | Formatted as yyyy-MM-dd |
EQUALS 2017-06-08 |
| HYPERLINK | The link as string. | EQUALS https://www.infor.com |
| USER |
The user identifier as string. If Restriction from a specific group is configured, the data type is represented as USER(Group name). |
EQUALS someone@infor.com |
| GROUP | The group name as string. | <> TestGroup |
| CODE |
The code as string. The data type is represented as CODE(Codelist name). |
EQUALS Approved |
| Distribution to User | Formatted as USER_FROM_IFS:<user identifier>
where <user
identifier> is the IFS Person ID
field of this user. |
USER_FROM_IFS:1001 |
| Distribution to Group | Formatted as GROUP_FROM_IFS:<group name> where
<group
name> is the name of the distribution
group. |
GROUP_FROM_IFS:IONQA |