As per this discussion, “items_by_column_values” and “items_by_multiple_column_values” methods support exact matches only and the results you get are different from the one you see using the filter box in the UI.
Here’s an example.
I have three items in the board.
Their names are:
abc[three spaces]001
;abc[one space]001
;def[one space]001
.
Please note multiple spaces in the first item (I cannot display the spaces on this platform).
If I search abc[one space]001
using the search box I get two results.
The search functionality through API doesn’t work this way.
It only accepts exact matches.
If I search abc[one space]001
I get only one result.
The same if I search abc[three spaces]001
.
The solution to split the search into two API queries (abc
and 001
) doesn’t work, because I would get also def[one space]001
as a result.
Request: Please introduce regex support in the API.