hi there, i want to get the name value using the sql in my toad tools. Unfortunately i do not know what the physical User entity table's name?
regards, bb
Hi Barong,
Since User is a system table, it is prefixed with ossys_ (so ossys_user).
Kilian Hekhuis wrote:
Hi Kilian,
Could you please let me know how to insert User data in System.User table. I tried to put insert query through SQL widget. But throwing some error (With Check option....).
Query is
SyntaxEditor Code Snippet
Insert into {User} ({User}.[Name], {User}.[Username], {User}.[Password], {User}.[Email], {User}.[MobilePhone], {User}.[Creation_Date], {User}.[Is_Active] ) values (@Name, @MailID, 'Welcome123', @MailID, @Phno, getdate(), 'True')
Aravind wrote:
Hi Aravind,
If you are inserting by outsystems then you can directly call the "CreateUser" or "CreateOrUpdateUser" crud action provided by User entity.You just need to pass User object.
Thanks,
Manish
thank you Sir, u rock!
You're most welcome :)
You are responding to a topic that's 1.5 years old. Please check the date when replying to a topic. Your question has also little to do with the original question, so next time, start a new topic!
That said, why are you using SQL to insert records into the database? Like Manish wrote, use the Entity Actions that come with the Entities, instead of writing SQL. Use low code!