Hello,
I have a business rule that requires the previous version of a controlled document to be displayed on the current Effective document. I am trying to use the CDFUpdateAttrsViaQueryMethod with the following argument where a new attribute has been created to store the previous version information (kkad_supersedes) for the cd_controlled_doc type.
-id $value(r_object_id) -query "SELECT object_name FROM dm_document(ALL) WHERE r_object_id in (SELECT i_antecedent_id from dm_document(ALL) where r_object_id=$value(r_object_id) as kad_supersedes from dm_docbase_config" -ignore_null_values true - override true
However, no value is being populated into the attribute. Is there a solution?
Thanks in advance.