Forums / Setup & design / Fetching list of all distinct attribute values.

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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