problem with filtering by date

Next topic

Author	Message
Lida Popelo	Saturday 09 October 2004 9:02:42 am Hi All, I have a class "some_class" with attribute "begin_date" of type date. In template i want to fetch instances of SomeClass where "begin_date" >= today date, so i wrote: {let items = fetch(content, list, hash(parent_node_id, 64, attribute_filter, array( array(some_class/begin_date, '>=' currentdate())))} But it dosen't work right :( Please help me...
Gunnstein Lye	Monday 11 October 2004 5:04:07 am Instead of writing some_class/begin_date, you should use the attribute id of that attribute (you can see it when you view the class).

Author

Message

Saturday 09 October 2004 9:02:42 am

Hi All,

I have a class "some_class" with attribute "begin_date" of type date.
In template i want to fetch instances of SomeClass where "begin_date" >= today date, so i
wrote:

{let items = fetch(content, 
                   list,
                   hash(parent_node_id, 64,
                        attribute_filter, array(
                                                array(some_class/begin_date, 
                                                      '>='
                                                      currentdate())))}

But it dosen't work right :(
Please help me...

Gunnstein Lye

Monday 11 October 2004 5:04:07 am

Instead of writing some_class/begin_date, you should use the attribute id of that attribute (you can see it when you view the class).

eZ debug

Timing:	Jan 31 2025 06:24:26
Script start
Timing:	Jan 31 2025 06:24:26
Module start 'layout'
Timing:	Jan 31 2025 06:24:26
Module start 'content'
Timing:	Jan 31 2025 06:24:27
Module end 'content'
Timing:	Jan 31 2025 06:24:27
Script end

Main resources:

Total runtime	1.0676 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0075	588.1328	151.2109
Module start 'layout'	0.0075	0.0042	739.3438	36.6641
Module start 'content'	0.0117	1.0550	776.0078	917.1563
Module end 'content'	1.0667	0.0009	1,693.1641	7.8516
Script end	1.0676		1,701.0156

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3061	16	0.0002
Check MTime	0.0013	0.1237	16	0.0001
Mysql Total
Database connection	0.0006	0.0606	1	0.0006
Mysqli_queries	1.0223	95.7566	54	0.0189
Looping result	0.0005	0.0439	52	0.0000
Template Total	1.0222	95.7	2	0.5111
Template load	0.0020	0.1831	2	0.0010
Template processing	1.0202	95.5592	2	0.5101
Template load and register function	0.0012	0.1145	1	0.0012
states
state_id_array	0.0022	0.2049	1	0.0022
state_identifier_array	0.0019	0.1760	2	0.0009
Override
Cache load	0.0016	0.1502	13	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0004	0.0403	2	0.0002
Fetch class attribute name	0.0019	0.1795	3	0.0006
XML
Image XML parsing	0.0006	0.0552	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0007	3	0.0000
General
dbfile	0.0023	0.2186	16	0.0001
String conversion	0.0000	0.0009	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 12 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs