Hi,
I would like to know whether it is a best practice to update an alias within an alias set using DQL or not.
Thanks in advance.
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
My inquiry is to update the value of a specific alias within an alias set.
Oops, sorry.
Is it safe to do so using DQL or not.
Yes, it's safe - content server when updating objects through DQL does the same things as when modifying objects through API
it's safe, but only superuser can do that:
API> create,c,dm_document...0901ffd7800b956bAPI> save,c,l...OKAPI> retrieve,c,dm_alias_set...6601ffd780000100API> ?,c,update dm_document object set r_alias_set_id='6601ffd780000100' where r_object_id='0901ffd7800b956b'[DM_QUERY_E_UP_BAD_ATTR]error: "The attribute r_alias_set_id is not updateable."API> connect,repo,dmadmin,password...s1API> ?,c,update dm_document object set r_alias_set_id='6601ffd780000100' where r_object_id='0901ffd7800b956b'objects_updated--------------- 1(1 row affected)[DM_QUERY_I_NUM_UPDATE]info: "1 objects were affected by your UPDATE statement."
Hi Panfilov,
Thanks for your reply.
My inquiry is to update the value of a specific alias within an alias set. Is it safe to do so using DQL or not.
Keeping in mind that I tried it using the following query and it works:
update dm_alias_set object set alias_value[<Index>] = '<Value>' where object_name = '<Alias set name>'
And also checked that the permissions of the objects referring to this alias set has been updated with the new alias value.
Seems so far to be safe.
Thanks again Panfilov.
That is what I expected, just needed a confirmation from an expert .
