[Drupal] How to add View relationships programmatically with custom database tables in Drupal 7
https://www.zyxware.com/sites/default/files/styles/user_image/public/default_images/index.png?itok=2YmREnrP
BY dileep.kumar
6 years ago
Drupal
1
comments comment

We were faced with a situation in one of our clients Drupal sites where we had to add View relationships programmatically with custom database tables. The site was running on Drupal 7. If you are faced with the same situation in your Drupal website and want to know how to add View relationships programmatically with custom database tables in Drupal 7 then read on to know the solution.

Follow the method below to add View relationships to custom database tables

  • We had the following fields in the custom database table
    • id, type, language, name, created, node_type, entity, entity_id, created_by, source, text, changed, data
  • These custom database tables were already integrated with the View module
  • Now we needed to create a View relationship between the above fields with an existing Drupal field, i.e. between entity and entity_id field in the custom table and a Drupal entity like user, taxonomy and between an entity_id and a Drupal entity id like user_id and node_id
  • We implemented this by using the hook_views_data_alter function as follows
    function hook_views_data_alter(&$data) {
    $entity_info = entity_get_info();
    
      foreach ($entity_info as $entity_type => $info) {
    
        // Note to entity.
        $data[CUSTOM_TABLE_NAME]['CUSTOM_TABLE_NAME_related_' . $entity_type] = array(
          'group' => t(CUSTOM_TABLE_TITLE),
          'title' => t('CUSTOM_TABLE_TITLE to @entity',
            array('@entity' => drupal_ucfirst($info['label']))),
          'help' => t('The @entity entity that is associated with the .',
            array('@entity' => $info['label'])),
          'relationship' => array(
            'handler' => 'views_handler_relationship',
            'label' => t('@entity from CUSTOM_TABLE_TITLE',
              array('@entity' => $entity_type)),
            'base' => $info['base table'],
            'base field' => $info['entity keys']['id'],
            'relationship field' => 'entity_id',
            'extra' => array(
              array('table' => 'CUSTOM_TABLE_NAME', 'field' => 'entity', 'value' => $entity_type),
            ),
          ),
        );
    
      }
  • If you need professional help in customizing databases and views in your Drupal website, get in touch with us


RELATED ARTICLE

close

on 01st January 2008 / by webmaster
We have added a few new modules to our site recently. Open Source Web Development Drupal Blogging Free Software Drupalgive Leave a reply Your email address will not be published. Required fields are marker * Sean (not verified) access_time 16 Jul 2019 - 03:43 Hi there, I uploaded the files, enabled the modules to use SU, and now I see the link, but there is no icon... How can I fix this? Thanks, Sean webmaster access_time 16 Jul 2019 - 03:43 In reply to Icon doesn't show by Sean (not verified) What do you see when you view the source? Search for stumblethis_button and you should be able to see the code for the image and the URL. Then you should be able to troubleshoot from there. Juicy Couture Addict (not verified) access_time 16 Jul 2019 - 03:43 thanks for the post. would love to hear more of you. by the way, drupal's really popular nowadays as it has easy and fast features. you agree with me? thanks. Add new comment
more_horiz
close

on 16th January 2008 / by webmaster
Most webmasters do not realize this, but a lot of the content on lot of websites can be accessed from multiple URLs. A simple example would be where www.example.com and example.com leads to the same page. This is a fatal mistake in Search Engine Optimization and search engines penalize you for duplicate content. The correct configuration would be where the above two urls will lead you to the same page but example.com will redirect you to www.example.com with a 301 (Moved permanently) status which will not result in search engines penalizing the page. It is very easy to configure 301 redirects using Apache .htaccess file and the process is the same for a Drupal installation also. Web Development Drupal SEO Drupal Planet Leave a reply Your email address will not be published. Required fields are marker * Anonymous (not verified) access_time 16 Jul 2019 - 03:43 Hello. I'm trying to make example.com show as www.example.com, and I'm running into difficulties. I'm on Apache 2.0 and using the following lines in my httpd.conf file: RewriteEngine on RewriteCond %{HTTP_HOST} ^xxxxxxxxxx\.com$ [NC] RewriteRule ^(.*)$ http://www.xxxxxxxxxx.com/$1 [L,R=301] When I go to http://xxxxxxxxxx.com, I get http://www.xxxxxxxxxx.com (as expected). However, when I go to http://xxxxxxxxxx.com/node/1 (it's a Drupal site), I get a 404 thrown and the URL changes to xxxxxxxxxx.com/var/www/drupal/node/1. Same thing with www.xxxxxxxxxx.com/node/1. Any suggestions? I want to run without Drupal's .htaccess file (instead incorporating these calls into my httpd.conf file). webmaster access_time 16 Jul 2019 - 03:43 In reply to Rewrite including filesystem path by Anonymous (not verified) I think the problem is with the base path which results in the redirection to /var/www/ part. The best approach I would think is to start with drupal htaccess and then strip out parts and move to httpd SNVC (not verified) access_time 16 Jul 2019 - 03:43 This is definitely a good guide. Thanks for this. wellyson access_time 16 Jul 2019 - 03:43 This is really nice and helpful. Add new comment
close

on 07th January 2008 / by webmaster
We have volunteered to take up the maintenance of a very useful Drupal module - Search404. As of today we are the official maintainers of this very useful Drupal module. We know that this is going to be a challenge for us, being a young company and with a young team. But we do feel that it is our responsibility to give back to the Drupal community at least some part of what it has given us. Open Source Web Development Drupal Leave a reply Your email address will not be published. Required fields are marker * ian douglas (not verified) access_time 16 Jul 2019 - 03:43 I notice your updates on the Drupal modules page has some patch files, but they are patches for an older version of the 5.x branch of search404. Do you have any expectation on when a version for Drupal 6 will be ready? webmaster access_time 16 Jul 2019 - 03:43 In reply to when will search404 for drupal 6 be ready? by ian douglas (not verified) Hi Ian, We are currently working on moving Search404 to Drupal 6. The port has already been done and we should have a release up on drupal.org by tomorrow or worst case by monday. Cheers Anoop John Team Zyxware Dejan (not verified) access_time 16 Jul 2019 - 03:43 In reply to when will search404 for drupal 6 be ready? by ian douglas (not verified) I think that's been up for a while... did you check the download page? Add new comment
Leave a reply
Your email address will not be published. Required fields are marker *

Filtered HTML

  • Web page addresses and email addresses turn into links automatically.
  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type='1 A I'> <li> <dl> <dt> <dd> <h2 id='jump-*'> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
The content of this field is kept private and will not be shown publicly.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

author-image

I`ve list whole week trying to find out how to manage it. Great job. Thank you.