how to fetch the object relation(attributes)..?

Author Message

Satheesh R

Saturday 09 December 2006 5:08:22 am

hello all,

how to fetch object relations attribute,
for example
i have a 2 class called Teacher & Subect

Subject contains
-------------------
Name : aaa
Standard : 5th
and Teacher_name (This is "object relation" to Teacher) : bbb

Teacher contains
---------------------
Name : bbb
Qualification : MCA
Experience : 5yrs
..... etc

i want to get all the infos of teacher "bbb" (infos like MCA , 5 Yrs...etc) when i select the info of student "aaa"

please any one guide me to achieve the above

--
Satheesh R

Thanks and Regards
R Satheesh

Jacobo Quiles

Monday 11 December 2006 12:40:46 am

Hi, you could try something like this:

Assuming we are watching the full view of a subject:

{* Fetch all the related objects from the node that is being viewed *}

{def $teachers=fetch('content','related_objects',hash('object_id', $node.object.id, 'all_relations', true()))}

{* Foreach related teacher, show the attributes *}

{foreach $teachers as $teacher}
    {attribute_view_gui attribute=$teacher.main_node.data_map.name}<br/>
    {attribute_view_gui attribute=$teacher.main_node.data_map.qualification}<br/>
    {attribute_view_gui attribute=$teacher.main_node.data_map.experience}<br/><br/>
{/foreach}

Hope it helps.
Cheers.

Microblau SL
http://www.microblau.net

Xavier Dutoit

Monday 11 December 2006 8:10:41 am

Hi,

No need of the extra loop through the main node of the object,

{attribute_view_gui attribute=$teacher.data_map.name}<br/>

http://www.sydesy.com

Satheesh R

Tuesday 12 December 2006 2:13:47 am

Hi Jacobo Quiles, Xavier Dutoit

It works well, Thanks for the solutions

Thanks and regards
Satheesh R

Thanks and Regards
R Satheesh

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 30 2025 21:42:04
Script start
Timing: Jan 30 2025 21:42:04
Module start 'layout'
Timing: Jan 30 2025 21:42:04
Module start 'content'
Timing: Jan 30 2025 21:42:05
Module end 'content'
Timing: Jan 30 2025 21:42:05
Script end

Main resources:

Total runtime1.1142 sec
Peak memory usage8,192.0000 KB
Database Queries62

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0043 588.2656151.2266
Module start 'layout' 0.00430.0035 739.4922220.7188
Module start 'content' 0.00781.1057 960.21094,501.7734
Module end 'content' 1.11350.0007 5,461.984411.8125
Script end 1.1142  5,473.7969 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.2846160.0002
Check MTime0.00120.1068160.0001
Mysql Total
Database connection0.00070.058610.0007
Mysqli_queries1.031792.5875620.0166
Looping result0.00060.0546600.0000
Template Total1.070296.020.5351
Template load0.00200.183720.0010
Template processing1.068195.861120.5341
Template load and register function0.00140.129410.0014
states
state_id_array0.00170.154210.0017
state_identifier_array0.00110.102620.0006
Override
Cache load0.00170.1553390.0000
Sytem overhead
Fetch class attribute can translate value0.00170.152630.0006
Fetch class attribute name0.00220.198760.0004
XML
Image XML parsing0.00220.194830.0007
class_abstraction
Instantiating content class attribute0.00000.001560.0000
General
dbfile0.00210.1878230.0001
String conversion0.00000.000840.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
10content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 26
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs