Topic: Summary - Sort by page number

Hi Guys !

How can I sort by page number?
I tried, but they are out of order.

Post's attachments

Attachment icon Captura de tela 2025-09-25 152807.jpg 229.88 kb, 1 downloads since 2025-09-25 

Re: Summary - Sort by page number

Set the 'Page' column first, or adjust the SQL query

  • scorpio810
  • scorpio810
  • QElectroTech Team Manager, Developer, Packager
  • Offline

Re: Summary - Sort by page number

SELECT  folio, title, author, date FROM project_summary_view ORDER BY pos, folio, title, author, date

https://download.qelectrotech.org/qet/forum_img_2/summary_sql.png

"Le jour où tu découvres le Libre, tu sais que tu ne pourras jamais plus revenir en arrière..."Questions regarding QET belong in this forum and will NOT be answered via PM! – Les questions concernant QET doivent être posées sur ce forum et ne seront pas traitées par MP !

Re: Summary - Sort by page number

Oh ! Great ! Work !

Tks all !

  • HMSpro
  • Nouveau membre
  • Offline

Re: Summary - Sort by page number

scorpio810 wrote:
SELECT  folio, title, author, date FROM project_summary_view ORDER BY pos, folio, title, author, date

https://download.qelectrotech.org/qet/forum_img_2/summary_sql.png

Hi Laurent,

I defined an user-property which is used on each folio. How can I use it within the SQL command?
If I just change your command into 

SELECT  folio, title, date, status FROM project_summary_view ORDER BY pos, folio, title, date, status

it only shows a little grey box.

BR Joe

  • scorpio810
  • scorpio810
  • QElectroTech Team Manager, Developer, Packager
  • Offline

Re: Summary - Sort by page number

Hi Joe,

export your database and open it, you can show if your user-property appears?
See my post here:
https://qelectrotech.org/forum/viewtopi … 256#p16256

Code database:
https://github.com/qelectrotech/qelectr … tabase.cpp


BR Laurent

"Le jour où tu découvres le Libre, tu sais que tu ne pourras jamais plus revenir en arrière..."Questions regarding QET belong in this forum and will NOT be answered via PM! – Les questions concernant QET doivent être posées sur ce forum et ne seront pas traitées par MP !
  • HMSpro
  • Nouveau membre
  • Offline

Re: Summary - Sort by page number

Hi Laurent,

thank you so much for your help. It appears that the custom value (see attachment) is not being saved in the database. Is it being saved somewhere else?

BR, Joe

Post's attachments

Attachment icon QElectroTech_Custom-Folio-Value.png 45.04 kb, file has never been downloaded.