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 <[email protected]> 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 <[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 > -- :DJ
