Need help to fetch many classes and sort them

«

Previous topic

|

|

Next topic

»

Author	Message
Sébastien Antoniotti	Tuesday 13 March 2007 7:57:08 am Hi, In my eZ publish site I have 3 classes (artist, album and song) and wich of them have an attribute named "name". So I would like to fetch all objects (nodes) of these 3 classes and order them on their "name" attribute first, and not on the class ID. Example : Considering that under the node 59 we have this : - Toto (instance of class artist) - Tata (instance of classe song) - Tutu (instance of classe album) I would like to make a fetch that give me this order : 1) Tata 2) Toto 3) Tutu Thanks in advance ! eZ Publish Freelance web : http://www.webaxis.fr
Sébastien Antoniotti	Friday 16 March 2007 9:10:12 am Help please ! eZ Publish Freelance web : http://www.webaxis.fr
Sébastien Antoniotti	Monday 26 March 2007 8:23:49 am please help ! eZ Publish Freelance web : http://www.webaxis.fr
Felix Woldt	Monday 26 March 2007 11:01:10 am Hi Sebastian, have a look here http://ez.no/doc/ez_publish/technical_manual/3_8/reference/modules/content/fetch_functions/list you can sort your fetch after 'name' {fetch( 'content', 'list', hash( 'parent_node_id', 42, 'sort_by', array( array( 'name', false() ), array( 'published', false() ) , 'class_filter_type', 'include', 'class_filter_array', array( 'class_identifier_1', 'class_identifier_2' , 'class_identifier_3' ) ) ) } This code should be work. Felix http://www.jac-systeme.de - Developers united in eZ Publish: http://www.cjw-network.com CJW Newsletter 1.0.0 released: http://projects.ez.no/cjw_newsletter
Sébastien Antoniotti	Tuesday 27 March 2007 12:40:07 am Hi Felix, Thanks a lot, all is ok now ! I'm sorry that it was in th documentation =( good dev ! eZ Publish Freelance web : http://www.webaxis.fr

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 00:16:32
Script start
Timing:	Jan 31 2025 00:16:32
Module start 'layout'
Timing:	Jan 31 2025 00:16:32
Module start 'content'
Timing:	Jan 31 2025 00:16:32
Module end 'content'
Timing:	Jan 31 2025 00:16:32
Script end

Main resources:

Total runtime	0.0214 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0046	588.2656	151.2266
Module start 'layout'	0.0046	0.0040	739.4922	220.7188
Module start 'content'	0.0086	0.0113	960.2109	1,001.9609
Module end 'content'	0.0199	0.0015	1,962.1719	37.9922
Script end	0.0214		2,000.1641

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	12.0179	14	0.0002
Check MTime	0.0012	5.4356	14	0.0001
Mysql Total
Database connection	0.0008	3.8327	1	0.0008
Mysqli_queries	0.0025	11.4757	3	0.0008
Looping result	0.0000	0.0512	1	0.0000
Template Total	0.0011	5.3	1	0.0011
Template load	0.0009	4.2434	1	0.0009
Template processing	0.0002	0.9852	1	0.0002
Override
Cache load	0.0007	3.0946	1	0.0007
General
dbfile	0.0002	1.0130	8	0.0000
String conversion	0.0000	0.0512	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