How to use level in ino:explain

1

I am executing following in the web browser.

abc.central/tamino/my_db/workflow?_XQL= ino:explain(count(bpWorkItem[(((assignee/user/loginId = ‘12345’)) and ((assignee/@type = ‘user’)))][state = ‘offered’ or state = ‘accepted’ or state = ‘adhoced’]),tree)

but it show following error.

-
ino:response
-
xql:query
ino:explain((count(agreementSearch[(((isQuickLink = ‘Yes’)) and ((owner/loginId = ‘12345’)))])),path)
</xql:query>
-
<ino:message ino:returnvalue=“8354”>
<ino:messagetext ino:code=“INOXIE8354”>Invalid invocation of ino:explain</ino:messagetext>
</ino:message>
</ino:response>

How to use path and tree level in ino:explain to see the performance ?

Thanks in advance …

Cheers
Ashok

2

Hello Ashok,

the problem is in the second argument to the ino:explain function - it needs to be “tree” in quotes to make it a literal string.

I hope that helps,
Trevor.

3

Thanks Trevor …It worked …