Question: How can I assign a property (in this case `status.val`) to a variable in `ng-repeat` so that I can apply translation to it like the one used above `translation.status`?

Can I do something like `ng-repeat="status in statusList; a=status.val"` ?

```
<div>
  <label for="status">{{translation.status}}</label>
  <select class="form-control" id="status" ng-model="extraItemForm.status" ng-required="true">
    <option ng-repeat="status in statusList" value="{{status.id}}">
      {{status.val}}
    </option>
  </select>
</div>

```

Answer: 
VENDOR\_CODE is not shown because you are grouping by VENDOR.V\_NAME. This means that there can be more than one value ​​in VENDOR\_CODE. This is not possible in SQL. For example, you could use MAX(VENDOR.VENDOR\_CODE) to get the highest VENDOR\_CODE.
VENDOR\_CODE is not shown because you are grouping by VENDOR.V\_NAME. This means that there can be more than one value ​​in VENDOR\_CODE. This is not possible in SQL.
For example, you could use MAX(VENDOR.VENDOR\_CODE) to get the highest VENDOR\_CODE.

A list of possible functions with examples can be found [here](https://www.tutorialspoint.com/sql_certificate/using_the_group_functions.htm#:%7E:text=Group%20by%20function%20establishes%20data,the%20rows%20in%20each%20group.)