dynamic list for a table column

[xren]

Hello,

Another question about table:

I would like to have a table column as a dynamic drop down list.
The list need to be build based on the login use's role.

Can this be done?

Thanks,
Laura

[Jon]

You can build any type of dynamic drop down list - this part is relatively easy. But the more difficult question is how to get the user's role. I don't know how your logon mechanism is working, but the standard way to do this is to call the Logon Service and then build the roles there - and then a user can have any number of roles, not just one. If this is the way it's done on your system, then getting the user's role is difficult. After the logon has completed, the API just allows you to check whether a user has a named role e.g.

Code: Select all

system.securityManager.hasRole("Role1");

but there is no getRoles() method, so you can't loop through all roles.

How are you setting the user's role? Maybe we can think of another way.

[xren]

Hi Jon,

I can get the role, but when I try to build the list. It does not work. The dropdown list does not show for that column.

tables.xxxxx.column.list.buildList()

Should I loop through all the rows to call the above or it will do it once for all rows? (now neither works for me)

Xiaoli

[Jon]

You only have to build the list for each row if the list has an additional field mapped to another table column. Otherwise it should be fine to just build the list once.

The fact that you don't see a dropdown implies that something is wrong with the list. You should check the list fields are correctly mapped, also you might check the debug option in the Dynamic List editor so you can see the SQL.

Regards
Jon

[xren]

Hi Jon,

You are right. it works now.

Thank you very much!
Xiaoli