Fetching list of all distinct attribute values.

Previous topic

Setup & design

Next topic

Author	Message
Jan Komárek	Saturday 14 February 2009 6:04:49 pm Hello I need to fetch list of all distinct attribute values. I have 3 degree adress district/region/city. District and regions are selectoboxes, but city is text box. And costomer wants to have a filter with select box with cities, but there will be only cities which was filled in... So I need to get all values of attribute. SQL Like: SELECT DISTINCT city FROM adress; Thanks for help.
Łukasz Serwatka	Tuesday 17 February 2009 12:24:25 am Hi, You can try extended attribute filtering. http://ez.no/doc/ez_publish/technical_manual/4_0/reference/modules/content/fetch_functions/list You can alternatively write your own fetch function as well. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Jan Komárek

Saturday 14 February 2009 6:04:49 pm

Hello

I need to fetch list of all distinct attribute values.
I have 3 degree adress district/region/city. District and regions are selectoboxes, but city is text box.
And costomer wants to have a filter with select box with cities, but there will be only cities which was filled in...
So I need to get all values of attribute.

SQL Like:
SELECT DISTINCT city FROM adress;

Thanks for help.

Łukasz Serwatka

Tuesday 17 February 2009 12:24:25 am

Hi,

You can try extended attribute filtering. http://ez.no/doc/ez_publish/technical_manual/4_0/reference/modules/content/fetch_functions/list

You can alternatively write your own fetch function as well.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Timing:	Jan 31 2025 04:14:08
Script start
Timing:	Jan 31 2025 04:14:08
Module start 'layout'
Timing:	Jan 31 2025 04:14:08
Module start 'content'
Timing:	Jan 31 2025 04:14:08
Module end 'content'
Timing:	Jan 31 2025 04:14:08
Script end

Main resources:

Total runtime	0.0161 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.0061	588.2656	151.2266
Module start 'layout'	0.0061	0.0021	739.4922	36.6953
Module start 'content'	0.0082	0.0068	776.1875	90.1875
Module end 'content'	0.0149	0.0012	866.3750	29.9922
Script end	0.0161		896.3672

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	16.3968	14	0.0002
Check MTime	0.0011	7.0768	14	0.0001
Mysql Total
Database connection	0.0010	6.3139	1	0.0010
Mysqli_queries	0.0021	12.9929	3	0.0007
Looping result	0.0000	0.0621	1	0.0000
Template Total	0.0009	5.3	1	0.0009
Template load	0.0007	4.0988	1	0.0007
Template processing	0.0002	1.1962	1	0.0002
Override
Cache load	0.0005	2.8094	1	0.0005
General
dbfile	0.0027	16.6970	8	0.0003
String conversion	0.0000	0.0311	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