1 Topic by lekarstvenniy (edited by lekarstvenniy 2022-10-20 09:17:41)

  • lekarstvenniy
  • Nouveau membre
  • Offline

Topic: Change headers on nomenclature

Hello! I use QET v.0.90 and it's great app for scheme drawing! Good job of developers and translators!
Can someone help me on one thing?
I would like to change the headers on nomenclature table: from "Label" to "Item", from "Folio position" to "Page" and etc. How I can do that by esiest way?

PS: Oops! At first I posted this topic in french branch of forum by mistake. If moderators can move it to english branch, it will be good.

Post's attachments

Attachment icon Nomenclature.png 28.68 kb, 90 downloads since 2022-10-20 

2 Reply by lekarstvenniy

  • lekarstvenniy
  • Nouveau membre
  • Offline

Re: Change headers on nomenclature

I found the solution by myself. It's posible to change the nomenclature headers by adding to SQL request operator AS.
For my table SQL request is look like this: "SELECT label, comment, designation, manufacturer, quantity, diagram_position, position FROM..." and so on. I write new header name for specified column by adding new name after AS operator like so: "SELECT label AS Item, comment AS Descriprion, designation, manufacturer, quantity AS Qty, diagram_position AS Page, position FROM...".
May be it was usefull.

Post's attachments

Attachment icon Solution.png 61.33 kb, 101 downloads since 2022-10-20 

3 Reply by scorpio810

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

Re: Change headers on nomenclature

Hi,
see https://qelectrotech.org/forum/viewtopi … 256#p16256

"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 !

4 Reply by lekarstvenniy

  • lekarstvenniy
  • Nouveau membre
  • Offline

Re: Change headers on nomenclature

Thanks, scorpio!
I also found one thing, may be it will be usefull: by SQL request posible to combine folio number and element position like "page.position" (2.B4 or 4.A3).
Add to SQL request text: "..., diagram_position|| '.' ||position AS Position, ..." and in nomenclature table apears column with header "Position" and "page.position" for each elements.