order by attribute

Previous topic

Setup & design

Next topic

Author	Message
Stefan van Zwoll	Monday 17 November 2003 7:57:24 pm dear devs, after about 3 months of trying, i finally got ezp 3.2-3 up and running! yippieh! now i'm trying to understand what i'm doing, making quite a good progress. but one thing comes to my mind that i cannot figure out. maybe it is too latte in the morning, but anyhow: i'm planning on setting up a textarchive. there will be several types of texts (literary work, essays, reviews...) as well as a difference between published (print) and unpublished (online) work. every text has an author (of course) and this particular author will get his/her own info-page with a short curriculum vitae, a pic and so on. now my question: i want the user being able of ordering the archive appropriate to his/her needs. that means: s/he must be able to get any author that name is starting with a "c" plus the text must be a review. is something like that hard to code or is there an "easy" workaround? if not the user, am i able to display names with alphabetical values (display names starting with "c")? thank you very much for any thought. stefan

Author

Message

Stefan van Zwoll

Monday 17 November 2003 7:57:24 pm

dear devs,

after about 3 months of trying, i finally got ezp 3.2-3 up and running! yippieh!

now i'm trying to understand what i'm doing, making quite a good progress. but one thing comes to my mind that i cannot figure out. maybe it is too latte in the morning, but anyhow:

i'm planning on setting up a textarchive. there will be several types of texts (literary work, essays, reviews...) as well as a difference between published (print) and unpublished (online) work. every text has an author (of course) and this particular author will get his/her own info-page with a short curriculum vitae, a pic and so on. now my question: i want the user being able of ordering the archive appropriate to his/her needs. that means: s/he must be able to get any author that name is starting with a "c" plus the text must be a review. is something like that hard to code or is there an "easy" workaround? if not the user, am i able to display names with alphabetical values (display names starting with "c")?

thank you very much for any thought.
stefan

eZ debug

Timing:	Jan 19 2025 01:16:47
Script start
Timing:	Jan 19 2025 01:16:47
Module start 'layout'
Timing:	Jan 19 2025 01:16:47
Module start 'content'
Timing:	Jan 19 2025 01:16:48
Module end 'content'
Timing:	Jan 19 2025 01:16:48
Script end

Main resources:

Total runtime	0.7958 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.0057	589.1328	152.6094
Module start 'layout'	0.0058	0.0026	741.7422	39.4141
Module start 'content'	0.0084	0.7858	781.1563	401.1094
Module end 'content'	0.7941	0.0016	1,182.2656	8.1875
Script end	0.7958		1,190.4531

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	0.3578	16	0.0002
Check MTime	0.0012	0.1469	16	0.0001
Mysql Total
Database connection	0.0007	0.0910	1	0.0007
Mysqli_queries	0.7604	95.5555	46	0.0165
Looping result	0.0004	0.0467	44	0.0000
Template Total	0.7653	96.2	2	0.3827
Template load	0.0018	0.2244	2	0.0009
Template processing	0.7635	95.9451	2	0.3818
Template load and register function	0.0002	0.0190	1	0.0002
states
state_id_array	0.0009	0.1087	1	0.0009
state_identifier_array	0.0013	0.1639	2	0.0007
Override
Cache load	0.0014	0.1755	9	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0588	1	0.0005
Fetch class attribute name	0.0006	0.0797	1	0.0006
XML
Image XML parsing	0.0001	0.0069	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0005	1	0.0000
General
dbfile	0.0006	0.0748	10	0.0001
String conversion	0.0000	0.0007	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
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	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: 6 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs