[Visualize] filter doesn't work filter on scripted fields of Array Type.

[dawn023349]

Kibana version
: 8.5.3

summary
: Currently, "Visualize Library" filter query doesn't work on scripted fields of Array Type.
This happens in both 'number type' and 'string type'.

Steps to reproduce:

▪️ devTools

# 01. Create index
PUT test_index
{
  "mappings":{
    "properties":{
      "x_arr":{
        "type":"keyword"
      },
      "y_arr":{
        "type":"integer"
      }
    }
  }
}

# 02. Put Arr field doc
PUT test_index/_doc/1
{
  "x_arr":["a","b","c","d"],
  "y_arr":[1,2,3,4]
}
PUT test_index/_doc/2
{
  "x_arr":["e","f","g","h"],
  "y_arr":[5,6,7,8]
}

▪️ create data view and add scripted fields

▪️ ES field filter (click chart - "b")

▪️ ❗scripted field filter (click chart - "b")

[elasticmachine]

Pinging @elastic/kibana-visualizations @elastic/kibana-visualizations-external (Team:Visualizations)

[stratoula]

This is a bug with scripted field but as we consider them deprecated I created one runtime field instead

With the runtime field, filters work fine so I am closing this

[dawn023349]

@stratoula!
Thank you for telling me the other way.
But,
Shouldn't it be fixed because it's still available?

[stratoula]

@dawn023349 sorry if this causes any inconvenience. If the bug was in runtime fields we would have fixed that but this bug seems to exist for some minors and is on a feature that is going to be removed. So we prefer to give priority to non-deprecated features.

[dawn023349]

@stratoula , thanks for the details.
I understood what you said.
Then, can't review my pull request(#148943) for the same reason too?

[stratoula]

I am sorry, it seems we missed your contribution! (I am not part of the app-services team). If this solves the problem and doesn't create any regression, we will happily review it. I will ping the team :)

[dawn023349]

Oh!
Thank you very much for your quick and continuous reply!

I wish you a Happy New Year!😄
hope to see you again sometime.
Thank You.