36
Views
7
Comments
User not exists in database table
Question
Application Type
Reactive

Hi everyone!

I have a functionality in my app that creates users using "StartUserRegistration" ServerAction. I need to display all users of my app on the screen. For this I'm using "Users" database table, but it shows only users who have already logged into to the app. Users that are marked as "Pending registration" are not included in this table.


Is there a way to display all users - including those with a "Pending registration" status - in the same table?

2025-08-07 06-30-56
Amit J
Champion

I think, the aggregate you are  using, need to check there , remove any specific filter if you have there.

UserImage.jpg
Łukasz Kaproń

This is not a problem with the Aggregate, because when I check "Users" table, there are no users marked as "Pending registration" in the ODC Portal

2021-01-19 14-07-32
Tom Zhao

Hi @Łukasz Kaproń 

In ODC, only the User table is public, , so it is not possible to retrieve user that is not in the Users table. 

Regards,

UserImage.jpg
Łukasz Kaproń

Is there a way to retrieve users taht are in ODC Portal marked as "Pending registration"?

2026-02-26 06-29-24
Rahul
 
MVP

Hi @Łukasz Kaproń ,

Use one another table as User_Extention and keep Foreign key Delete Rule (Ignore) Concept with User table.

When you start registration keep the record inside User_Extention and userId as blank becuase that time user is not register and you can keep the status also and show the record from this table.

Once user complete the registration Update the User_Extention  record.

Also In ODC User entity is cheche  because it not keep real record if you delete user from portal , it will not delete from User Entity.


Regards

Rahul

UserImage.jpg
Łukasz Kaproń

Hi @Rahul Sahu 

Thank you for your respone. I undertand it, although I find it a bit surprising that there is no way to display all users who have access to the app, but now I know how to handle it. One more thing - you mentioned that I should keep userId field blank, but when I use "StartUserRegistration" ServerAction, it generates UserId

2026-02-26 06-29-24
Rahul
 
MVP
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.