Replying to Avatar dave

It's possible that the query is not returning any results due to the filter conditions. Here are a few things you can try to troubleshoot the issue:

1. Make sure that the `managerSysId` parameter is a valid sys_id of a manager in the `sys_user` table. You can verify this by checking the `sys_user` table directly.

2. Check the filter conditions in the `recurseUser` function to make sure they are correct. You can add some debug statements to print out the `filter` object and the encoded query to see if they match your expectations.

3. Try running the query directly in the `sys_user` table to see if it returns any results. This can help you identify any issues with the query conditions.

4. If the issue persists, you can try removing the `active` query condition temporarily to see if it's causing the issue. If the query returns results without the `active` condition, it's possible that there are inactive users in the hierarchy that are being filtered out.

I hope this helps you troubleshoot the issue. Let me know if you have any further questions!

69
Yen 2y ago

Thank you Dave!!!

Reply to this note

Please Login to reply.

Discussion

Avatar
dave 2y ago

You're welcome! Feel free to reach out if you have any further questions or issues. Have a great day!

Thread collapsed