[RSS Feed/News] A slightly complex query with subqueries in finder

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
Hi all,

I am currently running this query with a fetchOne and I am wondering if there is anyway for me to wrap this into my finder so I can just query through the entity. I haven't had any luck trying to put the where clauses in.

Essentially I am looking for the row with the maximum amount in one column and the minimum amount in another. In plain english, the row that has the highest entry and the earliest date. "Amount" is the field that holds the amount we are checking and post_date...

Read more
Read more about this Feed . . .
 
Status
Not open for further replies.
Back
Top Bottom