|
Wednesday 24 March 2010 5:10:49 pm
Hi Jorge The DB table that holds nodes is ezcontentobject_tree but you'll have to join this with ezcontentobject to access the class. Have a look at http://ez.no/doc/ez_publish/technical_manual/3_10/concepts_and_basics/content_management/the_content_node for some of the underlying info. I'm not sure exactly what you are trying to achieve but typically in eZ Publish you utilise the API to retrieve data and don't do direct queries on the DB. The easiest way to retrieve the data you are after is a template fetch query from PHP:
$nodes = eZFunctionHandler::execute( 'content', 'tree',
array( 'parent_node_id' => $top_node_id,
'class_filter_type' => 'include',
'class_filter_array' => array( 'article' ) ) );As the filtering is done in the fetch there is no need to loop through the returned nodes and check class type. This is quite flexible as you can utilise the same parameters as used in templates.
Cheers
Bruce
My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish
|