List of Department not displaying when creating/editing user

[mauricio23]

Greetings!

When I go an create a user or edit a user, I click on "Department" to search for a department to associate the user.

However, this list turns out to be blank. This isn't correct as I definitely have Departments. It seems I can only associate users to Departments if I do one of the following:

• Click "New" on the pop-up window and create a new department
  • However, when I go and query for this department again, it doesn't show
• Go to the User Administration -> Department and add users in a department
  • I'm not a fan of this method as I should be able to do this in the User record

How should I go about troubleshooting this? I would like to be able to assign department at the User record level. Clicking on Department should display a list of available departments to select from.

[Jim Coyne]

Good and you are welcome.

[tanumoy]

Check in the cmn_department table by cmn_department.list, if there is any record present there...

[mauricio23]

Tanumoy Paul - check there and there is definitely values in the cmn_department.list

[mauricio23]

Thanks for pointing me to the Tables Tanumoy Paul - that put me on the right path.

[Gurpreet07]

Check the reference qual for field department . Whatever the filter applied in there is returning no records from referenced table.