Deva, Rather than querying the base tables directly (which isn't a very good idea, since Field API isn't meant to be used that way), you could use EntityFieldQuery which is designed for just such a task. http://api.drupal.org/api/drupal/includes--entity.inc/class/EntityFieldQuery... -Mikey P Deva wrote:

Thanks Randy. I got the solution though.

Drupal 7 creates new table for each vocabulary. look for table named "field_data_<vocabulary machine name>". Node - term relation is stored in that table.

On Tue, Sep 6, 2011 at 6:06 PM, Randy Fay <randy@randyfay.com <mailto:randy@randyfay.com>> wrote:

I would imagine you'd want to use views (probably with views bulk operations), which allows full control of this.

However, you may want to use access control, which is a lot more flexible than the all-or-nothing published/unpublished status. You may want to look at the Content Access + ACL modules.

-Randy

On Tue, Sep 6, 2011 at 8:14 AM, Deva <devendra.in@gmail.com <mailto:devendra.in@gmail.com>> wrote:

Hello Everyone,

I came across the situation where i want to show unpublished content on the site. (For review kind of thing) I am displaying nodes related to a taxonomy term using taxonomy_select_nodes function. The problem is, it only returns published nodes related to particular taxonomy term. Is there any other solution/function to get all nodes related to a term, regardless of the node state (published/unpublished)?

Thanks in advance.

-- :DJ

-- Randy Fay Drupal Module and Site Development randy@randyfay.com <mailto:randy@randyfay.com> +1 970.462.7450 <tel:%2B1%C2%A0%20970.462.7450>

-- :DJ

-- __________________ Michael Prasuhn 503.512.0822 office mike@mikeyp.net http://mikeyp.net

Quick update: Drupal doesn't create table like "field_data_<vocabulary machine name>" But it creates table with "field_data_<CCK field name given to term reference>" :) On Wed, Sep 7, 2011 at 2:05 AM, Deva <devendra.in@gmail.com> wrote:

Thank you very much Mikey. You are right. I also not prefer querying the database. I'll have a look.

On Tue, Sep 6, 2011 at 10:54 PM, Michael Prasuhn <mike@mikeyp.net> wrote:

...

Deva,

Rather than querying the base tables directly (which isn't a very good idea, since Field API isn't meant to be used that way), you could use EntityFieldQuery which is designed for just such a task.

http://api.drupal.org/api/**drupal/includes--entity.inc/** class/EntityFieldQuery/7<http://api.drupal.org/api/drupal/includes--entity.inc/class/EntityFieldQuery/7>

-Mikey P

Deva wrote:

...

Thanks Randy. I got the solution though.

Drupal 7 creates new table for each vocabulary. look for table named "field_data_<vocabulary machine name>". Node - term relation is stored in that table.

On Tue, Sep 6, 2011 at 6:06 PM, Randy Fay <randy@randyfay.com <mailto:randy@randyfay.com>> wrote:

I would imagine you'd want to use views (probably with views bulk operations), which allows full control of this.

However, you may want to use access control, which is a lot more flexible than the all-or-nothing published/unpublished status. You may want to look at the Content Access + ACL modules.

-Randy

On Tue, Sep 6, 2011 at 8:14 AM, Deva <devendra.in@gmail.com <mailto:devendra.in@gmail.com>**> wrote:

Hello Everyone,

I came across the situation where i want to show unpublished content on the site. (For review kind of thing) I am displaying nodes related to a taxonomy term using taxonomy_select_nodes function. The problem is, it only returns published nodes related to particular taxonomy term. Is there any other solution/function to get all nodes related to a term, regardless of the node state (published/unpublished)?

Thanks in advance.

-- :DJ

-- Randy Fay Drupal Module and Site Development randy@randyfay.com <mailto:randy@randyfay.com> +1 970.462.7450 <tel:%2B1%C2%A0%20970.462.**7450>

-- :DJ

-- __________________ Michael Prasuhn 503.512.0822 office mike@mikeyp.net http://mikeyp.net

-- :DJ

-- :DJ