Fecth content complicated, how to?

Previous topic

Setup & design

Next topic

Author	Message
Daniele Nocentini	Wednesday 20 April 2005 1:37:37 am I'have this node structure: .race (folder class) .january (folder class) .february .march .race1 (my custom class) .race2 (my custom class) .etc etc... In my race custom class I've a attribute date for the race, I want to fetch all race by the current month and sort by this date attribute. This is It's very hard for me, anyone can help me?! Antica Bottega Digitale srl http://www.abd.it
Łukasz Serwatka	Wednesday 20 April 2005 7:06:45 am Hi Daniele, Replace: CLASS_ID with your custom class ATTR_ID with id of your date datatype attribute DATE, you can us http://ez.no/ez_publish/documentation/reference/template_operators/formatting/datetime http://ez.no/ez_publish/documentation/customization/tips_tricks/date_and_time_formats fetch( content, tree, hash( parent_node_id, RACE_NODE_ID, class_filter_type, include, class_filter_array, array( CLASS_ID ), sort_by, array( 'attribute', false(), 'ATTR_ID' ), attribute_filter, array( array( 'ATTR_ID', '=', 'DATE' ) ) ) ) I hope it will help. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Daniele Nocentini

Wednesday 20 April 2005 1:37:37 am

I'have this node structure:

.race (folder class)
   .january (folder class)
   .february
   .march
      .race1 (my custom class)
      .race2 (my custom class)
      .etc
etc...

In my race custom class I've a attribute date for the race, I want to fetch all race by the current month and sort by this date attribute.
This is It's very hard for me, anyone can help me?!

Antica Bottega Digitale srl
http://www.abd.it

Łukasz Serwatka

Wednesday 20 April 2005 7:06:45 am

Hi Daniele,

Replace:
CLASS_ID with your custom class
ATTR_ID with id of your date datatype attribute
DATE, you can us
http://ez.no/ez_publish/documentation/reference/template_operators/formatting/datetime
http://ez.no/ez_publish/documentation/customization/tips_tricks/date_and_time_formats

fetch( content, tree, hash( parent_node_id, RACE_NODE_ID,
                            class_filter_type,  include,
                            class_filter_array, array( CLASS_ID ),
                            sort_by, array( 'attribute', false(), 'ATTR_ID' ),
                            attribute_filter, array( array( 'ATTR_ID', '=', 'DATE' ) ) ) )

I hope it will help.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Timing:	Jan 19 2025 04:39:12
Script start
Timing:	Jan 19 2025 04:39:12
Module start 'layout'
Timing:	Jan 19 2025 04:39:12
Module start 'content'
Timing:	Jan 19 2025 04:39:12
Module end 'content'
Timing:	Jan 19 2025 04:39:12
Script end

Main resources:

Total runtime	0.0145 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	589.1797	152.6250
Module start 'layout'	0.0058	0.0028	741.8047	39.4453
Module start 'content'	0.0086	0.0041	781.2500	89.4609
Module end 'content'	0.0127	0.0017	870.7109	30.3047
Script end	0.0144		901.0156

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	16.4681	14	0.0002
Check MTime	0.0010	7.1037	14	0.0001
Mysql Total
Database connection	0.0008	5.4888	1	0.0008
Mysqli_queries	0.0029	19.9878	3	0.0010
Looping result	0.0000	0.0972	1	0.0000
Template Total	0.0014	9.6	1	0.0014
Template load	0.0007	4.8511	1	0.0007
Template processing	0.0007	4.7407	1	0.0007
Override
Cache load	0.0005	3.5329	1	0.0005
General
dbfile	0.0003	2.2146	8	0.0000
String conversion	0.0000	0.0725	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