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

-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