Issue 143: Export Filter
Project Member Reported by jeff.johnston.mn@gmail.com, Sep 8, 2008
I was thinking that what I could do is write a filter (or servlet) that
exported the table as is. By that I mean that every request to the page
would put the Limit, Table, and data in the Session scope for the user.
That would give me enough to render the table with the default export
settings. I suppose if everything is serializable I could just put the
table in the session and I would be set.

Of course this would not work for large result sets so it would be up to
the developers discretion to only use it as a convenience for normal-ish
result-sets and if the server can handle loading more into the users
session. If it wasn't for the hit to load the data into session it would be
very easy to do this for any result size.

I can't promise anything, but I could explore what this would mean.


Sep 8, 2008
Project Member #1 jeff.johnston.mn@gmail.com
(No comment was entered for this change.)
Labels: -Type-Defect Type-Enhancement
Dec 21, 2008
#2 qxodr...@gmail.com
in web.xml配置TableFacadeFilter like below:
   <filter>
        <filter-name>TableFacadeFilter</filter-name>
        <filter-class>
            org.jmesa.facade.filter.TableFacadeFilter
        </filter-class>
        <init-param>
            <param-name>exportParam</param-name>
            <param-value>jemsaExport</param-value>
        </init-param>
    </filter>
on jsp config like:
<script type="text/javascript">
function onInvokeExportAction(id) {
    var parameterString = createParameterStringForLimit(id);
    location.href =
'${pageContext.request.contextPath}/presidents.run?jemsaExport=true' + parameterString;
}
</script>

in TableFacadeTag set (limit,exportType) to pageContext,so some column don't need exort
<c:if text="${empty exportType">
<jmesa:htmlColumn property="op" title="操作" styleClass="opCell" width="10%"
editable="${false}"  sortable="false">
                <a  target="_blank" href="${contextPath}/commons
/ViewUserCourseSelect.do?userId=${bean.userId}&year=${bean.year}">详情</a>
            </jmesa:htmlColumn>
</c:if>

fixed-for-143.patch
14.2 KB   View   Download
Dec 21, 2008
#3 qxodr...@gmail.com
The fixed-for-143.patch have some bug,Sorry for the mistake.
fixed-for-143-new.patch
16.6 KB   View   Download
Dec 22, 2008
#4 qxodr...@gmail.com
The fixed-for-143-new.patch also have a bug ,I uploaded a new patch
fixed-for-143-new2.patch
19.2 KB   View   Download
Dec 22, 2008
#5 qxodr...@gmail.com
New patch for solve WorksheetEditor problem
fixed-for-143-new3.patch
19.7 KB   View   Download
Sep 10, 2009
#6 stas.agarkov
"in TableFacadeTag set (limit,exportType) to pageContext"

please tell me how to do this?