How to change a request in 1C?

Question

1C

SELECT
Nomenclature.Reference AS Nomenclature
FROM Directory.Nomenclature AS Nomenclature
WHERE Nomenclature.Type of Nomenclature =
VALUE(Enumeration.Types of Nomenclature.Product) UNITE
ALL
SELECT
Nomenclature.Reference
FROM Directory.Nomenclature AS Nomenclature
WHERE What needs to be changed in the query body/layout settings so that the selection that the user imposes in the build settings only applies to the first join in the query. That is, so that the user can filter only the list of goods, and services are always displayed in full.

Answer 1

A request in the data source is just your wish to the system to collect information. If you don't explicitly output a field (registrar, in this case), then the layout system optimizes the query for faster execution before execution - in this case, it removes references to an unused registrar.