Sylv Posted February 8, 2017 Share Posted February 8, 2017 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 ! Link to comment Share on other sites More sharing options...
LostKobrakai Posted February 8, 2017 Share Posted February 8, 2017 ProcessWire selectors do not support that kind of operation. But as always you could use raw mysql via $database. Link to comment Share on other sites More sharing options...
Sylv Posted February 8, 2017 Author Share Posted February 8, 2017 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... Link to comment Share on other sites More sharing options...
LostKobrakai Posted February 8, 2017 Share Posted February 8, 2017 Pages::getById() is your friend. Link to comment Share on other sites More sharing options...
kongondo Posted February 8, 2017 Share Posted February 8, 2017 (edited) 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 1 Link to comment Share on other sites More sharing options...
Sylv Posted February 8, 2017 Author Share Posted February 8, 2017 Thanks guyz, I'm gonna try Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now