Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation.
To learn more about these changes please visit the announcement which can be found
I am writing a report to extract timesheet line item status. My problem is that
MSP_TimesheetLine.TimesheetLineStatus seems to be initialized to 1: Approved - Please confirm. If I am right about this, the resulting report makes no sense to the user - the first state is 'Approved', and then we go to 'Pending Approval'.
I need some sort of SQL CASE statement to hide this initial 'Approved' state.