I am building a POC for leave management systems. Tables: Employee( holds employee details), Leave balance(holds leave balance and the leave type), Leave table( shows the type of leave and its maximum limit), and leave history(holds leave history of employees)
I am trying to check the leave balance for the employee with filter - logged in user and leave type . leave type is Integer. I get results of every leave type which is not my expectation. please help me fix this issue. I want only the leave balance for a particular type.
query
o
output:
Discussion posts and replies are publicly visible