StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3899850
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-10-10T10:03:16.627
FavoriteCount
0
LastActivityDate
2010-10-10T10:03:16.627
LastEditDate
LastEditorUserId
0
OwnerUserId
252727
ParentId
3888367
PostTypeId
2
Score
10
ViewCount
0
LastEditorDisplayName
text
Body
You have to use external pagination feature. First, specify in html tag that you're using external pagination. And create an object implements org.displaytag.pagination.PaginatedList. Finally, you have to implement the DAO which makes actually query for 15 rows only and returns PaginatedList. 1) Your jsp will look like this <pre><code><display:table name="command" sort="external" partialList="true" size="${command.fullListSize}" pagesize="${command.objectsPerPage}"> <display:column property="name" title="name"/> ... </display:table> </code></pre> Note that it specified the sort is external. 2) org.displaytag.pagination.PaginatedList implementation. <pre><code>public class PaginatedListImpl<T> implements PaginatedList{ private int fullListSize; private int objectsPerPage; private int pageNumber; private String searchId; private String sortCriterion; private SortOrderEnum sortDirection; private List<T> list; //getters and setters ... } </code></pre> 3) DAO Implementation sample using hibernate. You can do it with JDBC or anything but make sure you're making the right query to get 15 rows in proper order and return PaginatedListImpl object. <pre><code>@SuppressWarnings("unchecked") public PaginatedListImpl<T> getPaginatedList(PaginatedListImpl paginatedList) { int pageNum = paginatedList.getPageNumber(); final int objectsPerPage = paginatedList.getObjectsPerPage(); final int firstResult = objectsPerPage * pageNum; String sortOrderCriterion = pagiantedList.getSortOrderCriterion(); String sortOrder = paginatedList.getSortOrder String className = type.getName().substring(type.getName().lastIndexOf(".") + 1); final StringBuilder fromClause = new StringBuilder("from " + className + " " + alias); String orderByClause = new StringBuilder(" order by ").append(sortCriterion).append(" ").append(sortDirection); final String hql = new StringBuilder().append(fromClause).append(orderClause).toString(); List<T> resultList = getHibernateTemplate().executeFind(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { return session.createQuery(hql) .setFirstResult(firstResult) .setMaxResults(objectsPerPage) .list(); } }); Long count = (Long)getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { return session.createQuery("select count(*) " + fromClause).uniqueResult(); } }); paginatedList.setFullListSize(count.intValue()); paginatedList.setList(resultList); paginatedList.setPageNumber(pageNum+1); paginatedList.setObjectsPerPage(objectsPerPage); return paginatedList; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODisplay tag pagination problem
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USchanokim
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.