jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "orlando.p" <orlando.pa...@gmail.com>
Subject Re: jackrabbit 2.6.0 Full Text Search
Date Wed, 12 Jun 2013 23:41:53 GMT
Hi Torsten,
Yes, I have seen the link and have tested the following queries as well but
none worked.

SELECT * FROM [nt:resource] as resource WHERE CONTAINS(resource.*, 'This')
SELECT * FROM [nt:resource] as resource WHERE CONTAINS(resource.*, 'This*')
SELECT * FROM [nt:resource] as resource WHERE CONTAINS(resource.*, '*This*')

My other JCR-SQL2 queries work just fine until I add the CONTAINS clause. I
don't see errors in the log file either.

When I dump the result of the query without the CONTAINS clause, I am able
to see the text being searched.  Below is an example of the dumped data with
some lines omitted to reduce size.

[rt.jcr:configuration] ---> []
[rt.jcr:activity] ---> []
[rt.jcr:uuid] ---> [5183ee77-3aa9-497f-928a-4e61b2cac14c]
<<lines omitted>>
[rt.jcr:baseVersion] ---> [ee23fbe3-ec5e-4b29-bed1-24fd5a0a78c1]
[rt.jcr:isCheckedOut] ---> [true]
[rt.jcr:primaryType] ---> [rt:RuleTariff]
[rt.rt:EffectiveStartDate] ---> [20140101000000.000]
<<lines omitted>>
[rt.jcr:versionHistory] ---> [ef428650-639e-4153-9c56-26c82b5fe26b]
<<lines omitted>>
[file.jcr:createdBy] ---> [admin]
[file.jcr:created] ---> [2013-06-12T13:36:36.746-07:00]
[file.jcr:primaryType] ---> [nt:file]
[resource.jcr:lastModifiedBy] ---> [admin]
[resource.jcr:uuid] ---> [3cc13d9e-5f52-49b3-a85d-e626f691305d]
[resource.jcr:data] ---> [<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Strict//EN&quot;
    &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd&quot;>
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<title></title>
<<lines omitted>>
</head>
<body>
<<lines omitted>>

<p class="c4">This is the body.</p>
<<lines omitted>>
</body>
</html>
]
[resource.jcr:encoding] ---> [UTF-8]
[resource.jcr:mimeType] ---> [text/html]
[resource.jcr:lastModified] ---> [2013-06-12T13:36:36.756-07:00]

regards,
Orlando



--
View this message in context: http://jackrabbit.510166.n4.nabble.com/jackrabbit-2-6-0-Full-Text-Search-tp4658832p4658867.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Mime
View raw message