jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Haycock <Robert.Hayc...@artificial-solutions.com>
Subject Search - contains with wildcard and UUIDs and dashes
Date Fri, 14 Dec 2012 17:33:38 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message