04-20-2010 04:53 AM
04-20-2010 06:16 AM
SELECT anp1.node_id, anp1.qname_id, anp1.string_value, anp2.string_value
FROM alf_node_properties anp1
INNER JOIN alf_qname aq1 ON aq1.id = anp1.qname_id
INNER JOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id
INNER JOIN alf_qname aq2 ON aq2.id = anp2.qname_id
WHERE aq1.local_name = 'password' AND aq2.local_name = 'username';
04-20-2010 05:26 PM
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.