[xwiki-devs] Using XWQL and HQL on panel
Hey everyone, I wrote a panel in XWiki to do some kind of filtering and retrieving data using both XWQL and HQL, and it works fine on the panel Editing page. But when I try including that panel on some other page, it throws errors. Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [xwiki:Panels.Event Summary] Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'execute' in class org.xwiki.query.internal.DefaultQuery threw exception org.xwiki.query.QueryException: Full form statements requires programming right. Query statement = [select doc.name from XWikiDocument doc, BaseObject as obj, StringProperty prop where doc.fullName = obj.name and prop.id.id=obj.id and prop.name='shortText5' and prop.value='USA' and obj.className = 'Event revised.EventrevisedClass'] at xwiki:Panels.Event Summary[line 14, column 278] Caused by: org.xwiki.query.QueryException: Full form statements requires programming right. Query statement = [select doc.name from XWikiDocument doc, BaseObject as obj, StringProperty prop where doc.fullName = obj.name and prop.id.id=obj.id and prop.name='shortText5' and prop.value='USA' and obj.className = 'Event revised.EventrevisedClass'] I don't know what could be possibly wrong. So, Please help. Thanks, Prachi
If you execute a query that needs the programming rights, you can not do it in a panel. Because, for security reason, $xcontext.dropPermissions() is called before the rendering of the panels. See: https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwik... You can remove this line from contentview.vm, but it is not recommended. I hope it helps, Louis-Marie 2013/10/10 Prachi Maheshwari <[email protected]>
Hey everyone, I wrote a panel in XWiki to do some kind of filtering and retrieving data using both XWQL and HQL, and it works fine on the panel Editing page. But when I try including that panel on some other page, it throws errors.
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [xwiki:Panels.Event Summary]
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'execute' in class org.xwiki.query.internal.DefaultQuery threw exception org.xwiki.query.QueryException: Full form statements requires programming right. Query statement = [select doc.name from XWikiDocument doc, BaseObject as obj, StringProperty prop where doc.fullName = obj.name and prop.id.id=obj.id and prop.name='shortText5' and prop.value='USA' and obj.className = 'Event revised.EventrevisedClass'] at xwiki:Panels.Event Summary[line 14, column 278]
Caused by: org.xwiki.query.QueryException: Full form statements requires programming right. Query statement = [select doc.name from XWikiDocument doc, BaseObject as obj, StringProperty prop where doc.fullName = obj.name and prop.id.id=obj.id and prop.name='shortText5' and prop.value='USA' and obj.className = 'Event revised.EventrevisedClass']
I don't know what could be possibly wrong. So, Please help.
Thanks, Prachi _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
You can still write a query that does not start with SELECT, then you will not need the Programming Rights. Something like (in XWQL): FROM doc.object(Event revised.EventrevisedClass) AS obj WHERE obj.shortText5 = 'USA' It will returns you full names instead of page name, but at least, it works. See: http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module Louis-Marie 2013/10/10 Guillaume "Louis-Marie" Delhumeau <[email protected]>
If you execute a query that needs the programming rights, you can not do it in a panel. Because, for security reason, $xcontext.dropPermissions() is called before the rendering of the panels. See: https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwik...
You can remove this line from contentview.vm, but it is not recommended.
I hope it helps, Louis-Marie
2013/10/10 Prachi Maheshwari <[email protected]>
Hey everyone, I wrote a panel in XWiki to do some kind of filtering and retrieving data using both XWQL and HQL, and it works fine on the panel Editing page. But when I try including that panel on some other page, it throws errors.
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [xwiki:Panels.Event Summary]
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'execute' in class org.xwiki.query.internal.DefaultQuery threw exception org.xwiki.query.QueryException: Full form statements requires programming right. Query statement = [select doc.name from XWikiDocument doc, BaseObject as obj, StringProperty prop where doc.fullName = obj.name and prop.id.id=obj.id and prop.name='shortText5' and prop.value='USA' and obj.className = 'Event revised.EventrevisedClass'] at xwiki:Panels.Event Summary[line 14, column 278]
Caused by: org.xwiki.query.QueryException: Full form statements requires programming right. Query statement = [select doc.name from XWikiDocument doc, BaseObject as obj, StringProperty prop where doc.fullName = obj.name and prop.id.id=obj.id and prop.name='shortText5' and prop.value='USA' and obj.className = 'Event revised.EventrevisedClass']
I don't know what could be possibly wrong. So, Please help.
Thanks, Prachi _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
participants (2)
-
Guillaume "Louis-Marie" Delhumeau -
Prachi Maheshwari