In these examples, the Password class has a prevPasswords string array property. A relational table is created called Password_prevPasswords, with password_oid, value, and number data items.
The SQL statements in the following example list the previous passwords for a current password of abcd.
SELECT * FROM Password, Password_prevPasswords
WHERE Password.oid = Password_prevPasswords.password_oid
AND Password.currentvalue = 'abcd'
The SQL statements in the following example list the most-recent previous password for the abcd password.
SELECT * FROM Password, Password_prevPasswords
WHERE Password.oid = Password_prevPasswords.password_oid
AND Password.currentvalue = 'abcd'
AND Password_prevPasswords.number = 1