From guillaume@xwiki.com Fri Jul 22 15:16:37 2011
From: Guillaume Lerouge <guillaume@xwiki.com>
To: xwiki-users@xwiki.org
Subject: Re: [xwiki-users] one to many - select - suggest - query error
Date: Fri, 22 Jul 2011 15:16:33 +0200
Message-ID:
 <CAJ97CySnkBtZT209qXc2SpCK=4oCaq7pLDTErXR0jv3n_WghSg@mail.gmail.com>
In-Reply-To: <1044576A-B4C3-44CB-992C-5DB4EED49E2F@intertesto.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============3740167558764181610=="

--===============3740167558764181610==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Gianluca,

yes, using a input field with autosuggest instead of the select list would
work, I've seen this working several times.

Have you looked at the information on
http://platform.xwiki.org/xwiki/bin/view/DevGuide/AutoSuggestWidget#HJavascri=
ptparametersforthe2Aajaxsuggest2Aclass?

Guillaume

On Fri, Jul 22, 2011 at 11:05, Gianluca Sabena <
gianluca.sabena(a)intertesto.com> wrote:

> Hi,
> any news on this front?
> The important part of my question is to know if "display type input"
> allows to display one field and submit a
> different field (I mean to work in the same way select list does)?
>
> Thank you,
> Gianluca
>
> On 12/lug/11, at 13:06, Gianluca Sabena wrote:
>
> > Hi,
> > I have an object (Intranet.AbCompany) where I would like to insert a
> > relation to objects of type Intranet.AbPerson
> >
> > Does "display type input" allow to display one field and submit a
> > different field (I mean to work in the same way select list does)?
> >
> > This is useful because if you have 1000 or more values  select is
> > not practical and the only solution is an input box with suggest. In
> > this scenario, I need to display the person surname, but store the
> > related object id (my use case is an internal address book, where
> > you need to connect company and person)
> >
> > Thank you,
> > Gianluca
> >
> > ------- Note, settings an errors ------------------------
> >
> > Settings:
> >
> > - multiple objects are stored in a single page
> > - field type is "database list"
> > - multiple select, relational storage, suggest are all checked
> > - If display type is select it works well
> > - if display type is input, the suggest ajax call throw an exception
> > - Hibernate query used:
> >
> > SELECT   pval.value, pid.value FROM BaseObject obj, StringProperty
> > pval, StringProperty pid WHERE
> > obj.className=3D'Intranet.AbPersonClass' AND  obj.name <>
> > 'Intranet.AbPersonTemplate' AND pval.id.id =3D obj.id AND pval.id.name
> > =3D 'surname' AND pid.id.id =3D obj.id AND pid.id.name =3D 'name'
> >
> > - ajax exception:
> >
> > Request URL:http://....../xwiki/bin/view/Main/WebHome?
> > xpage
> > =3Dsuggest&classname=3DIntranet.AbCompanyClass&fieldname=3Dperson&firCol=
=3D-
> > &secCol=3D-&input=3Dgianl
> > Request Method:GET
> > Status Code:200 OK
> >
> >
> > 1 requests  =E2=9D=98  9.92KB transferred
> > WebHome
> > /xwiki/bin/view/Main
> >
> > HeadersContentCookiesTiming
> > <a href=3D""
> > onclick
> > =3D"document.getElementById('xwikierror1').style.display=3D'block';
> > return false;">Error number 4001 in 4: Error while parsing velocity
> > page /templates/suggest.vm
> > Wrapped Exception: Failed to evaluate content with id [/templates/
> > suggest.vm]<div id=3D"xwikierror1" style=3D"display: none;"><pre
> > class=3D"xwikierror">
> > Error number 4001 in 4: Error while parsing velocity page /templates/
> > suggest.vm
> > Wrapped Exception: Failed to evaluate content with id [/templates/
> > suggest.vm]
> > com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while
> > parsing velocity page /templates/suggest.vm
> > Wrapped Exception: Failed to evaluate content with id [/templates/
> > suggest.vm]
> >     at
> > com
> > .xpn
> > .xwiki
> > .render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:122)
> >     at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1840)
> >     at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:153)
> >     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:224)
> >     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
> >     at
> > org
> > .apache
> > .struts
> > .action.RequestProcessor.processActionPerform(RequestProcessor.java:
> > 431)
> >     at
> > org
> > .apache.struts.action.RequestProcessor.process(RequestProcessor.java:
> > 236)
> >     at
> > org.apache.struts.action.ActionServlet.process(ActionServlet.java:
> > 1196)
> >     at
> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> >     at
> > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1166)
> >     at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org
> > .xwiki
> > .wysiwyg
> > .server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > com
> > .xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:
> > 68)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org
> > .xwiki
> > .container
> > .servlet
> > .filters
> > .internal
> > .SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:
> > 218)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org
> > .xwiki
> > .container
> > .servlet
> > .filters
> > .internal
> > .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:
> > 112)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
> > 388)
> >     at
> > org
> > .mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
> > 216)
> >     at
> > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
> > 182)
> >     at
> > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
> > 765)
> >     at
> > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
> >     at
> > org
> > .mortbay
> > .jetty
> > .handler
> > .ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
> >     at
> > org
> > .mortbay
> > .jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
> >     at
> > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
> > 152)
> >     at org.mortbay.jetty.Server.handle(Server.java:326)
> >     at
> > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
> > 536)
> >     at org.mortbay.jetty.HttpConnection
> > $RequestHandler.headerComplete(HttpConnection.java:915)
> >     at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
> >     at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:
> > 212)
> >     at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:
> > 405)
> >     at
> > org
> > .mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
> > 409)
> >     at org.mortbay.thread.QueuedThreadPool
> > $PoolThread.run(QueuedThreadPool.java:582)
> >
> >
> > Wrapped Exception:
> >
> > org.apache.velocity.exception.MethodInvocationException: Invocation
> > of method 'search' in  class com.xpn.xwiki.api.XWiki threw exception
> > com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception
> > while searching documents with sql SELECT   pval.value, pid.value
> > FROM BaseObject obj, StringProperty pval, StringProperty pid WHERE
> > lower() like ? and obj.className=3D'Intranet.AbPersonClass' AND
> > obj.name <> 'Intranet.AbPersonTemplate' AND pval.id.id =3D obj.id AND
> > pval.id.name =3D 'surname' AND pid.id.id =3D obj.id AND pid.id.name =3D
> > 'name'
> > Wrapped Exception: could not execute query at /templates/
> > suggest.vm[line 44, column 26]
> >     at
> > org
> > .apache
> > .velocity
> > .runtime
> > .parser.node.ASTMethod.handleInvocationException(ASTMethod.java:243)
> >     at
> > org
> > .apache
> > .velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:187)
> >     at
> > org
> > .apache
> > .velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:
> > 280)
> >     at
> > org
> > .apache
> > .velocity.runtime.parser.node.ASTReference.value(ASTReference.java:
> > 567)
> >     at
> > org
> > .apache
> > .velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:
> > 71)
> >     at
> > org
> > .apache
> > .velocity
> > .runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142)
> >     at
> > org
> > .apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
> >     at
> > org
> > .apache
> > .velocity
> > .runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
> >     at
> > org
> > .apache
> > .velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
> >     at
> > org
> > .xwiki
> > .velocity
> > .internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:
> > 195)
> >     at
> > org
> > .xwiki
> > .velocity
> > .internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:
> > 160)
> >     at
> > com
> > .xpn
> > .xwiki
> > .render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:116)
> >     at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1840)
> >     at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:153)
> >     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:224)
> >     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115)
> >     at
> > org
> > .apache
> > .struts
> > .action.RequestProcessor.processActionPerform(RequestProcessor.java:
> > 431)
> >     at
> > org
> > .apache.struts.action.RequestProcessor.process(RequestProcessor.java:
> > 236)
> >     at
> > org.apache.struts.action.ActionServlet.process(ActionServlet.java:
> > 1196)
> >     at
> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> >     at
> > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1166)
> >     at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org
> > .xwiki
> > .wysiwyg
> > .server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > com
> > .xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:
> > 68)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org
> > .xwiki
> > .container
> > .servlet
> > .filters
> > .internal
> > .SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:
> > 218)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org
> > .xwiki
> > .container
> > .servlet
> > .filters
> > .internal
> > .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:
> > 112)
> >     at org.mortbay.jetty.servlet.ServletHandler
> > $CachedChain.doFilter(ServletHandler.java:1157)
> >     at
> > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
> > 388)
> >     at
> > org
> > .mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
> > 216)
> >     at
> > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
> > 182)
> >     at
> > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
> > 765)
> >     at
> > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
> >     at
> > org
> > .mortbay
> > .jetty
> > .handler
> > .ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
> >     at
> > org
> > .mortbay
> > .jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
> >     at
> > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
> > 152)
> >     at org.mortbay.jetty.Server.handle(Server.java:326)
> >     at
> > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
> > 536)
> >     at org.mortbay.jetty.HttpConnection
> > $RequestHandler.headerComplete(HttpConnection.java:915)
> >     at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
> >     at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:
> > 212)
> >     at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:
> > 405)
> >     at
> > org
> > .mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
> > 409)
> >     at org.mortbay.thread.QueuedThreadPool
> > $PoolThread.run(QueuedThreadPool.java:582)
> > Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3:
> > Exception while searching documents with sql SELECT   pval.value,
> > pid.value FROM BaseObject obj, StringProperty pval, StringProperty
> > pid WHERE lower() like ? and obj.className=3D'Intranet.AbPersonClass'
> > AND  obj.name <> 'Intranet.AbPersonTemplate' AND pval.id.id =3D obj.id
> > AND pval.id.name =3D 'surname' AND pid.id.id =3D obj.id AND pid.id.name
> > =3D 'name'
> > Wrapped Exception: could not execute query
> >     at
> > com
> > .xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:
> > 2162)
> >     at
> > com
> > .xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:
> > 2094)
> >     at
> > com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:689)
> >     at com.xpn.xwiki.api.XWiki.search(XWiki.java:556)
> >     at sun.reflect.GeneratedMethodAccessor444.invoke(Unknown Source)
> >     at
> > sun
> > .reflect
> > .DelegatingMethodAccessorImpl
> > .invoke(DelegatingMethodAccessorImpl.java:43)
> >     at java.lang.reflect.Method.invoke(Method.java:616)
> >     at org.apache.velocity.util.introspection.UberspectImpl
> > $VelMethodImpl.doInvoke(UberspectImpl.java:395)
> >     at org.apache.velocity.util.introspection.UberspectImpl
> > $VelMethodImpl.invoke(UberspectImpl.java:384)
> >     at
> > org
> > .apache
> > .velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
> >     ... 48 more
>
> _______________________________________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>

--===============3740167558764181610==--