For field_data_field and field_revision_field tables

Posted by hiralv on November 26, 2012 at 10:53am

Hello All,

I am using Drupal 7 version and my requirement to get some records based on some conditions from custom content type. I created few CCk fields for my custom content type also. And using those custom fields want to fetch some nodes of that content type.

In this case which tables I should use ??? field_data_field_x or field_revision_field_x ??

What is the difference between these two tables and how?

Comments

You should be using

Posted by bojanz on November 26, 2012 at 9:45pm

You should be using EntityFieldQuery instead of hitting the storage directly.

Still, if you want to proceed, field_data* are the correct tables to join.