How fetch list of element sort by filesize

Next topic

Author	Message
Gianfranco Forlino	Thursday 31 January 2008 9:09:29 am Hi, i have a class <b>software</b> with an element <b>filedownload</b> as FILE. How can fetch the list of elements, filtering content on datatype attribute <b>filesize</b> or <b>download_count</b> ? Best regards
André R.	Thursday 31 January 2008 9:48:24 am You can filter / sort by download count using a extended attribute filter. the data is in the ezbinaryfile table. Filesize on the other hand is not in the table so you'll probably have to create a new datatype that extends ezbinaryfile to be able to sort by / filter by size. Search for 'filter' on this site or ezpedia, or: http://www.google.com/search?hl=en&client=opera&rls=en&hs=gpI&q=Extended+attribute+filter+ez&btnG=Search eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Gianfranco Forlino	Friday 01 February 2008 7:12:59 am Too complicated. You have an example from which to take inspiration? I saw the example images on valid but I was not much help Many thanks

Author

Message

Thursday 31 January 2008 9:09:29 am

Hi,
i have a class software with an element filedownload as FILE. How can fetch the list of elements, filtering content on datatype attribute filesize or download_count ?

Best regards

André R.

Thursday 31 January 2008 9:48:24 am

You can filter / sort by download count using a extended attribute filter. the data is in the ezbinaryfile table. Filesize on the other hand is not in the table so you'll probably have to create a new datatype that extends ezbinaryfile to be able to sort by / filter by size.

Search for 'filter' on this site or ezpedia, or:
http://www.google.com/search?hl=en&client=opera&rls=en&hs=gpI&q=Extended+attribute+filter+ez&btnG=Search

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Gianfranco Forlino

Friday 01 February 2008 7:12:59 am

Too complicated. You have an example from which to take inspiration? I saw the example images on valid but I was not much help

Many thanks

eZ debug

Timing:	Jan 18 2025 19:06:33
Script start
Timing:	Jan 18 2025 19:06:33
Module start 'layout'
Timing:	Jan 18 2025 19:06:33
Module start 'content'
Timing:	Jan 18 2025 19:06:33
Module end 'content'
Timing:	Jan 18 2025 19:06:33
Script end

Main resources:

Total runtime	0.0402 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.0122	589.1641	152.6406
Module start 'layout'	0.0122	0.0045	741.8047	39.4766
Module start 'content'	0.0167	0.0200	781.2813	89.3672
Module end 'content'	0.0368	0.0034	870.6484	34.3047
Script end	0.0402		904.9531

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	9.2261	14	0.0003
Check MTime	0.0013	3.1797	14	0.0001
Mysql Total
Database connection	0.0029	7.2211	1	0.0029
Mysqli_queries	0.0060	14.8185	3	0.0020
Looping result	0.0000	0.0723	1	0.0000
Template Total	0.0030	7.3	1	0.0030
Template load	0.0017	4.2210	1	0.0017
Template processing	0.0012	3.0949	1	0.0012
Override
Cache load	0.0013	3.3486	1	0.0013
General
dbfile	0.0038	9.3606	8	0.0005
String conversion	0.0000	0.0356	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