ezFind empty field

Previous topic

eZ Find

Next topic

Author	Message
Ivan Švogor	Tuesday 22 March 2011 8:22:08 am Hi, I'm filtering my articles in the way you don't see ones that are expired, It looks similar to this: [1] {set $filter = $filter\|append('article/unpublish_date:[NOW/DAY-100DAY TO NOW]')} This is supposed to print out all the articles that are expired (not older than 100 day). Now, It works ok. When I want to printout only those that are not expired I use something like this: [2] {set $filter = $filter\|append('article/unpublish_date:[NOWTO NOW/DAY+100DAY] Also, works ok. The problem: I have a lot of articles with unset attribute unpublish_date. So the filter 2 prints only the ones that have unpublish_date set. (therefore this question essentialy means, can I do something like this?:) {set $filter = $filter\|append('article/unpublish_date:[" "]')} -> not working :) Is there a way to print out and those ones that have this field empty? If I need to set unpublish_date to all the early articles (when default value was not set) I will shoot myself :) tnx
Ivan Švogor	Wednesday 23 March 2011 1:47:06 am Yeah... I've figured it out.. Someone on this forum sayd that [ * TO NOW] or any combination of this will work for dates. For some reason it does not work for me. So where the * comes, I just use some timespan that will not happen. I doubt that articles will be older than 100 years, or unpublish date will be later than 100 years. So I'm using this: [NOW TO NOW/DAY+100DAY] If attribute unpublish_date is not set, some suggest you set the filter like so: '-article/unpublish_date:[* TO *]' But it doesn't work for me :) So the solution to my question is: For all articles that are expired: 'article/unpublish_date:[NOW/DAY-100YEAR TO NOW]' And for all that are not expired, and also don't have the unpublis_date attribute set: 'filter', array('or', 'article/unpublish_date:1970-01-01T01\:00\:00Z', 'article/unpublish_date:[NOW TO NOW/DAY+100YEAR]') And that's it, I hope someone else will find this useful.

Author

Message

Ivan Švogor

Tuesday 22 March 2011 8:22:08 am

Hi,

I'm filtering my articles in the way you don't see ones that are expired, It looks similar to this:

[1]   {set $filter = $filter|append('article/unpublish_date:[NOW/DAY-100DAY TO NOW]')}

This is supposed to print out all the articles that are expired (not older than 100 day). Now, It works ok. When I want to printout only those that are not expired I use something like this:

[2]  {set $filter = $filter|append('article/unpublish_date:[NOWTO NOW/DAY+100DAY]

Also, works ok. The problem: I have a lot of articles with unset attribute unpublish_date. So the filter 2 prints only the ones that have unpublish_date set. (therefore this question essentialy means, can I do something like this?:)

{set $filter = $filter|append('article/unpublish_date:[" "]')} -> not working :)

Is there a way to print out and those ones that have this field empty? If I need to set unpublish_date to all the early articles (when default value was not set) I will shoot myself :)

tnx

Ivan Švogor

Wednesday 23 March 2011 1:47:06 am

Yeah... I've figured it out..

Someone on this forum sayd that [ * TO NOW] or any combination of this will work for dates. For some reason it does not work for me. So where the * comes, I just use some timespan that will not happen. I doubt that articles will be older than 100 years, or unpublish date will be later than 100 years.

So I'm using this:

[NOW TO NOW/DAY+100DAY]

If attribute unpublish_date is not set, some suggest you set the filter like so:

'-article/unpublish_date:[* TO *]'

But it doesn't work for me :)

So the solution to my question is:

For all articles that are expired:

'article/unpublish_date:[NOW/DAY-100YEAR TO NOW]'

And for all that are not expired, and also don't have the unpublis_date attribute set:

'filter', array('or', 'article/unpublish_date:1970-01-01T01\:00\:00Z', 'article/unpublish_date:[NOW TO NOW/DAY+100YEAR]')

And that's it, I hope someone else will find this useful.

eZ debug

Timing:	Jan 30 2025 00:16:44
Script start
Timing:	Jan 30 2025 00:16:44
Module start 'layout'
Timing:	Jan 30 2025 00:16:44
Module start 'content'
Timing:	Jan 30 2025 00:16:44
Module end 'content'
Timing:	Jan 30 2025 00:16:45
Script end

Main resources:

Total runtime	0.0171 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.0052	588.1563	151.2109
Module start 'layout'	0.0052	0.0032	739.3672	36.6563
Module start 'content'	0.0085	0.0067	776.0234	91.1406
Module end 'content'	0.0151	0.0019	867.1641	29.9766
Script end	0.0170		897.1406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	15.6962	14	0.0002
Check MTime	0.0013	7.4514	14	0.0001
Mysql Total
Database connection	0.0007	4.3823	1	0.0007
Mysqli_queries	0.0033	19.2347	3	0.0011
Looping result	0.0000	0.0824	1	0.0000
Template Total	0.0013	7.8	1	0.0013
Template load	0.0011	6.1815	1	0.0011
Template processing	0.0003	1.5939	1	0.0003
Override
Cache load	0.0007	4.3934	1	0.0007
General
dbfile	0.0017	10.1042	8	0.0002
String conversion	0.0000	0.0405	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