Forums / Developer / Attribute level filtering on enhanced object relation

Attribute level filtering on enhanced object relation

Next topic

Author	Message
Bertrand Dunogier	Tuesday 20 September 2005 7:21:55 am I have a project content class, with district, location and area attributes; these attributes are enhanced object relations, entered using single select list. I'd like to search every project in location X and / or district Y and / or area Z (an area belongs to a location and a location belongs to a district, so the and / or part is not critical... ^^) Anyway I'm having a BIG headache on the search engine and it's attribute level search. Sometimes I get relevant results, sometimes not... really depends on my search. Now I'm trying to build custom lists using content/list and attribute_filter, but so far, not good... fetch('content', 'list', hash(..., attribute_filter, array(array('projet/commune', '=', '???'))) As far as I understand it, I can't use the city name, since EOR stores object IDs, but since it stores a list, I can't use the ID itself either... Any suggestion ? I'm about to rip my head apart ;)
Xavier Dutoit	Wednesday 21 September 2005 4:03:54 am Hi, The easiest seem to be to get the list of the reverse related objects to a district, location or area as eor stores the district, location or area as related objects. With 3.6.x, you have template operators for that. Have a look at the contrib page, that should give you some hints. X+ http://www.sydesy.com

Author

Message

Tuesday 20 September 2005 7:21:55 am

I have a project content class, with district, location and area attributes; these attributes are enhanced object relations, entered using single select list.

I'd like to search every project in location X and / or district Y and / or area Z (an area belongs to a location and a location belongs to a district, so the and / or part is not critical... ^^)

Anyway I'm having a BIG headache on the search engine and it's attribute level search. Sometimes I get relevant results, sometimes not... really depends on my search.

Now I'm trying to build custom lists using content/list and attribute_filter, but so far, not good...

fetch('content', 'list', hash(..., attribute_filter, array(array('projet/commune', '=', '???')))

As far as I understand it, I can't use the city name, since EOR stores object IDs, but since it stores a list, I can't use the ID itself either...

Any suggestion ? I'm about to rip my head apart ;)

Xavier Dutoit

Wednesday 21 September 2005 4:03:54 am

Hi,

The easiest seem to be to get the list of the reverse related objects to a district, location or area as eor stores the district, location or area as related objects.

With 3.6.x, you have template operators for that. Have a look at the contrib page, that should give you some hints.

X+

http://www.sydesy.com

eZ debug

Timing:

Jan 18 2025 16:25:25

Script start

Timing:

Jan 18 2025 16:25:25

Module start 'content'

Timing:

Jan 18 2025 16:25:26

Module end 'content'

Timing:

Jan 18 2025 16:25:26

Script end

Main resources:

Total runtime

0.7017 sec

Peak memory usage

4,096.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0071	589.3047	180.8125
Module start 'content'	0.0071	0.6919	770.1172	525.9531
Module end 'content'	0.6990	0.0027	1,296.0703	42.2266
Script end	0.7017		1,338.2969

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0071

589.3047

180.8125

Module start 'content'

0.0071

0.6919

770.1172

525.9531

Module end 'content'

0.6990

0.0027

1,296.0703

42.2266

Script end

0.7017

1,338.2969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.4569	14	0.0002
Check MTime	0.0015	0.2208	14	0.0001
Mysql Total
Database connection	0.0006	0.0872	1	0.0006
Mysqli_queries	0.6666	94.9912	55	0.0121
Looping result	0.0005	0.0710	53	0.0000
Template Total	0.6730	95.9	2	0.3365
Template load	0.0020	0.2839	2	0.0010
Template processing	0.6710	95.6283	2	0.3355
Template load and register function	0.0003	0.0380	1	0.0003
states
state_id_array	0.0013	0.1789	1	0.0013
state_identifier_array	0.0007	0.0952	2	0.0003
Override
Cache load	0.0017	0.2369	16	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0735	2	0.0003
Fetch class attribute name	0.0012	0.1713	3	0.0004
XML
Image XML parsing	0.0005	0.0723	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0014	3	0.0000
General
dbfile	0.0007	0.1013	18	0.0000
String conversion	0.0000	0.0010	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.0032

0.4569

0.0002

Check MTime

0.0015

0.2208

0.0001

Mysql Total

Database connection

0.0006

0.0872

0.0006

Mysqli_queries

0.6666

94.9912

0.0121

Looping result

0.0005

0.0710

0.0000

Template Total

0.6730

95.9

0.3365

Template load

0.0020

0.2839

0.0010

Template processing

0.6710

95.6283

0.3355

Template load and register function

0.0003

0.0380

0.0003

states

state_id_array

0.0013

0.1789

0.0013

state_identifier_array

0.0007

0.0952

0.0003

Override

Cache load

0.0017

0.2369

0.0001

Sytem overhead

Fetch class attribute can translate value

0.0005

0.0735

0.0003

Fetch class attribute name

0.0012

0.1713

0.0004

XML

Image XML parsing

0.0005

0.0723

0.0003

class_abstraction

Instantiating content class attribute

0.0000

0.0014

0.0000

General

dbfile

0.0007

0.1013

0.0000

String conversion

0.0000

0.0010

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
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.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	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 6

Usage

Requested template

Template

Template loaded

Edit

Override

node/view/full.tpl

full/forum_topic.tpl

extension/sevenx/design/simple/override/templates/full/forum_topic.tpl