You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In the candidate list query, max(s.Current_stage) AS LatestVisitStatus will return the the highest value amongst all session Current_stage for the candidate. The highest value is calculated alphabetically.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
stalebot
added
the
Stale
PR has had no activity. Should be triaged for review or possibly closed as low priority.
label
Jan 7, 2020
In the candidate list query,
max(s.Current_stage) AS LatestVisitStatus
will return the the highest value amongst all session Current_stage for the candidate. The highest value is calculated alphabetically.(enum('Not Started','Screening','Visit','Approval','Subject','Recycling Bin'))
So as long as any session Current_stage is 'Visit', the LatestVisitStatus will always be 'Visit'.
The text was updated successfully, but these errors were encountered: