About

View custom table module provide you functionality to integrate your custom table data to views, and access all it's column in views. This module use hook_view_data to add custom tables in views. this module provides you following functionalities.

Auto integrate custom table data to views
Auto map mysql data types with drual data types
Extend relationship of custom table data to drupal entities

How to use:

Download and extract files in module folder.
Enable module from module list
Go to Home » Administration » Structure » Views » View Custom Table
Add your custom table in system using "Add Custom Table" link
Add Relationship with drupal entities if any, otherwise leave none.
Clear drupal cache
Add a new view and you will see your custom table name in "Show" drop-down field.

Notes for developers

Each custom table must have a primary key.
Column related to drupal entity must be numeric.

Drupal 8

Steps to install module and use module is same, but for drupal 8 date sort is not implemented yet, we will update it very soon.

Install with Composer: Drupal 8 & 9
$ composer require 'drupal/view_custom_table:^2.0'

RTBC issues for Views Custom Table

Filters