Symptom
CASE1: Column filter for job in All Employees is not fetching results for employees whose termination date is between today's date and unlimited.
CASE 2: Advanced filter for job in All Employees is not able to fetch data
Environment
SAP Business ByDesign
Reproducing the Issue
CASE 1:
- Go to Time Administration work center
- Go to Employees view
- Apply filter on column "Job"
- If All Employees are selected it is not working as expected. It shows all the data
- If Active employees are selected it is working as expected.
CASE 2:
- Go to Time Administration work center
- Go to Employees view
- Apply advanced filter
- If All Employees are selected it is not working as expected. It shows all the data
- If Active employees are selected it is working as expected.
Cause
There is a difference in the query built for the Active employees and for All employees in which the parameters for filtering out based on dates are different for both these cases and this seems to be the design for this two queries.
Resolution
To filter out employees based on job role ,use below path:
- Go to Personnel Administration work center.
- Go to Employees view.
- Apply Advanced Filter on Job.
See Also
Keywords
Advanced filter, column Filter, Time administration, Job Role , KBA , SRD-HR-TLM , Time and Labour Management , Problem