How To Set Display Order In QSqlRelation Within QSqlRelationalTableModel

Scott Krise

I am using QSqlRelation to provide the users with a dropdown box showing the valid entries within a browse window. How do you put the entries in some meaningful order? All I can get it to do is to display the information in the physical order they were entered into the table.

See code below. The data in mf_work_center, tt_operator, and mf_cells all display their data in the physical order the data was entered into the table. I want it to be ordered by the work center in the first, the operation in the second, and the cell number in the third.

ipmodel = new QSqlRelationalTableModel(this);
ipmodel->setTable("wo_routing");
ipmodel->setEditStrategy(QSqlTableModel::OnManualSubmit);
ipmodel->setRelation(6, QSqlRelation("mf_work_center", "work_center", "work_center"));
ipmodel->setRelation(5, QSqlRelation("tt_operator", "operator", "operator"));
ipmodel->setRelation(7, QSqlRelation("mf_cells", "cells", "cells"));
ipmodel->setRelation(8, QSqlRelation("mf_machine", "machine", "machine"));
ipmodel->setSort(2,Qt::AscendingOrder);
ipmodel->setHeaderData(Work_Center, Qt::Horizontal, tr("Work Center"));
ipmodel->setHeaderData(Cell, Qt::Horizontal, tr("  Cell  "));
ipmodel->setHeaderData(Operation, Qt::Horizontal, tr("Operation"));
ipmodel->setHeaderData(Machine, Qt::Horizontal, tr("Machine      "));
ipmodel->setHeaderData(Throughput, Qt::Horizontal, tr("Throughput - PT/HR"));
ipmodel->setHeaderData(Setup_Time, Qt::Horizontal, tr("Setup Hrs"));
ipmodel->setHeaderData(PM_Ratio, Qt::Horizontal, tr("PM Ratio/1"));
ipmodel->setFilter(updateStr);
ipmodel->select();

VRonin

Put a proxy-model between your model and the view. You need to subclass QSortFilterProxyModel and reimplement lessThan

Scott Krise

Im trying to do as you suggested...but my syntax must be incorrect. See below...

You understand I want the information within the mf_work_center, tt_operator, and mf_cells tables to appear in a sorted order once they open the pull-down menu, right? Not sure that was clear. Thanks

ipmodel = new QSqlRelationalTableModel(this);
ipmodel->setTable("wo_routing");
ipmodel->setEditStrategy(QSqlTableModel::OnManualSubmit);
ipmodel->setRelation(6, QSqlRelation("mf_work_center", "work_center", "work_center"));
ipmodel->setRelation(5, QSqlRelation("tt_operator", "operator", "operator"));
ipmodel->setRelation(7, QSqlRelation("mf_cells", "cells", "cells"));
ipmodel->setRelation(8, QSqlRelation("mf_machine", "machine", "machine"));
ipmodel->setSort(2,Qt::AscendingOrder);
ipmodel->setHeaderData(Work_Center, Qt::Horizontal, tr("Work Center"));
ipmodel->setHeaderData(Cell, Qt::Horizontal, tr("  Cell  "));
ipmodel->setHeaderData(Operation, Qt::Horizontal, tr("Operation"));
ipmodel->setHeaderData(Machine, Qt::Horizontal, tr("Machine      "));
ipmodel->setHeaderData(Throughput, Qt::Horizontal, tr("Throughput - PT/HR"));
ipmodel->setHeaderData(Setup_Time, Qt::Horizontal, tr("Setup Hrs"));
ipmodel->setHeaderData(PM_Ratio, Qt::Horizontal, tr("PM Ratio/1"));
ipmodel->setFilter(updateStr);
ipmodel->select();

//--- this was added to try to sort the mf_work_center data while displaying pulldown

ipModelProxy = new QSortFilterProxyModel(this);
ipModelProxy->setSourceModel(ipmodel);
ipModelProxy->sort(6, Qt::AscendingOrder);

ui->workorderLineEdit->setText(workorder);

ui->iptableView->close();
ui->iptableView->setModel(ipmodel);
ui->iptableView->setItemDelegate(new QSqlRelationalDelegate(ui->iptableView));
ui->iptableView->resizeColumnsToContents();
ui->iptableView->setAlternatingRowColors(true);
ui->iptableView->setSortingEnabled(true);

ui->iptableView->setColumnHidden(Company,true);
ui->iptableView->setColumnHidden(Release,true);
ui->iptableView->setColumnHidden(WorkOrder,true);
ui->iptableView->setColumnHidden(RowId,true);
ui->iptableView->setColumnHidden(PM_Part_Number,true);
ui->iptableView->setColumnHidden(PM_UPC,true);
ui->iptableView->setColumnHidden(LineNumber,true);
ui->iptableView->setColumnHidden(Percent,true);
ui->iptableView->setColumnHidden(Part_Number,true);
ui->iptableView->setColumnHidden(Sched_Date,true);
ui->iptableView->setColumnHidden(Priority,true);
ui->iptableView->setColumnWidth(7,50);
ui->iptableView->show();

VRonin

@Scott-Krise said in How To Set Display Order In QSqlRelation Within QSqlRelationalTableModel:

You understand I want the information within the mf_work_center, tt_operator, and mf_cells tables to appear in a sorted order once they open the pull-down menu, right?

I did not, no, I thought you wanted to sort the columns.

Try the below to replace your QSqlRelationalDelegates:

class SortedRelationDelegate : public QSqlRelationalDelegate{
    Q_OBJECT
    Q_DISABLE_COPY(SortedRelationDelegate)
public:
    SortedRelationDelegate(QObject* parent = Q_NULLPTR)
        :QSqlRelationalDelegate(parent)
    {}
    QWidget* createEditor(QWidget* parent, const QStyleOptionViewItem& option, const QModelIndex& index) const Q_DECL_OVERRIDE {
        QWidget* const base = QSqlRelationalDelegate::createEditor(parent,option,index);
        QComboBox* const combo = qobject_cast<QComboBox*>(base);
        Q_ASSERT(combo);
        QSortFilterProxyModel* sortProxy = new QSortFilterProxyModel(parent);
        sortProxy->setSourceModel(combo->model());
        sortProxy->sort(0);
        combo->setModel(sortProxy);
        return combo;
    }
};

here I used a straight QSortFilterProxyModel to sort the results but you are free to use a subclass that does the sorting you prefer