Dynamic number of columns using JSP Tag

Kiran Krishnamurthy

unread,

Jun 10, 2012, 1:24:49 PM6/10/12

to jm...@googlegroups.com

Hi All,

I am new to JMESA and I want to put use the jmesa jsp tag for generating dynamic number of columns for one of my report generation requirements. here the number of columns will be dynamic as it will depend on the query being executed. i was able to do the same in displaytag till now.

<display:table name="results" class="displayTag" sort="list" export="true" pagesize="20" requestURI="queryReportResult.action">

<% for (int i=0; i < displayProperties.length; i++) { %>

<display:column property="<%=displayProperties[i].getName()%>" title="<%=displayProperties[i].getDisplayName()%>" sortable="true" headerClass="sortable" />

<% } %>

i have tried

<jmesa:tableModel id="tag" items="${listResults}" exportTypes="csv,excel,pdf" stateAttr="restore" var="bean">

<jmesa:htmlTable width="1000px">

<jmesa:htmlRow filterable="true">

<c:forEach var="col" items="${listResults}">

<jmesa:htmlColumn property="${col.name}" sortable="true" filterable="true" filterEditor="org.jmesa.view.html.editor.DroplistFilterEditor"/>

</c:forEach>

</jmesa:htmlRow>

</jmesa:htmlTable>

</jmesa:tableModel>

this is not working. pls suggest how to go abt this.

i also tried with generating the Table from the API

private String getHtmlTable(TableModel tableModel,

DisplayProperty[] display, String caption) {

HtmlTable table = new HtmlTable();

table.setWidth("80%");

table.caption(caption);

HtmlRow row = new HtmlRow();

table.setRow(row);

row.setFilterable(true);

row.setSortable(true);

for (int i = 0; i < display.length; i++) {

HtmlColumn col = new HtmlColumn(display[i].getName().replace(" ",

"_"));

col.setFilterable(true);

col.setSortable(true);

col.setFilterEditor(new org.jmesa.view.html.editor.DroplistFilterEditor());

row.addColumn(col);

}

tableModel.setTable(table);

return tableModel.render();

}

this works in rendering the dynamic columns well. but the other functionality of the toolbar is not working viz: next page, last page, sorting, page size change etc.

i have debugged in the Chrome javascript console and everything seems fine with the JS.

pls let me know how to fix this.

thanks

Kiran

Jeff Johnston

unread,

Jun 12, 2012, 4:39:09 PM6/12/12

to jm...@googlegroups.com

For dynamic columns using the tag library you would use the htmlColumns tag.

http://code.google.com/p/jmesa/wiki/HtmlColumnsGenerator

The documentation for that is a little old. You no longer use the factory. Just create the columns like you did with the API.

Is the table inside a form tag? Also, do you have the onInvokeAction() JavaScript on the page?

-Jeff Johnston

Kiran

--
You received this message because you are subscribed to the Google Groups "JMesa" group.
To view this discussion on the web visit https://groups.google.com/d/msg/jmesa/-/9FMUEJCvhPwJ.
To post to this group, send email to jm...@googlegroups.com.
To unsubscribe from this group, send email to jmesa+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/jmesa?hl=en.

Message has been deleted

Kiran Krishnamurthy

unread,

Jun 13, 2012, 3:06:58 PM6/13/12

to jm...@googlegroups.com

thanks for the reply.

i am using a form only.

${reportresults}

</form>

</div>

function onInvokeAction(id, action) {

setExportToLimit(id, '');

createHiddenInputFieldsForLimitAndSubmit(id);

}

function onInvokeExportAction(id) {

var parameterString = $.jmesa.createParameterStringForLimit(id);

location.href = '${pageContext.request.contextPath}/queryReportExport.action?' + parameterString;

}

</script>

the page renders properly with all the data. the Export options all work fine but the next page, previous page, sorting, filtering, page size dont work at all.

the following is the source of the rendered page. everything seems to be fine but it still doesnt work.

<table id="jmesareport" border="0" cellpadding="0" cellspacing="0" class="table" width="80%" ><caption>FLW Job Aid Usage Report</caption>

<thead>

<tr>

</select></td>

</tr>

</table>

</td>

</tr>

</tr>

<td><div onmouseover="this.style.cursor='pointer'" onmouseout="this.style.cursor='default'" onclick="jQuery.jmesa.addSortToLimit('jmesareport','0','msisdn','asc');onInvokeAction('jmesareport', 'sort')" >Msisdn</div></td>

<td><div onmouseover="this.style.cursor='pointer'" onmouseout="this.style.cursor='default'" onclick="jQuery.jmesa.addSortToLimit('jmesareport','1','operator','asc');onInvokeAction('jmesareport', 'sort')" >Operator</div></td>

<td><div onmouseover="this.style.cursor='pointer'" onmouseout="this.style.cursor='default'" onclick="jQuery.jmesa.addSortToLimit('jmesareport','3','location_id','asc');onInvokeAction('jmesareport', 'sort')" >Location _id</div></td>

<td><div onmouseover="this.style.cursor='pointer'" onmouseout="this.style.cursor='default'" onclick="jQuery.jmesa.addSortToLimit('jmesareport','5','status','asc');onInvokeAction('jmesareport', 'sort')" >Status</div></td>

<td><div onmouseover="this.style.cursor='pointer'" onmouseout="this.style.cursor='default'" onclick="jQuery.jmesa.addSortToLimit('jmesareport','7','call_count','asc');onInvokeAction('jmesareport', 'sort')" >Call _count</div></td>

<td><div onmouseover="this.style.cursor='pointer'" onmouseout="this.style.cursor='default'" onclick="jQuery.jmesa.addSortToLimit('jmesareport','8','secs_of_usage','asc');onInvokeAction('jmesareport', 'sort')" >Secs _of _usage</div></td>

</tr>

</thead>

<td>undefined</td>

<td>UNREGISTERED</td>

</tr>

<td>undefined</td>

<td>UNREGISTERED</td>

</tr>

</tbody>

<tbody>

<td align="left" colspan="10" >Results 1 - 15 of 59.</td>

</tr>

</tbody>

</table>

</div>

jQuery(document).ready(function(){

jQuery.jmesa.addTableFacade('jmesareport');

jQuery.jmesa.setMaxRowsToLimit('jmesareport','15');

jQuery.jmesa.setTotalRowsToLimit('jmesareport','59');

jQuery.jmesa.setPageToLimit('jmesareport','1');

jQuery.jmesa.setOnInvokeAction('jmesareport','onInvokeAction');

jQuery.jmesa.setOnInvokeExportAction('jmesareport','onInvokeExportAction');

jQuery.jmesa.setContextPath('jmesareport','\/openreportsv2');

});

</script>

</form>

</div>

function onInvokeAction(id, action) {

setExportToLimit(id, '');

createHiddenInputFieldsForLimitAndSubmit(id);

}

function onInvokeExportAction(id) {

var parameterString = $.jmesa.createParameterStringForLimit(id);

location.href = '/openreportsv2/queryReportExport.action?' + parameterString;

}

</script>

Jeff Johnston

unread,

Jun 13, 2012, 3:26:53 PM6/13/12

to jm...@googlegroups.com

Did you include the jmesa.js file as well? You would be using it with the createHiddenInputFieldsForLimitAndSubmit call, although I would expect JavaScript errors.

Can you try it in Firefox and see if you see anything different? JMesa works across all browsers but for testing it might clue us into what is going on.

-Jeff

--
You received this message because you are subscribed to the Google Groups "JMesa" group.

To view this discussion on the web visit https://groups.google.com/d/msg/jmesa/-/VJQ9K-ISzW8J.

Kiran Krishnamurthy

unread,

Jun 14, 2012, 1:24:39 AM6/14/12

to jm...@googlegroups.com

Yes.. i have included the jmesa.js as well. The javascript is getting called.. i can see the URL's query string params changing everytime i click the options but the same is not reflecting in the page rendering.

pls find attached the full view source of the page that is rendered.

thanks

Kiran

To unsubscribe from this group, send email to jmesa+unsubscribe@googlegroups.com.

test.html

Reply all

Reply to author

Forward