[development] taxonomy_select_nodes - unpublished nodes

[Michael Prasuhn]

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 at randyfay.com
> <mailto:randy at 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 at gmail.com
>     <mailto:devendra.in at 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 at randyfay.com <mailto:randy at randyfay.com>
>     +1  970.462.7450 <tel:%2B1%C2%A0%20970.462.7450>
>
>
>
>
> --
> :DJ
>
>

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