Hello everyone, i want to ask several questions about ODC. My questions are:
1. Can we set active or inactive and delete records in User table programmatically?
2. We cannot see User table records inside the studio and also in the runtime app (as list records), is it permission that restricts access or something else? This also happens when joining other tables with the User table.
Thank you,
Aditya
Hi Aditya,
The Users' entity isn't implemented in the same way as O11.
It is a cache of logged-in Users, not the User's master data entity
There is no Is_Active attribute or something equivalent (yet).
The only way to deactivate an user is through the ODC Portal:or by programmatically remove all roles (and thereby permissions) to use the ODC apps you build, using the Revoke<role> action, of each role.
OutSystems is working on a public User Management API, that hopefully provide all the features to develop custom User Management screens and processes.
Kind regards,
Daniel
To answer your questions:
1. Currently there are no API's available, like Daniël mentioned. So you would have to deactivate/activate/delete users from ODC Portal.
2. We noticed a similar behavior when users start registration, but not yet finished registration. This may even extend some time (seconds) after finishing the registration process, since the Users table is a view that is cached. We resolved our issues by using an extension table with the UserId as primary key, and filtering on that table in affected queries.