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
You'll have to do an aggregation with the SUM function on the leaveBalance field.
Can you try adding this field that you are adding a filter on, in the relatedRecordData configuration and see if it works?
I tried relayedRecordData, didn't work
okay,Will try
this issue has been resolved .
Why some record fields (createdOn, createdBy and status) are not showing results