How do I implement a JSON/JSONB data type field to display data as separate columuns?
I have a custom table that consists of 2 columns, id and data. I want to create a view table with filter. The table columns should be id, product, and item. product and item are from the data column which contains JSON data (for example {"product": "a", "item": "b"}
).
Is it possible to create this type of view?
As per my knowledge, it’s not possible to create because a view works with columns that exist in the database table.
This article was republished from its original source.
Pixeldust is a 20-year-old web development agency specializing in Drupal and WordPress and working with clients all over the country. With our best in class capabilities, we work with small businesses and fortune 500 companies alike. Give us a call at 1(800)730-2416 and let’s talk about your project.