Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
What query is used to determine the results for Other identities with similar properties
설명
When creating a user via the web designer web portal which query is used to determine if that user already exists. A result list with the heading of "Other identities with similar properties" is displayed to the end user.
해결 방안
The query being used is:
-- format("Upper(Firstname) = Upper({0}) and Upper(Lastname) = Upper({1})",sqlformatvalue(from Person select firstname, "string"),sqlformatvalue(from Person select Lastname, "string"))