StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1369895
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-09-02T20:17:04.053
FavoriteCount
0
LastActivityDate
2009-09-03T16:21:03.773
LastEditDate
2009-09-03T16:21:03.773
LastEditorUserId
78723
OwnerUserId
78723
ParentId
1369494
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<ul> <li>You'll need to determine which rows to select. To do so, loop through the entire model and determine which rows have NULL as the timestamp. To access the model's data, you can use <a href="http://doc.trolltech.com/4.5/qsqlquerymodel.html#record" rel="nofollow noreferrer"><code>QSqlQueryModel::record()</code></a>.</li> <li>You'll need to create a custom selection. The current selection is represented by the <a href="http://doc.trolltech.com/4.5/qitemselectionmodel.html" rel="nofollow noreferrer"><code>QItemSelectionModel</code></a> class. You can access the table view's slection via <a href="http://doc.trolltech.com/4.5/qabstractitemview.html#selectionModel" rel="nofollow noreferrer"><code>QAbstractItemView::selectionModel()</code></a> and <a href="http://doc.trolltech.com/4.5/qabstractitemview.html#setSelectionModel" rel="nofollow noreferrer"><code>QAbstractItemView::setSelection()</code></a>.</li> </ul> <p>In response to your code update, you could do without the loop if you use <a href="http://doc.trolltech.com/4.5/qabstractitemview.html#SelectionBehavior-enum" rel="nofollow noreferrer"><code>QAbstractItemView::SelectRows</code></a>. Just use the selection you received from <a href="http://doc.trolltech.com/4.5/qabstractitemmodel.html#match" rel="nofollow noreferrer"><code>QAbstractItemModel::match()</code></a>.</p> <p>As for speed, do check the efficiency of the table on a release build -- I know that debug/release build differences are big for cases like yours. If you're using Qt 4.5 you'll notice a speed-up too, as they did work to improve elements like tables in that release.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to efficiently select a subset of rows of a QTableView that match certain criteria?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USswongu
UserOwnerUserId
1. USswongu
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. This table or related slice is empty.
CommentsPostId
1. COThe QAbstractItemModel supports a function called match, it will do the searching for you, and returns a list of QModelIndex entries
  singulars
  PostPostId
  PO
  UserUserId
  USHarald Scheirich
2. COCool, I've never used that function before but it seems to take care of the first point.
  singulars
  PostPostId
  PO
  UserUserId
  USswongu

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.