2023-10 hotfix: Aligning empty column value results for text field
December 12th, 2023
We recently introduced a hotfix to 2023-10
that returns ""
instead of null
for most empty column values when querying the text
field through column_values
V2. This hotfix aligns the 2023-10
behavior to what was returned in 2023-07
.
Each column does NOT have the same expected behavior. It is essential to check out the column types reference to verify the expected result for each column.
The list below summarizes the expected behavior:
- Most columns will return
""
if the column is empty; otherwise, they'll return the column value as text - Mirror, connect boards, and dependency columns will always return
null
- monday doc columns will always return
""
- Color picker, status, and dropdown columns will return
null
if the column is empty; otherwise, they'll return the column value as text - Some other columns (e.g., vote) will return a default value if the column is empty