Is it possible to make sort by related object name ?

«

Previous topic

|

|

Next topic

»

Author

Message

Martynas Bilevičius

Friday 26 October 2007 1:35:02 am

Is it possible to make sort by related object name ?

Example:

1.Product class fields
1. Name
2. Product Maker (Object Relation)

2.Product Maker Class Names
1. Name
2. Product maker desctiption

I have two product makers name

1. First maker name is "Ardo"
2. Second product maker name is "Siemens"

And i have two products
First product name is ("Bath 1") related to Firs product maker ("Adro")
Second product name is ("Aprod 2") related to second product maker ("Siemens")

And i need sort product by their product maker name.

After sort i should get

1. Bath 1 (Because it's maker name is Ardo, first letter A)
2. Aprod 2 (Because it's maker name is Siemens, first letter S)

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 18 2025 19:04:54
Script start
Timing:	Jan 18 2025 19:04:54
Module start 'layout'
Timing:	Jan 18 2025 19:04:54
Module start 'content'
Timing:	Jan 18 2025 19:04:56
Module end 'content'
Timing:	Jan 18 2025 19:04:56
Script end

Main resources:

Total runtime	1.2373 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0090	590.4453	152.6406
Module start 'layout'	0.0090	0.0042	743.0859	39.4766
Module start 'content'	0.0133	1.2225	782.5625	406.2109
Module end 'content'	1.2357	0.0015	1,188.7734	8.1250
Script end	1.2373		1,196.8984

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0044	0.3576	16	0.0003
Check MTime	0.0017	0.1406	16	0.0001
Mysql Total
Database connection	0.0014	0.1099	1	0.0014
Mysqli_queries	1.1917	96.3108	46	0.0259
Looping result	0.0005	0.0427	44	0.0000
Template Total	1.1949	96.6	2	0.5975
Template load	0.0025	0.2032	2	0.0013
Template processing	1.1924	96.3708	2	0.5962
Template load and register function	0.0002	0.0181	1	0.0002
states
state_id_array	0.0009	0.0746	1	0.0009
state_identifier_array	0.0023	0.1885	2	0.0012
Override
Cache load	0.0020	0.1656	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.0858	1	0.0011
Fetch class attribute name	0.0007	0.0532	1	0.0007
XML
Image XML parsing	0.0002	0.0192	1	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0006	1	0.0000
General
dbfile	0.0007	0.0604	10	0.0001
String conversion	0.0000	0.0010	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	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	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
5	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs