Sort by Expression

«

Previous topic

|

|

Next topic

»

Author	Message
m.zaki ahmed	Monday 14 May 2007 6:15:04 am hi i want to fetch the 4 nearest events to current date even its event_date was in past or in future my idea is to fetch from event class limit by 4 and sort by the different between its event_date and current date some thing like that { fetch( 'content', 'list', hash( 'parent_node_id', 42, 'limit', 4, 'sort_by', array( date_sub('event/event_date',current date ), false() ) ) )} is it possible?
m.zaki ahmed	Sunday 20 May 2007 1:41:03 am hi any help
André R.	Sunday 20 May 2007 8:43:29 am take a look in overrides/templates/full/event_view_program.tpl in the ezwebin extension for getting the next / prev x events 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
m.zaki ahmed	Tuesday 22 May 2007 4:56:47 am is this in ezpublish 3.9? , i use 3.68

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 18 2025 18:17:13
Script start
Timing:	Jan 18 2025 18:17:13
Module start 'layout'
Timing:	Jan 18 2025 18:17:13
Module start 'content'
Timing:	Jan 18 2025 18:17:13
Module end 'content'
Timing:	Jan 18 2025 18:17:13
Script end

Main resources:

Total runtime	0.0175 sec
Peak memory usage	4,096.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	588.9297	152.6094
Module start 'layout'	0.0063	0.0035	741.5391	39.4297
Module start 'content'	0.0098	0.0055	780.9688	89.3047
Module end 'content'	0.0153	0.0021	870.2734	34.3047
Script end	0.0175		904.5781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	14.9893	14	0.0002
Check MTime	0.0012	6.8685	14	0.0001
Mysql Total
Database connection	0.0011	6.3615	1	0.0011
Mysqli_queries	0.0029	16.3862	3	0.0010
Looping result	0.0000	0.1717	1	0.0000
Template Total	0.0017	9.8	1	0.0017
Template load	0.0008	4.4931	1	0.0008
Template processing	0.0009	5.3162	1	0.0009
Override
Cache load	0.0005	3.1044	1	0.0005
General
dbfile	0.0012	6.7622	8	0.0001
String conversion	0.0000	0.0641	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.0002 secs