Forums / Setup & design / Sort on number of downloads?

Sort on number of downloads?

Next topic

Author	Message
Daniel Guerrier	Wednesday 03 August 2005 6:29:12 pm I have a content class with a file attribute. I wanted to sort a fetch of of the objects on the number of times the file was downloaded. The doc says that sort doesn't support the file attribute, but I was hoping that there was a way to sort on the download number. Thx
Daniel Guerrier	Thursday 04 August 2005 6:29:13 am This has to be something that someone wanted to do in the past. What would be the point of keeping track of download if you can't do anything with it. Has anyone figured how to sort on #of downloads of a file that is an attribute of a content object?
Daniel Guerrier	Thursday 04 August 2005 2:10:03 pm anyone?
David Eriksson	Friday 05 August 2005 12:35:05 am The only way I can think of is to sort it yourself, either using your own template operator, or writing it in template language. /David

eZ debug

Timing:

Jan 19 2025 03:27:43

Script start

Timing:

Jan 19 2025 03:27:43

Module start 'content'

Timing:

Jan 19 2025 03:27:44

Module end 'content'

Timing:

Jan 19 2025 03:27:44

Script end

Main resources:

Total runtime

1.0272 sec

Peak memory usage

4,096.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0072	588.9531	180.8359
Module start 'content'	0.0072	1.0080	769.7891	507.2813
Module end 'content'	1.0152	0.0120	1,277.0703	42.1094
Script end	1.0271		1,319.1797

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0072

588.9531

180.8359

Module start 'content'

0.0072

1.0080

769.7891

507.2813

Module end 'content'

1.0152

0.0120

1,277.0703

42.1094

Script end

1.0271

1,319.1797

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.2909	14	0.0002
Check MTime	0.0013	0.1264	14	0.0001
Mysql Total
Database connection	0.0009	0.0920	1	0.0009
Mysqli_queries	0.9785	95.2541	61	0.0160
Looping result	0.0007	0.0726	59	0.0000
Template Total	0.9746	94.9	2	0.4873
Template load	0.0023	0.2214	2	0.0011
Template processing	0.9723	94.6494	2	0.4861
Template load and register function	0.0002	0.0234	1	0.0002
states
state_id_array	0.0018	0.1716	1	0.0018
state_identifier_array	0.0038	0.3669	2	0.0019
Override
Cache load	0.0018	0.1770	12	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0665	2	0.0003
Fetch class attribute name	0.0018	0.1764	4	0.0005
XML
Image XML parsing	0.0002	0.0192	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0010	4	0.0000
General
dbfile	0.0053	0.5118	12	0.0004
String conversion	0.0000	0.0006	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0030

0.2909

0.0002

Check MTime

0.0013

0.1264

0.0001

Mysql Total

Database connection

0.0009

0.0920

0.0009

Mysqli_queries

0.9785

95.2541

0.0160

Looping result

0.0007

0.0726

0.0000

Template Total

0.9746

94.9

0.4873

Template load

0.0023

0.2214

0.0011

Template processing

0.9723

94.6494

0.4861

Template load and register function

0.0002

0.0234

0.0002

states

state_id_array

0.0018

0.1716

0.0018

state_identifier_array

0.0038

0.3669

0.0019

Override

Cache load

0.0018

0.1770

0.0002

Sytem overhead

Fetch class attribute can translate value

0.0007

0.0665

0.0003

Fetch class attribute name

0.0018

0.1764

0.0005

XML

Image XML parsing

0.0002

0.0192

0.0001

class_abstraction

Instantiating content class attribute

0.0000

0.0010

0.0000

General

dbfile

0.0053

0.5118

0.0004

String conversion

0.0000

0.0006

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
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 11 Number of unique templates used: 5

Usage

Requested template

Template

Template loaded

Edit

Override

node/view/full.tpl

full/forum_topic.tpl

extension/sevenx/design/simple/override/templates/full/forum_topic.tpl