ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 24,664
- Points
- 823
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
Continue reading...
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
Continue reading...