Sorting by Object relation : custom operator

Next topic

Author	Message
patrice brun	Friday 30 April 2010 8:27:12 am Hello I want to sort objects on an attribute 'object relationship'. So I created a 'custom operator(orderByObjectRelation)'. At the end of my php code I do a 'return $ tabOrderok'. I call it this way in my template: (Def $newcat = orderByObjectRelation ($ cats)) ($newcat \| attribute ('show')) I get the following error message: Error: eZTemplate: foreach Apr 30 2010 5:05:48 p.m. Missing / malformed array to iterate through. In my php code I do a var_dump my object and all seems ok. Why do you think my table is not returned on well? Thank you
Jérôme Vieilledent	Saturday 01 May 2010 2:39:32 am Hi Patrice I'm not sure I understand your problem... Would you mind show your code please ? By the way, this might not be the right way to do such a sort for a fetch. You should take a look in extended attribute filters. Indeed, with them you can add new columns to the SQL statement produced by the fetch and then use them in sort_by ;). http://ez.no/doc/ez_publish/technical_manual/4_x/reference/modules/content/fetch_functions/list
Abdelkader RHOUATI	Monday 03 May 2010 2:09:53 am Hi Patrice, You gave the wrong answer to your needs, and I invite you to see the solution proposed by Jérôme. No matter for your problem, in your operator template, try to use : return array( 'result' => $tabOrderok ); Regrads. Abdelkader RHOUATI Blog (french) : http://arhouati.com ---- Extension arh_jdebug : EzDebug using jquery

Author

Message

Friday 30 April 2010 8:27:12 am

Hello
I want to sort objects on an attribute 'object relationship'. So I created a 'custom operator(orderByObjectRelation)'. At the end of my php code I do a 'return $ tabOrderok'. I call it this way in my template:
(Def $newcat = orderByObjectRelation ($ cats))
($newcat | attribute ('show'))
I get the following error message:
Error: eZTemplate: foreach Apr 30 2010 5:05:48 p.m.
Missing / malformed array to iterate through.
In my php code I do a var_dump my object and all seems ok.
Why do you think my table is not returned on well?
Thank you

Jérôme Vieilledent

Saturday 01 May 2010 2:39:32 am

Hi Patrice

I'm not sure I understand your problem... Would you mind show your code please ?

By the way, this might not be the right way to do such a sort for a fetch. You should take a look in extended attribute filters. Indeed, with them you can add new columns to the SQL statement produced by the fetch and then use them in sort_by ;).

http://ez.no/doc/ez_publish/technical_manual/4_x/reference/modules/content/fetch_functions/list

Abdelkader RHOUATI

Monday 03 May 2010 2:09:53 am

Hi Patrice,

You gave the wrong answer to your needs, and I invite you to see the solution proposed by Jérôme.

No matter for your problem, in your operator template, try to use :


return array( 'result' => $tabOrderok );

Regrads.

Abdelkader RHOUATI

Blog (french) : http://arhouati.com
----
Extension arh_jdebug : EzDebug using jquery

eZ debug

Timing:	Jan 18 2025 05:15:16
Script start
Timing:	Jan 18 2025 05:15:16
Module start 'layout'
Timing:	Jan 18 2025 05:15:16
Module start 'content'
Timing:	Jan 18 2025 05:15:17
Module end 'content'
Timing:	Jan 18 2025 05:15:17
Script end

Main resources:

Total runtime	0.6402 sec
Peak memory usage	4,096.0000 KB
Database Queries	59

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	588.0469	152.6406
Module start 'layout'	0.0066	0.0035	740.6875	39.4766
Module start 'content'	0.0100	0.6287	780.1641	579.4766
Module end 'content'	0.6388	0.0014	1,359.6406	12.1250
Script end	0.6401		1,371.7656

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.4750	16	0.0002
Check MTime	0.0013	0.2052	16	0.0001
Mysql Total
Database connection	0.0013	0.2018	1	0.0013
Mysqli_queries	0.5858	91.5109	59	0.0099
Looping result	0.0006	0.0963	57	0.0000
Template Total	0.6096	95.2	2	0.3048
Template load	0.0020	0.3112	2	0.0010
Template processing	0.6076	94.9144	2	0.3038
Template load and register function	0.0002	0.0369	1	0.0002
states
state_id_array	0.0008	0.1195	1	0.0008
state_identifier_array	0.0008	0.1256	2	0.0004
Override
Cache load	0.0017	0.2590	28	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1128	3	0.0002
Fetch class attribute name	0.0017	0.2592	5	0.0003
XML
Image XML parsing	0.0015	0.2339	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0017	5	0.0000
General
dbfile	0.0011	0.1784	23	0.0000
String conversion	0.0000	0.0014	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	content/datatype/view/ezxmltags/strong.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/strong.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.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: 8

Time used to render debug report: 0.0002 secs