Fetching and sorting limitations

Next topic

Author	Message
Piotrek Karaś	Thursday 13 December 2007 5:43:05 am The documentation says here: http://ez.no/doc/ez_publish/technical_manual/3_10/reference/modules/content/fetch_functions/list that it is only supported to sort by the following datatypes:<b> Checkbox Date Date and time E-mail Integer Selection (will not work when used as multiple selector) Text line Time</b> Just checked it for a custom data type that extends a system one which happens to be supported (text line). It sorts fine. My conclusion is: all data types that manage <b>sort_key_int</b> and/or <b>sort_key_string</b> fields in <b>ezcontentobject_attribute</b> table should generally support sorting without problem. Is that correct? -- Company: mediaSELF Sp. z o.o., http://www.mediaself.pl eZ references: http://ez.no/partners/worldwide_partners/mediaself eZ certified developer: http://ez.no/certification/verify/272585 eZ blog: http://ez.ryba.eu

Author

Message

Thursday 13 December 2007 5:43:05 am

The documentation says here:
http://ez.no/doc/ez_publish/technical_manual/3_10/reference/modules/content/fetch_functions/list

that it is only supported to sort by the following datatypes:
Checkbox
Date
Date and time
E-mail
Integer
Selection (will not work when used as multiple selector)
Text line
Time

Just checked it for a custom data type that extends a system one which happens to be supported (text line). It sorts fine.

My conclusion is: all data types that manage sort_key_int and/or sort_key_string fields in ezcontentobject_attribute table should generally support sorting without problem. Is that correct?

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

eZ debug

Timing:	Jan 18 2025 19:34:02
Script start
Timing:	Jan 18 2025 19:34:02
Module start 'layout'
Timing:	Jan 18 2025 19:34:02
Module start 'content'
Timing:	Jan 18 2025 19:34:02
Module end 'content'
Timing:	Jan 18 2025 19:34:02
Script end

Main resources:

Total runtime	0.0160 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.0063	587.9219	152.6250
Module start 'layout'	0.0063	0.0031	740.5469	39.4453
Module start 'content'	0.0094	0.0042	779.9922	89.3359
Module end 'content'	0.0137	0.0022	869.3281	30.3047
Script end	0.0159		899.6328

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	18.6658	14	0.0002
Check MTime	0.0013	8.2881	14	0.0001
Mysql Total
Database connection	0.0007	4.5962	1	0.0007
Mysqli_queries	0.0030	19.0395	3	0.0010
Looping result	0.0000	0.0867	1	0.0000
Template Total	0.0018	11.4	1	0.0018
Template load	0.0010	6.0745	1	0.0010
Template processing	0.0008	5.2658	1	0.0008
Override
Cache load	0.0007	4.4378	1	0.0007
General
dbfile	0.0002	1.3168	8	0.0000
String conversion	0.0000	0.0583	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