If not a bug, it’s counterintuitive. If I select fields, it lets me choose the field of the related model, but doesn’t return its value. If I don’t select fields and don’t even use _with, it does return the id of the entry from related table.
I have a table “products”, it holds the id of a row in “brands”. If I select “brands” in _Select Fields, (like only id and brands), it returns only an id.
Also, _SelectFields for related tables does not work - it still requests in an SQL query (in logs) and returns to the BP the data from all fields
I mean there still is a way to do what I need, the interface is misleading. Either remove the related fields from SelectFields, or let it output it. According to the sql query log, the problem may be because it queries the data not by “brand_id”, but just “brand”, as it suggests as a name for a field when you make that relation.