search

d4software / QueryTree

Data reporting and visualization for your app
http://querytreeapp.com
GNU Lesser General Public License v3.0
341 stars 122 forks source link

Add support on jsonb type columns Postgres #104

Closed WeedBilbao closed 4 years ago

WeedBilbao commented 4 years ago

Recently added QueryTree for doing some report over my Postgres DB.

My table has one column defined as jsonb which is not even listed on the supported column types here. Not even as regular text.

It causes a bug when trying to filter it, no filtering criteria are listed in the dropdown: image

It would be great adding support to read the jsons listed all over the rows of a table and adding the possibility to filter by each field.

At least, a quicker solution would be treating jsonb columns as text so it can be filtered.

Anyway, I'd like to chart values of the json as well, so a deeper solution is required.

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.