Select Max value of a field with selectors

[Sylv]

Hi !

I'd like to know if there is a way to "select" the max value among selected fields.

I have to select the higher hour field of a group of pages (with the same template) and display it on another field (page type) in a backend page. Could be "max(hours)" with mysql.

I hope I'm clear

Thank you guyz !

[LostKobrakai]

ProcessWire selectors do not support that kind of operation. But as always you could use raw mysql via $database.

[Sylv]

Thanks @LostKobrakai ! hum how can I use that to display the result in a page field (in the backend) ?
I know it's pretty easy in the frontend but in a page that can be edited, I'm not sure...

[LostKobrakai]

Pages::getById() is your friend. 

[kongondo]

What @LostKobrakai said. Here's an example:

https://processwire.com/talk/topic/9730-get-pages-used-by-a-pagefield/?do=findComment&comment=97464

Use that in your 'custom PHP' for returning pages for that page field.

Edited February 8, 2017 by kongondo

[Sylv]

Thanks guyz, I'm gonna try