QElectroTech — Summary - Sort by page number

Re: Summary - Sort by page number

null@example.com (HMSpro) — Thu, 09 Oct 2025 08:59:12 +0000

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

Re: Summary - Sort by page number

null@example.com (scorpio810) — Fri, 03 Oct 2025 09:44:32 +0000

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

Re: Summary - Sort by page number

null@example.com (HMSpro) — Thu, 02 Oct 2025 12:40:19 +0000

scorpio810 wrote:

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

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

Re: Summary - Sort by page number

null@example.com (gleissoncg2) — Tue, 30 Sep 2025 23:38:31 +0000

Oh ! Great ! Work !

Tks all !

Re: Summary - Sort by page number

null@example.com (scorpio810) — Fri, 26 Sep 2025 07:23:02 +0000

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

Re: Summary - Sort by page number

null@example.com (achim) — Thu, 25 Sep 2025 19:10:16 +0000

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

Summary - Sort by page number

null@example.com (gleissoncg2) — Thu, 25 Sep 2025 18:28:51 +0000

Hi Guys !

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