Read, filter, update, and clear world clock columns using the monday.com platform API
The world clock column displays the current time for a selected global timezone.
Via the API, the world clock column supports read, filter, update, and clear operations.
Column Type | Implementation Type | Supported Operations |
|---|---|---|
|
|
|
Queries
World clock columns can be queried through the column_values field on items queries using an inline fragment on WorldClockValue.
query {
items(ids: [1234567890, 9876543210]) {
column_values {
... on WorldClockValue {
text
timezone
}
}
}
}Fields
You can use the following fields to specify what information your WorldClockValue implementation will return.
| Field | Description |
|---|---|
column Column! | The column the value belongs to. |
id ID! | The column's unique identifier. |
text String | The column's value as text. Returns "" if the column has an empty value. |
timezone String | The selected timezone (e.g., "Europe/London"). |
type ColumnType! | The column's type. |
updated_at Date | The column's last updated date. |
value JSON | The column's JSON-formatted raw value. |
Filter
You can filter items by world clock values using the items_page object. The world clock column supports the following operators:
| Operators | Compare Values |
|---|---|
any_of | The timezone name shown in the UI |
not_any_of | The timezone name shown in the UI |
Example
This example returns all items with a world clock set to "Samoa".
query {
boards(ids: 1234567890) {
items_page(
query_params: {
rules: [
{
column_id: "world_clock"
compare_value: ["Samoa"]
operator: any_of
}
]
}
) {
items {
id
name
}
}
}
}Mutations
Update
You can update a world clock column using change_multiple_column_values by passing a JSON object in column_values.
Send a valid IANA timezone in Continent/City format.
mutation {
change_multiple_column_values(
item_id: 9876543210
board_id: 1234567890
column_values: "{\"world_clock\": {\"timezone\": \"Europe/London\"}}"
) {
id
}
}Clear
You can clear a world clock column using change_multiple_column_values by passing null or an empty object in column_values.
mutation {
change_multiple_column_values(
item_id: 9876543210
board_id: 1234567890
column_values: "{\"world_clock\": null}"
) {
id
}
}