Add custom table to views drupal 7?

Question Posted / pravin kumar

1 Answers
103 Views
I also Faced
E-Mail Answers

Add custom table to views drupal 7?..

Answer / Balraj Singh

To add a custom table to Views in Drupal 7, follow these steps:nn1. Enable the Views module and the Views UI module if not already enabled.n2. Create a custom database table (using phpMyAdmin or Drush) with the necessary columns and data.n3. Implement hook_views_api() in your custom module to provide information about the new table:n```phpnfunction MYMODULE_views_api() {n return array('api' => 3, 'path' => drupal_get_path('module', 'my_module') . '/my_views.inc');}n```n4. Create a my_views.inc file in the specified path and implement hook_views_data() to define the new table and its fields:n```phpnfunction MYMODULE_views_data() {n $data = array();n $data['my_custom_table']['table']['group'] = t('Custom Tables');n $data['my_custom_table']['table']['base'] = array('alias' => 'my_table', 'title' => t('My Custom Table'));n $data['my_custom_table']['table']['fields']['field_1'] = array('id' => 'field_1', 'title' => t('Field 1'), 'help' => t('Description of Field 1'), 'field' => 'field_1');n // Add other fields as needed.n}n```

Is This Answer Correct ?

0 Yes

0 No

Post New Answer