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 31 2025 04:16:43
Script start
Timing:	Jan 31 2025 04:16:43
Module start 'layout'
Timing:	Jan 31 2025 04:16:43
Module start 'content'
Timing:	Jan 31 2025 04:16:43
Module end 'content'
Timing:	Jan 31 2025 04:16:43
Script end

Main resources:

Total runtime	0.0116 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.0043	588.3594	151.2266
Module start 'layout'	0.0043	0.0022	739.5859	36.6797
Module start 'content'	0.0065	0.0038	776.2656	90.2188
Module end 'content'	0.0103	0.0013	866.4844	29.9922
Script end	0.0115		896.4766

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	19.1137	14	0.0002
Check MTime	0.0010	8.4459	14	0.0001
Mysql Total
Database connection	0.0006	5.1142	1	0.0006
Mysqli_queries	0.0018	15.2208	3	0.0006
Looping result	0.0000	0.1052	1	0.0000
Template Total	0.0010	8.7	1	0.0010
Template load	0.0008	6.8017	1	0.0008
Template processing	0.0002	1.9042	1	0.0002
Override
Cache load	0.0006	4.9141	1	0.0006
General
dbfile	0.0003	2.5726	8	0.0000
String conversion	0.0000	0.0495	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