Want SQL query to find Noderef.

[hardik_thakkar]

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,

[rjohnson]

Why do you not use a Lucene query? There is a whole search subsystem in Alfresco to do this kind of thing "easily".