10-13-2008 11:07 AM
10-13-2008 12:19 PM
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.Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.