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"))