fetching objects from php based on attributes

Next topic

Author	Message
Patrice Fortin	Tuesday 08 May 2007 6:32:34 pm I people, I want to create a function that can be called from a template which fetches events for a single month in some/all calendars in a site. The function will return a array of arrays having each day as an element to be able to display it like webcalendar (displaying event names in each table cell with links or popup on mouseover). Anyway, here is where I'm having trouble: I don't know how to fetch objects depending on attributes. I can easily do it from a template, but I can't figure out how to do it from a php function. Here is a simplified fetch that would be enough for testing. Logically, this should return nothing, but it returns the same thing, no matter if the "array( 'or', array('event/from_time', '<', 0) )" condition is there: $events = eZPersistentObject::fetchObjectList( eZContentObject::definition(), null, array( 'contentclass_id' => 30, array( 'or', array('event/from_time', '<', 0) ) ), false, false, true ); What is incorrect in my condition parameter ?
Kristof Coomans	Tuesday 08 May 2007 11:26:20 pm Hi Patrice I think you are using the wrong function for what you are trying to do. Use eZContentObjectTreeNode::subTree or instead. Łukasz wrote a nice blog article in which you can find a few examples: http://serwatka.net/en/blog/fetching_ez_publish_content_objects_with_php. The conditions parameter to eZPersistentObject::fetchObjectList is documented well with Doxygen (the API docs are at http://pubsvn.ez.no/doxygen/3.9/html/index.html ). independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org

Author

Message

Tuesday 08 May 2007 6:32:34 pm

I people,
I want to create a function that can be called from a template which fetches events for a single month in some/all calendars in a site. The function will return a array of arrays having each day as an element to be able to display it like webcalendar (displaying event names in each table cell with links or popup on mouseover).

Anyway, here is where I'm having trouble: I don't know how to fetch objects depending on attributes. I can easily do it from a template, but I can't figure out how to do it from a php function.

Here is a simplified fetch that would be enough for testing. Logically, this should return nothing, but it returns the same thing, no matter if the "array( 'or', array('event/from_time', '<', 0) )" condition is there:

        $events =  eZPersistentObject::fetchObjectList( eZContentObject::definition(),
                                                                   null, 
                                                                   array( 'contentclass_id' => 30,
                                                                          array( 'or', array('event/from_time', '<', 0) ) ),
                                                                   false,
                                                                   false,
                                                                   true );

What is incorrect in my condition parameter ?

Kristof Coomans

Tuesday 08 May 2007 11:26:20 pm

Hi Patrice

I think you are using the wrong function for what you are trying to do. Use eZContentObjectTreeNode::subTree or instead. Łukasz wrote a nice blog article in which you can find a few examples: http://serwatka.net/en/blog/fetching_ez_publish_content_objects_with_php.

The conditions parameter to eZPersistentObject::fetchObjectList is documented well with Doxygen (the API docs are at http://pubsvn.ez.no/doxygen/3.9/html/index.html ).

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

eZ debug

Timing:	Jan 18 2025 14:58:58
Script start
Timing:	Jan 18 2025 14:58:58
Module start 'layout'
Timing:	Jan 18 2025 14:58:58
Module start 'content'
Timing:	Jan 18 2025 14:58:58
Module end 'content'
Timing:	Jan 18 2025 14:58:58
Script end

Main resources:

Total runtime	0.0164 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	588.0469	152.6406
Module start 'layout'	0.0058	0.0029	740.6875	39.4766
Module start 'content'	0.0087	0.0059	780.1641	89.4922
Module end 'content'	0.0146	0.0018	869.6563	30.3047
Script end	0.0164		899.9609

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	15.3418	14	0.0002
Check MTime	0.0010	6.2687	14	0.0001
Mysql Total
Database connection	0.0010	6.0361	1	0.0010
Mysqli_queries	0.0021	12.7453	3	0.0007
Looping result	0.0000	0.0858	1	0.0000
Template Total	0.0015	9.3	1	0.0015
Template load	0.0008	4.7873	1	0.0008
Template processing	0.0007	4.4442	1	0.0007
Override
Cache load	0.0006	3.5487	1	0.0006
General
dbfile	0.0013	8.2197	8	0.0002
String conversion	0.0000	0.0596	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs