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