1 Topic by fredkt (edited by fredkt 2021-02-05 10:46:53)

  • fredkt
  • Nouveau membre
  • Offline

Topic: [Solved] Help with nomenclature filter?

Hi all,

I am pretty new to QElectroTech. Will like to first appreciate the great and amazing work of the developers.

I have created an auto generated nomenclature list, however non of the ticks "type of element" meet my requirements. Looks like the developers have provided an additional filter rule. Can someone with knowledge show me how I can eliminate all the empty rows in my table (with red arrows in the attached screen shot)? E.g. how to use "Is empty" filter?

Thanks.

Post's attachments

NomenclatureFilter_.PNG, 81.14 kb, 854 x 718
NomenclatureFilter_.PNG 81.14 kb, 184 downloads since 2021-02-05 

  • fredkt
  • Nouveau membre
  • Offline

Re: [Solved] Help with nomenclature filter?

Hi All,

I actually noticed that there is an SQL query option, so I was able to eliminate the empty rows:

SELECT diagram_position, position, label, plant, location, function, manufacturer, manufacturer_reference, supplier, quantity FROM element_nomenclature_view WHERE plant IS NOT NULL AND location IS NOT NULL ORDER BY diagram_position, position, label, plant, location, function, manufacturer, manufacturer_reference, supplier, quantity

thanks