Forums / Setup & design / Help with fetch limitation

Help with fetch limitation

Previous topic

Setup & design

Next topic

Author	Message
Daniel Guerrier	Wednesday 24 August 2005 12:25:35 pm I am trying to construct a fetch that is limited to a certain letter of the alphabet. In other words how do fetch all items of a content class that have an attibute text that starts with the letter 'A'. I see fetches that can limit it by a text value but I want to limit by the starting letter. Thanks
Marko Žmak	Wednesday 24 August 2005 4:51:08 pm Use the LIKE operator for atrinute filtering. For details check out this post by Konrad Mazurkiewicz: http://ez.no/community/forum/developer/attribute_filtering -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth

Author

Message

Daniel Guerrier

Wednesday 24 August 2005 12:25:35 pm

I am trying to construct a fetch that is limited to a certain letter of the alphabet.

In other words how do fetch all items of a content class that have an attibute text that starts with the letter 'A'.

I see fetches that can limit it by a text value but I want to limit by the starting letter.

Thanks

Marko Žmak

Wednesday 24 August 2005 4:51:08 pm

Use the LIKE operator for atrinute filtering. For details check out this post by Konrad Mazurkiewicz:

http://ez.no/community/forum/developer/attribute_filtering

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

eZ debug

Timing:

Jan 18 2025 11:03:32

Script start

Timing:

Jan 18 2025 11:03:32

Module start 'content'

Timing:

Jan 18 2025 11:03:32

Module end 'content'

Timing:

Jan 18 2025 11:03:32

Script end

Main resources:

Total runtime

0.1899 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	588.8281	180.8359
Module start 'content'	0.0049	0.0066	769.6641	93.7734
Module end 'content'	0.0115	0.1784	863.4375	522.0234
Script end	0.1898		1,385.4609

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0049

588.8281

180.8359

Module start 'content'

0.0049

0.0066

769.6641

93.7734

Module end 'content'

0.0115

0.1784

863.4375

522.0234

Script end

0.1898

1,385.4609

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	1.9231	20	0.0002
Check MTime	0.0015	0.7711	20	0.0001
Mysql Total
Database connection	0.0004	0.2359	1	0.0004
Mysqli_queries	0.1383	72.8242	141	0.0010
Looping result	0.0019	1.0128	139	0.0000
Template Total	0.1780	93.7	1	0.1780
Template load	0.0009	0.4918	1	0.0009
Template processing	0.1770	93.2255	1	0.1770
Override
Cache load	0.0007	0.3539	1	0.0007
Sytem overhead
Fetch class attribute can translate value	0.0011	0.6055	1	0.0011
XML
Image XML parsing	0.0003	0.1728	1	0.0003
General
dbfile	0.0048	2.5254	20	0.0002
String conversion	0.0000	0.0021	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0037

1.9231

0.0002

Check MTime

0.0015

0.7711

0.0001

Mysql Total

Database connection

0.0004

0.2359

0.0004

Mysqli_queries

0.1383

72.8242

141

0.0010

Looping result

0.0019

1.0128

139

0.0000

Template Total

0.1780

93.7

0.1780

Template load

0.0009

0.4918

0.0009

Template processing

0.1770

93.2255

0.1770

Override

Cache load

0.0007

0.3539

0.0007

Sytem overhead

Fetch class attribute can translate value

0.0011

0.6055

0.0011

XML

Image XML parsing

0.0003

0.1728

0.0003

General

dbfile

0.0048

2.5254

0.0002

String conversion

0.0000

0.0021

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0002 secs