Good afternoon.
In an SDK extension that is being developed, the database of users and logins is queried by using a person's login name. This works by a login result being obtained by using the login name, and then the User Id in the login result is used to get the User. An issue that we have found is that it is possible to retrieve logins and/or users that have been deleted in Q2 Central at the User and Login level. We do not these results to be possible to be obtained in our algorithm. How can we tell if logins in our search results are deleted?
Thank you,
Ethan
Hello Ethan,
For a login there is a table that is called Q2_UserLogon with a column DeletedDate, If that column is populated, then that login has been deleted. Q2_User is very similar with table name Q2_User and column DeletedDate.
Thank you,
Trey Teter
