Hi,

I have a node with 2 properties,

-          String::name = "bit of everything"

-          UUID::id = "fadeb7f3-224c-48e5-a92f-ca6e1939fa3b"
which are persisted as string node properties.

The following SQL searches return the node...

WHERE CONTAINS(document.name, 'everything')
WHERE CONTAINS(document.name, 'everything*')
WHERE CONTAINS(document.name, '*everything')
WHERE CONTAINS(document.name, '*everything*')
WHERE CONTAINS(document.id, 'fadeb7f3-224c-48e5-a92f-ca6e1939fa3b')
WHERE CONTAINS(document.id, 'fadeb7f3\-224c\-48e5\-a92f\-ca6e1939fa3b')

These don't work...

WHERE CONTAINS(document.id, 'fadeb7f3-224c-48e5-a92f-ca6e1939fa3b*')  // Note 
the wildcard on the end
WHERE CONTAINS(document.id, 'fadeb7f3*')

Please could someone shed some light on why this doesn't work and how I can 
make it work. I realise there is no reason for trying to do a wildcard search 
on a UUID but there comes a time when we just do what we're told!!

Thanks,

Rob.

Reply via email to