Help with setting QTableView's vertical header data

  • Hey everybody!

         I need some help with setting the vertical header data of _QTableView_ to a list of strings in a _QStringList_. I am able to set the horizontal data using

    QSqlQueryModel *model = new QSqlQueryModel;
    model->setHeaderData(0, Qt::Horizontal, tr("Age"));
    model->setHeaderData(1, Qt::Horizontal, tr("Salary"));

    but when I try to customize the row header label, the following code returns false.

    QSqlQueryModel *model = new QSqlQueryModel;
    model->setHeaderData(0, Qt::Vertical, tr("Andrew"));
    model->setHeaderData(1, Qt::Vertical, tr("Isobel"));

    I found "this": but I didn't really understand how the OP implemented it. Could anybody please help me?

  • See class-documentation of "QSqlQueryModel": for setHeaderData again:

    Returns true if orientation is Qt::Horizontal and the section refers to a valid section; otherwise returns false.

  • I did read the documentation before and I did so again. My question is, since it returns false for anything other than Qt::Horizontal, is it possible to set the label for the vertical headers? If yes, how?

  • Lifetime Qt Champion

    IIRC for the QSqlQueryModel, the vertical headers text are based on what the select statement contains. In that case you can write your select statement with the column name you want to have in you headers.

    @SELECT a.columnName AS MyColumnName FROM a@

    BEWARE this is not tested.

    Out of curiosity, why do you want the vertical headers to contain people names ?
    Shouldn't you have something like Name, Age, Salary, and in your horizontal data "Andrew", "50", "2500" ?

  • The solution you suggested is not an option because I want to generate the vertical header labels using the values in a QStringList.

    I gave names as vertical headers just as an example. I am coding a TV guide which will have channel names as the vertical header, shows of each channel as the rows and timings of the shows as the horizontal header. I was too lazy to explain all this which is why I gave names as an example :)

  • Lifetime Qt Champion

    Then, how does your query return the data for each separated channel ?

  • The query is within a channels loop where each loop returns all the shows for a particular channel.

  • Lifetime Qt Champion

    Is the loop in SQL or in c++ ?

  • c++

  • Lifetime Qt Champion

    In that case, how do you setup the grid ? The QSqlQueryModel will only contain the data for the current channel not all

  • Yes. I do something like this

    @Loop for channel {

      For each channel, get all the show details
      Loop for all the shows {
               Display all the shows for channel n


    So the result is

    1 | Show Title | Show Title | Show Title | Show Title .....
    2 | Show Title | Show Title | Show Title | Show Title ....
    3 | Show Title | Show Title | Show Title | Show Title ....

    But instead of the 1, 2, 3 .... in the column header, I want

    HBO | Show Title | Show Title | Show Title | Show Title .....
    CBS | Show Title | Show Title | Show Title | Show Title ....
    Fox | Show Title | Show Title | Show Title | Show Title ....

    I hope I'm able to put across my problem clearly. I'm struggling to find words to explain it to you. Sorry!

  • Lifetime Qt Champion

    Hum... Just to be sure:
    Do you mean:
    HBO | CBS | Fox | <- horizontal headers
    vertical headers->1 ShowTitle | ShowTitle |ShowTitle |
    2 ShowTitle | ShowTitle |ShowTitle |
    3 ShowTitle | ShowTitle |ShowTitle |


    Corrected horizontal/vertical headers

  • No no! I mean

    2:00 | 2:30 | 3:00 | <- horizontal headers
    vertical headers-> HBO ShowTitle | ShowTitle |ShowTitle |
    CBS ShowTitle | ShowTitle |ShowTitle |
    Fox ShowTitle | ShowTitle |ShowTitle |

    I know it's weird but using the below code changes the row headers and not the column headers. Which basically means that the horizontal header is the row header and the vertical header is the column header.

    QSqlQueryModel *model = new QSqlQueryModel;
    model->setQuery("SELECT name FROM channel");
    model->setHeaderData(0, Qt::Horizontal, tr("2:00"));
    model->setHeaderData(1, Qt::Horizontal, tr("2:30"));
    model->setHeaderData(1, Qt::Horizontal, tr("3:00"));

    Thanks for being patient :)

  • Lifetime Qt Champion

    Right, might be confusing: The horizontal header view is for the column name and the vertical is for the row name. It's more a positional point of view: The header view "deploys" horizontally so it shows the column name.

    Anyway, the QSqlQueryModel doesn't allow to set the vertical header data. But what intrigues me is how to you make your grid from your SQL ?

    With your last query you will only get one column with the channel names.

    How does your database look like ?
    A table with the channels and a table with the shows and their time ?

  • [quote author="SGaist" date="1366987686"]With your last query you will only get one column with the channel names.

    How does your database look like ?
    A table with the channels and a table with the shows and their time ?[/quote]

    Yes, I will get only one column with the channel name which I want to display as the vertical headers.

    Within the loop where I get the channel names, I use another SQL query to get all the show titles and timings for that particular channel which is active in the current loop.

    For example, if my channels are HBO, Fox and CBS, I run a loop while to get each channel. Inside this loop, when HBO is my current channel query.value(0), I use the channel name to get the show titles and then display them. Since the loop will run thrice, I get all the show titles for all three channels one after the other.

  • Lifetime Qt Champion

    Then... Why do you use a QTableView with a QSqlQueryModel ? You won't get all shows data since you change the query on each loop

  • OMG! I'm so sorry. I'm confusing you and myself here. When I couldn't set the QTableView's vertical header, I moved on to generating the grid using just QLabels and that's when I used the looping technique. I'm so so sorry for the confusion.
    With QSqlQueryModel, i simply used a single query to get the show details. However, I couldn't display the channel details as the vertical header which is why I posted this question originally.
    Once again, I'm really very sorry :(

  • Lifetime Qt Champion

    If you are now running the query for each channel individually and pulling the data. You could simply use a QTableWidget and make the grid as you wanted before.

  • I could. But there's another problem. Please have a look at "this question": I posted.
    What I actually have to do is this:


    | Label1 | Label2 | Label3 | Label4 |

    | Label5 | Label6 | Label7 | Label8 |

    | Label9 | Label10 | Label11 | Label12 |


    So I not only have to generate these labels on the GUI, but also access them using indices so I can manipulate their properties like

    label [0][2]->setText("Changed label");

    I'm struggling to find the right data structure to use to solve my issue. Please please help.

  • Hi again!

        I couldn't solve my problem using _QTableWidget_ or similar widgets so I used a different "approach": instead. I'd love to learn new ways of solving the same problem though :)

  • Lifetime Qt Champion

    Ok I see now...

    With layout you need, you would have to make your own QAbstractItemView on top of your model

  • Oh ok. I'll try implementing that too and see which one suits better. Thanks very much for your assistance SGaist. You've been very kind and patient :)

  • Lifetime Qt Champion

    You're welcome !

    IIRC there are some good examples in the book Advanced Qt Programming that might help

  • By Mark Summerfield right? I have that book. I read the first few pages and then I got too lazy to continue. I learned so much more from "Void Realms":, "Bucky":, online Qt "documentation": and of course the most awesome forum on web, :)
    But I guess I could give the book another try!

Log in to reply

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.