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 <[email protected]
<mailto:[email protected]>> 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 <[email protected]
    <mailto:[email protected]>> 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
    [email protected] <mailto:[email protected]>
    +1  970.462.7450 <tel:%2B1%C2%A0%20970.462.7450>




--
:DJ



--
__________________
Michael Prasuhn
503.512.0822 office
[email protected]
http://mikeyp.net

Reply via email to