QSqlTableModel with WHERE condition

Question

How can i show a table with QTableView and WHERE condition ?

...WHERE numero_conta = 123;

        self.model = QSqlTableModel()
        self.model.setTable('historico')
        self.model.select()

        self.tab_extrato = QtWidgets.QTableView(self.tab_2)
        self.tab_extrato.setObjectName("tab_extrato")
        self.tab_extrato.setModel(self.model)
        self.tab_extrato.hideColumn(0)
        self.verticalLayout_9.addWidget(self.tab_extrato)

link. the entire code

What is the relation between the question about the select and that about the list? — musicamante, Mar 02 '21 at 11:45
`self.model.setQuery(QSqlQuery('SELECT * FROM historico WHERE numero_conta = 123')); self.model.select()`. — ekhumoro, Mar 03 '21 at 11:39

score 2 · Answer 1 · answered Mar 02 '21 at 14:48

2

If you want to use "WHERE" then you want to filter the information so you must use the setFilter() method:

self.model = QSqlTableModel()
self.model.setTable('historico')
self.model.setFilter('numero_conta = 123')
self.model.select()

answered Mar 02 '21 at 14:48

eyllanesc

235,170
19
170
241

QSqlTableModel with WHERE condition

1 Answers1