Fetching Content Objects on Custom Attributes

Next topic

Author	Message
Paul Ramirez	Friday 26 September 2003 8:56:21 am Can someone explain to me how to use fetch in conjunction with attributes that are specific to a custom content object I have created? For instance, I have created a Story class which is much like an Article but has a field to capture the owner and the creation date. I want to fecth the 4 most recently created articles by a particular owner that have been published. I see that I have access to the main content attributes in the database through the fetch command but I need to filter on these other attributes that are part of my custom content class. Can I even do this with ezp? I am currently using ezp 3.0 but I would not be opposed to upgrading to 3.2 if it provides this sort of functionality. Thanks, in advance for any help or links anyone can provide. Thanks, Paul Ramirez
Eirik Alfstad Johansen	Monday 29 September 2003 3:39:41 am Hi Paul, The following documentation page describes how you can filter results based on attribute values: http://www.ez.no/developer/ez_publish_3/documentation/development/libraries/ez_template/operators/data_fetch Look near the end of the page. Good luck ! Sincerely, Eirik Johansen http://www.netmaking.no/ Sincerely, Eirik Alfstad Johansen http://www.netmaking.no/

Author

Message

Friday 26 September 2003 8:56:21 am

Can someone explain to me how to use fetch in conjunction with attributes that are specific to a custom content object I have created? For instance, I have created a Story class which is much like an Article but has a field to capture the owner and the creation date. I want to fecth the 4 most recently created articles by a particular owner that have been published. I see that I have access to the main content attributes in the database through the fetch command but I need to filter on these other attributes that are part of my custom content class. Can I even do this with ezp? I am currently using ezp 3.0 but I would not be opposed to upgrading to 3.2 if it provides this sort of functionality. Thanks, in advance for any help or links anyone can provide.

Thanks,
Paul Ramirez

Eirik Alfstad Johansen

Monday 29 September 2003 3:39:41 am

Hi Paul,

The following documentation page describes how you can filter results based on attribute values:

http://www.ez.no/developer/ez_publish_3/documentation/development/libraries/ez_template/operators/data_fetch

Look near the end of the page. Good luck !

Sincerely,

Eirik Johansen
http://www.netmaking.no/

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

eZ debug

Timing:	Jan 18 2025 22:26:09
Script start
Timing:	Jan 18 2025 22:26:09
Module start 'layout'
Timing:	Jan 18 2025 22:26:09
Module start 'content'
Timing:	Jan 18 2025 22:26:09
Module end 'content'
Timing:	Jan 18 2025 22:26:09
Script end

Main resources:

Total runtime	0.0165 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	589.1797	152.6406
Module start 'layout'	0.0056	0.0034	741.8203	39.4766
Module start 'content'	0.0090	0.0053	781.2969	89.3672
Module end 'content'	0.0143	0.0022	870.6641	30.3047
Script end	0.0165		900.9688

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	17.8781	14	0.0002
Check MTime	0.0014	8.3630	14	0.0001
Mysql Total
Database connection	0.0007	4.5175	1	0.0007
Mysqli_queries	0.0029	17.4773	3	0.0010
Looping result	0.0000	0.1211	1	0.0000
Template Total	0.0017	10.4	1	0.0017
Template load	0.0010	5.9637	1	0.0010
Template processing	0.0007	4.3603	1	0.0007
Override
Cache load	0.0007	4.2031	1	0.0007
General
dbfile	0.0003	1.6827	8	0.0000
String conversion	0.0000	0.0606	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	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs