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> 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> 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
+1  970.462.7450




--
:DJ