ObjectRelationFilter: multiple selection of same objects

Author Message

Peter Meyer-Delius

Monday 29 October 2007 2:46:46 am

I am building a Document Management System where Dokuments are shown in Folders when they both have the same Keywords (Object-Relations to Self-made Keyword-Objects)

{def $documents=fetch( content, list, hash( parent_node_id, $parent_nodes,
class_filter_type, include,
class_filter_array, array( 'file'),
'extended_attribute_filter', hash('id', 'ObjectRelationFilter', 'params', array ('and',351,array(2017,2042,2097)))
)
)
}

The first 'and' is there because sometimes the users have keywords too that will be merged with the keywords of the folder.

Problem: Files, which have the Objectrelation to the same Keywords are fetched twice or threefoldly. I need a kind of "distinct" in the select-statement.

Any Ideas anybody?

kind regards,

peter

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 19:38:15
Script start
Timing: Jan 18 2025 19:38:15
Module start 'layout'
Timing: Jan 18 2025 19:38:15
Module start 'content'
Timing: Jan 18 2025 19:38:15
Module end 'content'
Timing: Jan 18 2025 19:38:15
Script end

Main resources:

Total runtime0.0151 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0057 589.2734152.6563
Module start 'layout' 0.00580.0030 741.929739.5078
Module start 'content' 0.00880.0043 781.437585.2891
Module end 'content' 0.01300.0020 866.726630.3047
Script end 0.0151  897.0313 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002516.2820140.0002
Check MTime0.00117.0338140.0001
Mysql Total
Database connection0.00074.673910.0007
Mysqli_queries0.003321.740030.0011
Looping result0.00000.079010.0000
Template Total0.001711.110.0017
Template load0.00095.894210.0009
Template processing0.00085.209710.0008
Override
Cache load0.00064.078010.0006
General
dbfile0.00032.021680.0000
String conversion0.00000.055340.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs