Populate QTreeView from SQL.

[Chrisw01]

Hi, I'm trying to populate a QTreeView from SQL database. I have it populating the widget but it is not putting it in a tree.

Here is my code

QSqlQueryModel *model = qobject_cast<QSqlQueryModel*>(ui->invoiceTreeViewWidget->model());
    QSortFilterProxyModel *proxyModel = new QSortFilterProxyModel(this);
    if(model) {
        model->setQuery("SELECT `Invoice Number`, `Invoice Date` FROM INVOICES ORDER BY `Invoice Number`");
        proxyModel->setSourceModel(model);
        ui->invoiceTreeViewWidget->setModel(proxyModel);
    }

I end up with 7 separate entries instead of them being tree'd together

Any help would be appreciated.

Thanks

[mrjj]

@Chrisw01 said in Populate QTreeView from SQL.:

QSqlQueryModel

Hi
As far as i know this returns as table and not tree and hence you have to use a proxy model to supply the tree indexes
http://www.qtcentre.org/threads/23698-how-to-display-QSqlQueryModel-in-QTreeView
or simply build your own model
http://doc.qt.io/qt-5/qtwidgets-itemviews-editabletreemodel-example.html

[Chrisw01]

Hi, and Thanks.

I sorta found that out after hours of extensive searching. I went ahead and wrote my own model to populate the tree.

May not be the correct way but it worked for me..

Thanks again.