Views Custom Table
4,902 sites
Security covered
This module allows you to integrate your custom database tables into Drupal's Views system. It automatically maps your table's data types and enables you to create relationships between your custom table and Drupal entities, making the data accessible within views.
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'