I am currently having a problem with my query:
SELECT DISTINCT a.userID FROM Availablehistory a
WHERE a.action= 'Sign On' AND a.date BETWEEN ?7 AND ?8
The boundaries reflect the past day time limits ( ?1 = Midnight 4 days ago ?2 = 11:59:59 PM 4 days ago)
This query is incorrect since query should only
be taking in the most recent 'Sign On' action performed by each user,
not all 'Sign On' actions from a user.
So if a user performs action 'Sign On' within the past four days, this query will still return a result back since a user did "Sign On' 4 days ago.
I want to add a condition that will drop users from the results Collection that 'Sign On' in the past 4 days and only add to the result sets users that their most recent 'Sign On' action was 4 days ago.
Any thoughts or help will be appreciated.