[development] taxonomy_select_nodes - unpublished nodes

[Deva]

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 at 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 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
>



-- 
:DJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20110907/0ee0ae7a/attachment-0001.html