Hello, I’ve been working with files lately and I’ve come across something strange. In the FileValue column we have access to FileDocValue, FileLinkValue and FileAssetValue.
I try to use compare_value and the contains_terms operator to filter files. And here comes the problem, namely for the FileDocValue column this search does not work. This is probably due to the fact that the property value which is a string consisting of many fields, contains name and this name is null. On the other hand in DocValue: FileDocValue we can see that in value name has value of docs name.
From my analysis, it turns out that contains_terms operates on this name in value prop, which is why when we try to use compare_value and operator contains_terms, null is returned for the FileValue: FileDocValue columns. Is this intentional or is it an oversight and bug?
This is my query:
query getFiles($boardsIds: [ID!]!) {
complexity {
query
}
boards(ids: $boardsIds) {
id
name
items_page(
limit: 500
query_params: {rules:
{column_id: "column_id",
operator: is_not_empty,
compare_value: ""}}
) {
items {
id
name
column_values {
... on DocValue {
value
text
file {
doc {
name
}
}
}
... on FileValue {
text
value
files {
__typename
... on FileAssetValue {
asset {
name
}
}
... on FileDocValue {
doc {
name
}
}
... on FileLinkValue {
name
}
}
}
}
}
}
}
}
As you can see name has value in _typename: DocValue but it is null in FileValue
