[development] taxonomy_select_nodes - unpublished nodes

[Deva]

Quick update:
Drupal doesn't create table like "field_data_<vocabulary machine name>"
But it creates table with "field_data_<CCK field name given to term
reference>"

:)

On Wed, Sep 7, 2011 at 2:05 AM, Deva <devendra.in at gmail.com> wrote:

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


-- 
:DJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20110908/c65fac7a/attachment.html