Sorting objects based on attribute (not in fetch though)

Next topic

Author	Message
Kedar Deshpande	Saturday 23 January 2010 10:41:19 am Hi, this question has been asked in the past but is usually solved by a sort_by in the fetch command. Another well known problem is the fact that you cant do an attribute sort when using the reverse_related_objects function other than the publish_date, modified_date etc. In this post: http://share.ez.no/forums/setup-design/fetch-reverse-related-objects-and-sort_by-attribute someone mentions creating a custom template function like: $sorted = {$unsorted\|sort('your_attribute',true())} Has anyone created such a function that they could share? Any function that sorts a collection of objects would help. thanks.
Carlos Revillo	Saturday 23 January 2010 12:09:14 pm you can try with an extended attribute filter then. use your sql debug output to see how normal reverse_related_objects works and do something similar with your extended attribute filter. for extended_attribute_filter you can have a look at ezstarrating extension. about template function, i wouldn't go like that. i mean, it seems you're doing the database query and then ordering the results, but with an extended_attribute_filter you can just the results sortered. better for perfomance i think.
Kedar Deshpande	Saturday 23 January 2010 2:09:16 pm Thanks Carlos, I'll check out the extended attribute filter and see if I can make it do sorting on this specific attribute I have. I also appreciate the feedback on the template function idea, it does make more sense to do the sort on the fetch.
Carlos Revillo	Sunday 24 January 2010 2:07:24 am Sure. suppose you have a 10.000 objects, but you only need to show 10 of them ordered by one of the attrs. usign that template custom operator, you will have to get all of 10.000 and then php will sort them. then you will have to use some kinda array_slice operator to get only 10. you can certainly do all those steps in just one query.
Alex Kozeka	Tuesday 05 July 2011 3:08:42 am Hi Carlos, Maybe you find this extension useful: http://projects.ez.no/sortobjectsoperators -- Argentea S.p.A., http://www.argentea.it/

eZ debug

Timing:	Jan 18 2025 02:52:47
Script start
Timing:	Jan 18 2025 02:52:47
Module start 'layout'
Timing:	Jan 18 2025 02:52:47
Module start 'content'
Timing:	Jan 18 2025 02:52:48
Module end 'content'
Timing:	Jan 18 2025 02:52:48
Script end

Main resources:

Total runtime	1.2200 sec
Peak memory usage	4,096.0000 KB
Database Queries	66

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0037	588.1563	152.6563
Module start 'layout'	0.0037	0.0023	740.8125	39.4922
Module start 'content'	0.0061	1.2125	780.3047	587.0156
Module end 'content'	1.2186	0.0014	1,367.3203	12.1094
Script end	1.2199		1,379.4297

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0029	0.2382	16	0.0002
Check MTime	0.0012	0.1008	16	0.0001
Mysql Total
Database connection	0.0004	0.0323	1	0.0004
Mysqli_queries	1.1733	96.1761	66	0.0178
Looping result	0.0006	0.0486	64	0.0000
Template Total	1.1970	98.1	2	0.5985
Template load	0.0018	0.1486	2	0.0009
Template processing	1.1952	97.9693	2	0.5976
Template load and register function	0.0001	0.0116	1	0.0001
states
state_id_array	0.0007	0.0537	1	0.0007
state_identifier_array	0.0008	0.0685	2	0.0004
Override
Cache load	0.0015	0.1260	25	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0602	3	0.0002
Fetch class attribute name	0.0012	0.1005	6	0.0002
XML
Image XML parsing	0.0008	0.0677	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0008	6	0.0000
General
dbfile	0.0009	0.0735	16	0.0001
String conversion	0.0000	0.0005	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 15 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs