Avoiding Single Quotes in Usernames: Lessons for DQL Queries
Here is the error: Caused by: com.documentum.fc.common.DfException: [DM_QUERY_E_SYNTAX]error: “A Parser Error (syntax error) has occurred in the vicinity of: select distinct(object_name) from dms_type_permissions where delete_permission = true and role_name in ( select distinct(group_name) from dm_group where any i_all_users_names =’John D’Aguiar” When creating usernames, especially in systems that rely on query languages like Documentum Query Language…