Forums / Developer / Filtering records by the value of a identifiar -

Filtering records by the value of a identifiar -

Author Message

suda then

Friday 08 April 2005 1:31:33 am

even though filtered values are not displayed but they have taken the space of a page

eg. I have total 40 records, and 10 records per page(4 pages). I have put a filter by the value of a identifiar. After filtering i got 20 records but instead of 2 pages i got 4 pages
1 page - 3
2 page - 5
3 page - 8
4th page - 4

Eirik Alfstad Johansen

Friday 15 April 2005 2:03:42 am

Hi suda,

It's hard to understand what your problem is due to poor English. Could you please try to explain better?

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Eivind Marienborg

Friday 15 April 2005 2:16:55 am

I think I understand.. After fetching 40 items from database, he filters out 20 of them while looping over them in template, leaving 20 to display. But because the switch is applied when displaying the content, and not when fetching, the pages won't fill up with 10 items on each. Thus meaning that the 20 items still gets displayed over 4 pages:

1 page - 3 (items)
2 page - 5 (items)
3 page - 8 (items)
4th page - 4 (items)

I don't have any good sollutions to it, though.. ;P

suda then

Tuesday 26 April 2005 9:53:50 pm

Thanks Eivind Marienborg

You have understood the problem

suda

Eivind Marienborg

Tuesday 26 April 2005 10:53:57 pm

What you need to do is filter in the fetch. Look around the docs and forum for attribute_filter, there should be plenty of examples you can use :)

eZ debug

Timing: Jan 20 2025 03:59:55
Script start
Timing: Jan 20 2025 03:59:55
Module start 'content'
Timing: Jan 20 2025 03:59:56
Module end 'content'
Timing: Jan 20 2025 03:59:56
Script end

Main resources:

Total runtime1.0187 sec
Peak memory usage4,096.0000 KB
Database Queries202

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0071 589.0859180.8125
Module start 'content' 0.00710.8351 769.8984599.8828
Module end 'content' 0.84220.1765 1,369.7813337.3672
Script end 1.0187  1,707.1484 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00450.4428210.0002
Check MTime0.00150.1455210.0001
Mysql Total
Database connection0.00050.045710.0005
Mysqli_queries0.901388.47322020.0045
Looping result0.00180.17472000.0000
Template Total0.989297.120.4946
Template load0.00190.190820.0010
Template processing0.987296.908820.4936
Template load and register function0.00010.012310.0001
states
state_id_array0.00090.089910.0009
state_identifier_array0.00060.058420.0003
Override
Cache load0.00160.1587250.0001
Sytem overhead
Fetch class attribute can translate value0.00510.499140.0013
Fetch class attribute name0.00080.080570.0001
XML
Image XML parsing0.00140.139840.0004
class_abstraction
Instantiating content class attribute0.00000.001580.0000
General
dbfile0.04053.9709330.0012
String conversion0.00010.006330.0000
Note: percentages do not add up to 100% because some accumulators overlap

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

CacheTypePacklevelSourceFiles
CSS0extension/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
JS0extension/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:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 19
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs