Edit Issue

Start typing to get a list of possible matches or press down to select.
Start typing to get a list of possible matches or press down to select.
Exclude From Covered Issues

Excludes this issue from the Covered Issues page in our website.

Name des Ansprechpartners

Claudiu Muresan wrote:

Hi guys,

I don't know where I can submit issues found with the JCR explorer tool (Toromiro), so I just used this email.
I'm connecting to a Jackrabbit 2.4.0 repository (http://localhost:9091/rmi) to the default workspace.
I need to launch some test JCR-SQL2 queries on the repo (something like below ...)

SELECT * FROM [nt:unstructured] AS inh
INNER JOIN [nt:unstructured] AS ref ON ref.[kmp:reference]=inh.[jcr:uuid]
WHERE (ref.[kmp:searchable]=true AND
    (ref.[kmp:label]='APPLICABLE' OR ref.[kmp:label]='UNCONFIRMED') AND
    CONTAINS(ref.[kmp:factsearch], 'Tac'))

, and I get the below error:

(Image)

I believe you're using result.getNodes(), where result is an instance of QueryResult.
For join queries, you have to allow selecting the selector for which we need to view the results e.g. result.getNodes("inh") or result.getNodes("ref"), where <inh> and <ref> would be an input on the GUI or simply detected from the SQL query (SELECT ... AS inh ... AS ref ...).

Please let me know if this issue can be workaround'ed.

Regards,
Claudiu Muresan

Wie kann das Feature getestet werden?

For example operating system, software platform and/or hardware specifications (include as appropriate for the issue).

Extern sichtbare Beschreibung des Tickets für "Covered Issues".

Beschreibung von weiteren Aufgaben, die vor Fertigstellung/Schließung des Tickets erledigt werden müssen.

None

Jira Software sprint field

Zeitabschätzung im aktuellen Sprint (Anzahl Stunden)

(eg. 3w 4d 12h)
The original estimate of how much work is involved in resolving this issue.
(eg. 3w 4d 12h)
An estimate of how much work remains until this issue will be resolved.
Select a date
Use the dd.MM.yyyy HH:mm date format

Freies Textfeld für Termine

Begin typing to find and create labels or press down to select a suggested label.

Choose an epic to assign this issue to.

Choose a parent to assign this issue to.

<p>Choose a container to assign this issue to.</p>

The results of this ticket should be presented at the sprint-demo.

URL des Original-Tickets bei einem gespiegelten Ticket

Wie oft wurde ein Ticket neu geöffnet?

Select a date
Use the dd.MM.yyyy date format
Select a date
Use the dd.MM.yyyy date format

Controlling: Welcher Kostenstelle werden die Aufwände zugerechnet?

Select a date

The targeted start date. This custom field is created and required by Portfolio for Jira.

- Use the dd.MM.yyyy date format
Select a date

The targeted end date. This custom field is created and required by Portfolio for Jira.

- Use the dd.MM.yyyy date format

The Portfolio for Jira team that will work on this issue.

Cancel