def refreshlistView(self): self.listView.clear() all = KListViewItem(self.listView, 'all') status = KListViewItem(self.listView, 'status') rows = self.db.select(table='trouble_status') for row in rows: s = KListViewItem(status, row.status) s.status = row.status client = KListViewItem(self.listView, 'client') sel = self.db.stmt.select(fields=['clientid'], table='troubles', clause=Neq('status', 'done')) clause = In('clientid', sel) rows = self.db.select(fields=['clientid', 'client'], table='clients', clause=clause) for row in rows: c = KListViewItem(client, row.client) c.clientid = row.clientid magnet = KListViewItem(self.listView, 'magnet') for m in self.manager.getUsedMagnets(): item = KListViewItem(magnet, m) item.magnet = m untouched = KListViewItem(self.listView, 'untouched') statreport = KListViewItem(self.listView, 'status report')