Kibana canvas filter

Elastic Stack Kibana
1

What is alternative for "level, rownum" in Kibana sql??

I need to build my filter like:

select
 (case LEVEL
  when 1 then 'xyz'
  when 2 then 'xzt'
...
end) as D,
select
 (case LEVEL
  when 1 then '1'
  when 2 then '2'
...
end) as R

Thanks,
Pat

2

Unfortunately, I think there's no alternative for row id in essql.

3

Ok, thank You. I think it could be new feature in Kibana SQL.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.