| can a group_concat column have a URL? | Ben Bimber | 2011-05-07 14:14 |
| Status: Closed | ||
we have a SQL statement that includes a column generated using group_concat(). in general, labkey allows you to assign a URL for a given column. when i tried to do this for the group_concat column, i got this error: An unexpected error occurred java.lang.AssertionError at org.labkey.api.data.MultiValuedRenderContext.next(MultiValuedRenderContext.java:76) at org.labkey.api.data.MultiValuedDisplayColumn.renderGridCellContents(MultiValuedDisplayColumn.java:51) at org.labkey.api.data.DisplayColumn.renderGridDataCell(DisplayColumn.java:659) at org.labkey.api.data.DataRegion.renderTableRow(DataRegion.java:1456) at org.labkey.api.data.DataRegion.renderTableContents(DataRegion.java:1420) at org.labkey.api.data.DataRegion._renderTable(DataRegion.java:893) at org.labkey.api.data.DataRegion.render(DataRegion.java:2431) at org.labkey.api.data.DataRegion.renderTable(DataRegion.java:701) at org.labkey.api.view.GridView._renderDataRegion(GridView.java:64) at org.labkey.api.view.DataView.renderView(DataView.java:144) at org.labkey.api.view.DataView.renderView(DataView.java:33) at org.labkey.api.view.WebPartView.renderView(WebPartView.java:778) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:289) at org.labkey.api.view.HttpView.render(HttpView.java:139) at org.labkey.api.view.HttpView.render(HttpView.java:121) at org.labkey.api.view.HttpView.include(HttpView.java:542) at org.labkey.api.view.HttpView.include(HttpView.java:519) at org.labkey.api.query.QueryView.renderDataRegion(QueryView.java:1462) at org.labkey.api.query.QueryView.renderView(QueryView.java:1227) at org.labkey.api.view.WebPartView.renderView(WebPartView.java:778) at org.labkey.api.query.QueryView.renderView(QueryView.java:1252) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:289) at org.labkey.api.view.HttpView.render(HttpView.java:139) at org.labkey.api.view.HttpView.render(HttpView.java:121) at org.labkey.api.view.HttpView.include(HttpView.java:542) at org.labkey.api.view.HttpView.include(HttpView.java:519) at org.labkey.jsp.compiled.org.labkey.api.view.template.CommonTemplate_jsp._jspService(CommonTemplate_jsp.java:222) at org.labkey.api.view.JspView.renderView(JspView.java:121) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:289) at org.labkey.api.view.HttpView.render(HttpView.java:139) at org.labkey.api.view.HttpView.render(HttpView.java:121) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:447) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:356) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:756) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:164) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:609) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:143) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) request attributes LABKEY.StartTime = 1304802707015 LABKEY.container = /WNPRC/EHR LABKEY.action = executeQuery LABKEY.RequestURL = /labkey/query/WNPRC/EHR/executeQuery.view?schemaName=study&query.queryName=demographicsAssignmentSummary LABKEY.OriginalURLHelper = /labkey/query/WNPRC/EHR/executeQuery.view?schemaName=study&query.queryName=demographicsAssignmentSummary LABKEY.controller = query LABKEY.OriginalURL = http://localhost:8080/labkey/query/WNPRC/EHR/executeQuery.view?schemaName=study&query.queryName=demographicsAssignmentSummary LABKEY.Counter = 0 core schema database configuration Server URL jdbc:postgresql://localhost:5432/labkey Product Name PostgreSQL Product Version 8.4.6 Driver Name PostgreSQL Native Driver Driver Version PostgreSQL 9.0 JDBC4 (build 801) any reason why a group_concat column cant get a URL? the query works fine if i drop the URL from metadata. for what its worth, the query and metadata from from .sql and .query.xml files in a file-based module. the url i'm attempting to use is: <column columnName="ActiveAssignments"> <columnTitle>Active Assignments (avail=all)</columnTitle> <displayWidth>110</displayWidth> <url>/ehr/executeQuery.view?schemaName=study& query.queryName=Assignment& query.Id~eq=${Id}& query.enddate~isblank& </url> </column> thanks. |
||