select props.* from alf_node node, alf_node_properties props, alf_child_assoc asoc, alf_node node2, alf_node_properties props2
where node.id = props.node_id and
node.TYPE_QNAME = '{http://www.alfresco.org/model/action/1.0}actionparameter'
and props.QNAME = '{http://www.alfresco.org/model/action/1.0}parameterValue'
and props.STRING_VALUE IS NOT NULL
and asoc.CHILD_NODE_ID = node.ID
and asoc.TYPE_QNAME = '{http://www.alfresco.org/model/action/1.0}parameters'
and asoc.PARENT_NODE_ID = node2.ID
and node2.TYPE_QNAME = '{http://www.alfresco.org/model/action/1.0}action'
and props2.NODE_ID = node2.ID
and props2.QNAME = '{http://www.alfresco.org/model/action/1.0}definitionName'
and props2.STRING_VALUE = 'mail'
order by props.node_id
2.- Para hacer la prueba, modificaría una de las propiedades (la columna STRING_VALUE, por ejemplo, añadiendole la cadena TEST) para ver si modificando el registro, se modifica la notificación.Content from pre 2016 and from language groups that have been closed.
Content is read-only.
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.