Skip to content

[ES|QL] Support multivalues (or comma separated values) in named params #127556

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
stratoula opened this issue Apr 30, 2025 · 2 comments
Open
Labels
:Analytics/ES|QL AKA ESQL >enhancement ES|QL-ui Impacts ES|QL UI Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@stratoula
Copy link

stratoula commented Apr 30, 2025

Description

Right now named params in ES|QL support only one value. So if you want to support somehow multivalues in named params you can't.

You can have atm something like

WHERE field IN (?param1, ?param2)

but you can't have something like

WHERE field IN (?param)

where ?param takes comma separated values.

In a more real example, we would like at kibana to use named params in a query like this

FROM logst* | WHERE extension.keyword IN ("css", "jpg")

We want the user here to be able to send the "css", "jpg" in one named param. This will enable multivalues support at kibana ES|QL controls

Other use cases

Other cases would be a multifields support in the STATS ... BY where you can have something like

.... BY ?breakdown

and the user gives multiple fields, comma separated

The same for KEEP and DROP

Also I want to do

FROM ?sources

and the sources to be a comma separated list of index patterns

@stratoula stratoula added >enhancement needs:triage Requires assignment of a team area label ES|QL-ui Impacts ES|QL UI labels Apr 30, 2025
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/kibana-esql (ES|QL-ui)

@stratoula stratoula changed the title [ES|QL] Support multivalues in named params [ES|QL] Support multivalues (or comma separated values) in named params Apr 30, 2025
@bpintea bpintea added :Analytics/ES|QL AKA ESQL and removed needs:triage Requires assignment of a team area label labels Apr 30, 2025
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytical-engine (Team:Analytics)

@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Apr 30, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
:Analytics/ES|QL AKA ESQL >enhancement ES|QL-ui Impacts ES|QL UI Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)
Projects
None yet
Development

No branches or pull requests

3 participants