Forums / Setup & design / Fetch node by aggregation function on attribute

"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".

Fetch node by aggregation function on attribute

« 
Previous topic
|
Setup & design
|
Next topic
 »
Author Message

Jan Komárek

Friday 05 December 2008 2:17:53 am

Hello,

I need to fetch node with highest value of attribute. In SQL qouery its easy

SELECT MAX(attribute) as whatever FROM ...

But I have no idea how to do this in template functions or operators.

Thank you very much for your answer.

Ivo Lukac

Friday 05 December 2008 2:40:46 am

Hello Jan,

Did you try to fetch list function with sorting by this attribute and limit 1?

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac