Find data in QCombobox invisible column

[Gretsch]

Hi all,

I'm trying to find a method of selecting an item of a combo box populated from a SQL query model.

QSqlQueryModel * query1 = new QSqlQueryModel;
query1->setQuery("SELECT ID, Name FROM Cat order by Name");
myQComboBox->setModel(query1);
myQComboBox->setModelColumn(1);

QSqlQueryModel * query1 = new QSqlQueryModel;
query1->setQuery("SELECT ID, Name FROM Cat order by Name");
myQComboBox->setModel(query1);
myQComboBox->setModelColumn(1);

To copy to clipboard, switch view to plain text mode 

Now I want to find data in the invisible column 0 that matches a given ID so I can set the combo box text from the index that's returned from the found record. I can't find a way of doing this. Is it possible ?

[anda_skoa]

You iterate through the model and access its data using the data() method.
Once you've found what you are looking for you take the row() value of the model index and use setCurrentIndex() on the combobox.

Cheers,
_

[Gretsch]

I worked out a solution:

QModelIndex index;
        QAbstractItemModel * model = myQComboBox->model();
        int ndx = 0;
        for (int i = 0; i < model->rowCount(); ++i)
        {
            index = myQComboBox->model()->index(i,0);
            if (model->data(index)==id)
            {
                ndx = i;
                break;
            }
        }
        myQComboBox->setCurrentIndex(ndx);

QModelIndex index;
        QAbstractItemModel * model = myQComboBox->model();
        int ndx = 0;
        for (int i = 0; i < model->rowCount(); ++i)
        {
            index = myQComboBox->model()->index(i,0);
            if (model->data(index)==id)
            {
                ndx = i;
                break;
            }
        }
        myQComboBox->setCurrentIndex(ndx);

To copy to clipboard, switch view to plain text mode 

[ChrisW67]

You can also use QAbstractItemModel::match()

[Gretsch]

You can also use QAbstractItemModel::match()

That's handy to know, it's a one liner compared to a for...loop, not sure which method would be more efficient though.

[ChrisW67]

match() can search the entire column in table or tree from an arbitrary starting index, optionally wrapping, so it is probably more involved internally.

[anda_skoa]

Efficiency probably depends on the model's implementation of match. Since it is virtual a model could have a non-linear way of looking for the value, e.g. some form of index or lookup-table.

It also doesn't necessarily have to go through data() every time, which, as a public method, has to check its arguments for validity on every call.

The explicit loop allows more flexibility on how the matching is done though, e.g. how to compare the values, whether to do any weighting of match results, etc.

Cheers,
_