Possible to also specify custom select when using the table view?
已回答
I'm talking about this here
It's possible to provide where conditions.
Often I wish I could also have the same here for SELECT without having to do to console. Use-cases are:
- limit the columns shown
- use json operators to extract data within
Is this possible currently?
请先登录再写评论。
Markus,
You can filter data. If you put condition in <Filter Criteria> it will appear in WHERE clause. Is that what you need?
Read feature description https://www.jetbrains.com/datagrip/features/data_editor.html
No, it's not about filtering. I know I can use WHERE conditions here, that's what the field is for 😅
But I wish I could use that view too to provide custom SELECTed columns or expression, _without_ having to go to console and write a full query.
Thanks