Long time no see! How are you doing?
Here is the problem: I have a list of awards for managers and I would like to select the most important one and display it next to the Description column.
The awards are references to Awards catalog which are stored in Awards tabular section of each manager. The Awards catalog items have the following attributes: Description and Rating as Numeric.
I'm confused with creating a query which will select only one record by a condition. In this case I need to select awards of each employee with the biggest Rating value.
Could you help me with the query?
Common questions about 1C:Query language, Query builder tool and Data composition schema