By nutanthakur on

I have created blogs, articles, practice areas, videos, faq, testimonials content type. I have used tags field in all content type. On based on tags i want to search content type and its count number.

Ex if i search with "car accident" tag, it should show all content type related to "car accident" tag.
I can list content type with their count, but it is not changing when we are moving to other page. Not able to grab current page tags and change content type results according to current page tags.

Any help would be greatly appreciated.

⋅ Categories: Drupal 7.x

Comments

nitin.k’s picture

nitin.k commented

tag_table_name is the name of table where tags are getting stored.

tag_name is the value which you need to pass in the query.

field_tags_value is the column name in which tags are getting stored. It can be a tid or value. Just put the column name exactly.


  $query = db_select('tag_table_name', 'ft');
  $query->join('node', 'n', 'n.nid = ft.entity_id');
  $query->fields('n', array('type'));
  $query->condition('ft.field_tags_value', 'tag_name');
  $query->addExpression('COUNT(n.type)', 'count');
  $query_execute = $query->execute();
  $query_data = $query_execute->fetchAll();
  dpm($query_data);
nutanthakur’s picture

nutanthakur commented

Thank you for response. There is no table like tag_table_name in db. I don't have much idea Drupal. I would be very thankful if you explain me step by step.

Thank you.

nitin.k’s picture

nitin.k commented

What is the field name of tags ??

nutanthakur’s picture

nutanthakur commented

I can see this table in my database field_data_field_blog_tags.

nitin.k’s picture

nitin.k commented

Replace ***** from the tag.


  $query = db_select('field_data_field_blog_tags', 'ft');
  $query->join('node', 'n', 'n.nid = ft.entity_id');
  $query->fields('n', array('type'));
  $query->condition('ft.field_blog_tags_value', '********');
  $query->addExpression('COUNT(n.type)', 'count');
  $query_execute = $query->execute();
  $query_data = $query_execute->fetchAll();
  dpm($query_data);