Hello RSA Link,
I have an interesting problem not sure if anyone can help. I'm using a webservice call findUserAccountMappings and it can return one (or more) mapping for the an account.
My command:
Comnand: findUserAccountMappings&format=properties&returnColumns=user_id&account_id=1975
Return: user_id=2507,2528
As you can see there it is returning two users ids. Two double check, I've ran the follow database query to ensure it is a valid response.
Query the Database on the account:
select * from PV_USER_ACCOUNT_MAPPING where ACCOUNT_ID = '1975';
CREATION_DATE | ADC_ID | USER_ID | REMOVE_STATE | DELETION_DATE | IS_DELETED_USER | ACCOUNT_ID | STATE | CREATED_BY | DELETED_BY | ADD_STATE | COMMENTS | LAST_REVIEWED_DATE | |
25/MAY/16 | 13 | 2507 | 0 | n | 1975 | Valid | 0 | ||||||
25/JUN/16 | 13 | 2528 | 0 | 06/JAN/17 | n | 1975 | Valid | 0 |
I only the most recent valid mapping. This account is actively mapped to userid 2507 and was mapped to 2528 in the past.
In the database, DELETION_DATE is a null value.
For example:
findUserAccountMappings&format=properties&returnColumns=user_id,rem&account_id=1975&deletion_date=
findUserAccountMappings&format=properties&returnColumns=user_id,rem&account_id=1975&deletion_date=null
The above examples do not work.
How do I filter by DELETION_DATE when there is not date? This value is the only one available which can distinguish the two results?
For context - this command is used to reset employee passwords when the account is mapped to one user.
There is not a good way to filter on the deletion_date as you have noticed. The workaround may be to get the deletion_date as well apart from user_id and only consider the users without a deletion date.