Skip to main content
R
RM1214-Alexandrite
14-Alexandrite
December 7, 2020
Solved

How to write sql query for get old password in thingworx?

  • December 7, 2020
  • 2 replies
  • 4377 views

Hello,

          I'm using postgresql database, I want to compare database data and with mashup data please suggest and refer the below attachment For this :

1) How do I write sql query for get old password in thingworx?

2) how to write validation for password 15 character or above?

Thanks in advanced

 

 

Best answer by zyuan1

The User password is stored as hashed string, administrator won't be able to extract data password from database, and we can't tell how long the old password is.

 

Besides, if you want to update new password through composer, you'll get a warning if the password does not meet request, the only OOTB way of changing password from outside of Composer is Reset Password button in FormLogin page, we don't have option to make changes in here.

 

If you customized a mashup for user creation process, you can try to use Expression/Validation in the functions of mashup, and use the result to control the visiblity of a Label containing warning message.

2 replies

C
Ciprian-Traian5-Regular Member
5-Regular Member
December 7, 2020


Hello @RM12,

 

There is another post which deals with a similar scenario. Have you seen the following thread forget administrator password

 

Hope it helps,

Z
zyuan15-Regular MemberAnswer
5-Regular Member
December 10, 2020

The User password is stored as hashed string, administrator won't be able to extract data password from database, and we can't tell how long the old password is.

 

Besides, if you want to update new password through composer, you'll get a warning if the password does not meet request, the only OOTB way of changing password from outside of Composer is Reset Password button in FormLogin page, we don't have option to make changes in here.

 

If you customized a mashup for user creation process, you can try to use Expression/Validation in the functions of mashup, and use the result to control the visiblity of a Label containing warning message.

Terms & ConditionsCookie settingsAccessibility statement