AnsweredAssumed Answered

Want SQL query to find Noderef.

Question asked by hardik.thakkar on Jun 11, 2015
Latest reply on Jun 12, 2015 by rjohnson
Hi Team,

I want a list of Noderefs on which custom aspect "abc" and custom property "xyz" are available.

Query should give a list of noderefs in which, this custom property "xyz" has a value in Lower Case.

I have made below query but it did not help me much.

select * from alfresco.alf_node_properties a where a.qname_id = '230' and upper(string_value) != string_value COLLATE Latin1_General_CS_AI;

Thanks,

Outcomes