JSON column type not supported

Created on 18 July 2022, over 2 years ago

Updated 26 February 2024, 9 months ago

Problem/Motivation

I'm using the latest stable version of this module to build reports in Drupal 9 displaying data from some custom MariaDB tables. We are using MariaDB 10.5. Some of our columns are of the type JSON. These are not made available to views.

Steps to reproduce

Create a custom table, for example in the Drupal db, with one or more JSON columns.
Add the table as custom table in views custom table.
Create a new view using the custom table and see that the JSON columns are missing in the overlay adding fields to the view.

Proposed resolution

Add json to the list of text types in view_custom_table_views_data().

🐛 Bug report

Status

Fixed

Version

2.0

Component

Code

Created by

🇩🇰Denmark beltofte Copenhagen 🇩🇰

Live updates comments and jobs are added and updated live.

Incomplete comments

Merge Requests

!13JSON column type not supported
Closed
🇩🇰Denmark beltofte
updated 9 months ago

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Merge request !13Add column type json to list of text types → (Closed) created by beltofte
First commit to issue fork.
Comment 9 months ago →
System Message

joseph.olstad → committed 4222ab92 on 2.0.x authored by beltofte →
Issue #3297099 by beltofte, Rajeshreeputra: JSON column type not...
Comment 9 months ago →
🇨🇦Canada joseph.olstad
Status changed to Fixed 9 months ago4:54am 12 February 2024
Comment 9 months ago →
System Message
joseph.olstad → closed merge request !13
Comment 9 months ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024