Fetch the content of a Matrix and display them

Previous topic

Setup & design

Next topic

Author	Message
Softriva .com	Thursday 30 November 2006 8:25:52 am My class has the following attributes: Class: Dept Dept_Name Dept_Emp (Matrix of one col) Dept Name: FIN Dept_Emp->Matrix= (Joe, Mike, Jack) Dept_Name: HR Dept_Emp->Matrix=(John, Jeff, Suzan) How can I fetch only the employees names then display them regardless if there are duplicate names or not.
Claudia Kosny	Saturday 02 December 2006 3:32:50 am Hi OOzy The content of an ezmatrix attribute is an object of type ezmatrix. Here you can see what attributes this object has: http://ez.no/doc/ez_publish/technical_manual/3_8/reference/objects/ezmatrix So if you matrix has only one column I think it should be sufficient to use ...data_map.dept_emp.content.cells. This should give you an array of all entries in the matrix. Then just loop over this array using foreach and you are done. Claudia

Author

Message

Softriva .com

Thursday 30 November 2006 8:25:52 am

My class has the following attributes:

Class: Dept

Dept_Name
Dept_Emp (Matrix of one col)

Dept Name: FIN
Dept_Emp->Matrix= (Joe, Mike, Jack)

Dept_Name: HR
Dept_Emp->Matrix=(John, Jeff, Suzan)

How can I fetch only the employees names then display them regardless if there are duplicate names or not.

Claudia Kosny

Saturday 02 December 2006 3:32:50 am

Hi OOzy

The content of an ezmatrix attribute is an object of type ezmatrix. Here you can see what attributes this object has: http://ez.no/doc/ez_publish/technical_manual/3_8/reference/objects/ezmatrix

So if you matrix has only one column I think it should be sufficient to use
...data_map.dept_emp.content.cells. This should give you an array of all entries in the matrix. Then just loop over this array using foreach and you are done.

Claudia

eZ debug

Timing:	Jan 19 2025 00:30:28
Script start
Timing:	Jan 19 2025 00:30:28
Module start 'layout'
Timing:	Jan 19 2025 00:30:28
Module start 'content'
Timing:	Jan 19 2025 00:30:29
Module end 'content'
Timing:	Jan 19 2025 00:30:29
Script end

Main resources:

Total runtime	0.9608 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0062	588.0469	152.6406
Module start 'layout'	0.0062	0.0043	740.6875	39.4922
Module start 'content'	0.0105	0.9483	780.1797	461.2500
Module end 'content'	0.9588	0.0020	1,241.4297	8.1250
Script end	0.9607		1,249.5547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.3756	16	0.0002
Check MTime	0.0016	0.1650	16	0.0001
Mysql Total
Database connection	0.0010	0.1047	1	0.0010
Mysqli_queries	0.9120	94.9218	54	0.0169
Looping result	0.0006	0.0652	52	0.0000
Template Total	0.9177	95.5	2	0.4588
Template load	0.0022	0.2323	2	0.0011
Template processing	0.9154	95.2791	2	0.4577
Template load and register function	0.0003	0.0290	1	0.0003
states
state_id_array	0.0017	0.1778	1	0.0017
state_identifier_array	0.0028	0.2885	2	0.0014
Override
Cache load	0.0018	0.1898	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0681	2	0.0003
Fetch class attribute name	0.0022	0.2313	2	0.0011
XML
Image XML parsing	0.0002	0.0258	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0007	2	0.0000
General
dbfile	0.0007	0.0768	10	0.0001
String conversion	0.0000	0.0011	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
2	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
4	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.0001 secs