147
Views
9
Comments
how to update ossys_User.is_active from 0 to 1
Question

what function would update the field ossys_User.is_active 

2018-10-29 08-31-03
João Marques
 
MVP

Hi Bon,


You can use the Update CRUD action from User entity.

You just need to pass the user record with the attribte Is_Active = False.


Cheers,
João

UserImage.jpg
Bon Suen

Hi João,

Thanks for your information. I am newbie of outsystem.

May I know except  UpdateUser function , any other function will update ossys_User.is_active ? Since we have config authentication by Active Directory.  

outsystemconfigureauth.jpg
2018-10-29 08-31-03
João Marques
 
MVP

Hi Bon,


You can also click on the tab Users, search the user you want to inactivate and enter its detail page by clicking on his / her name:


 

And when you are on the detail page of the user, you can select the option Set as Inactive:

 

This will also mark the Is_Active to False for that user.


Cheers,
João

UserImage.jpg
Bon Suen

we found some users should be active in AD but the ossys_User.is_active =0 , we cannot found the user record either in active / inactive user through  user factory

2018-10-29 08-31-03
João Marques
 
MVP

When you enter the Users tab, you will see by default only Active Users. But you can select to see Inactive users, by clicking the Inactive Users option:


After that, it is the same procedure, enter the detail of the page and select the option Set as Active.


Hope it helps.


Cheers,
João

UserImage.jpg
Bon Suen
outsystemconfigureuser.jpg
2018-10-29 08-31-03
João Marques
 
MVP

Hi Bon,


It can be one of three situations:

  1. The user you are searching for does not exist in the OSSYS_USER table;
  2. There is no user with a name, username or email which includes PANGKH, the value you are searching for;
  3. You are searching for an infrastructure user (user who can manage the infrastructure, access Service Center and develop and deploy on Service Studio) which is different than users that use your application. This screen will show the users that use the applications you build with OutSystems.


Cheers,
João

UserImage.jpg
Bon Suen

hi my team check and all negative ..... 

1) check from sql , user exist and the is_active=0 


2025-08-22 10-19-44
Pramod Jain
 
MVP

Hi Bon,

Even when your are using the authentication by Active Directory you can use the same crud actions to update the User Entity.


Regards,

-PJ-  



Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.