I have a GridView that shows projects and their stages status. Below are the table definitions.
projectFk # FK to project(id)
statusFk # FK to status(id)
startDate # Starting date of this status
deadline # Deadline date for this status
endDate # Finish date of this status, if null it means not finish yet
The model used in the GridView is stage and in this GridView there are many projects and each project can have more than one status. I need a kind of switch so that user can see either all projects and their statuses (where I can set the filter to a projects and see their statuses since this GridView shows a same project in many rows), or shows a distinct project with latest status (this is more to group by projectFk).
Is that possible to do so? Any hints or guidance on implement this?