Currently, when using Expression Filter, we can specify multiple values separated by commas when using the ‘in’ operation for a specific column. This is a very useful feature.
However, I’ve encountered an issue when trying to paste multiple query values from external sources like Excel. When I copy and paste values that are separated by line breaks, they get converted to space-separated values in the Value field.
As a result, two IDs that should be separate queries become one space-separated query, which doesn’t work as intended.
I believe this might be the issue with how copy-paste works in Datagrok. We will look into it and include in the next release, it is a useful feature indeed.
To clarify in your case, are different values separated by line breaks, or are line breaks within a particular value?