QSqlRelationalTableModel and QItemDelegate

[alex20]

Hello,

I have a column which is the ID of my users this column id is replace by name using relationaltable. When I edit that cell I want to type a name instead of ID after typing each letter new related item will be shown and their ID after clicking on proper item the name and ID painted in one cell.

Any suggestion to implement above...

[SGaist]

Hi,

Use QSqlRelationalDelegate.

[alex20]

Is it possible to send other columns data or other variables to QSqlRelationalDelegate?

[SGaist]

@alex20 said in QSqlRelationalTableModel and QItemDelegate:

Is it possible to send other columns data or other variables to QSqlRelationalDelegate?

What do you mean by that ?

[alex20]

For example I want to pass a variable to QSqlRelationalDelegate for example the database table name. Or a list that delegate should show to be selected by user.

[JonB]

@alex20
The table QSqlRelationalDelegate acts on is the one of the associated QSqlRelationalTableModel (via the view). You could access the table name via that, if you needed it.

The list it shows is obtained via a foreign key:

Unlike the default delegate, QSqlRelationalDelegate provides a combobox for fields that are foreign keys into other tables. To use the class, simply call QAbstractItemView::setItemDelegate() on the view with an instance of QSqlRelationalDelegate:

If you want to supply your own list, you wouldn't bother with a QSqlRelationalDelegate.

[alex20]

As you mentioned it will provide a combobox unfortunately my list is really long to be presented in that unfiltered combobox so I need to have a search box that help the user to filter the list and choose proper item. What do you suggest.

[SGaist]

Do you mean something like a QCompleter ?

[alex20]

It can be some how.... think about google for example how to suggest you while you are searching. I want to do sth same but choosing the name of some primary ID.

[SGaist]

Feed the completer with the database content.