Views Custom Table

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.

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

How to use:

1. Download and extract files in module folder.
2. Enable module from module list
3. Go to Home » Administration » Structure » Views » View Custom Table
4. Add your custom table in system using "Add Custom Table" link
5. Add Relationship with drupal entities if any, otherwise leave none.
6. Clear drupal cache
7. 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'