ApiController: Search in joined rows

  • Just as an addition to Sort rows by property that does not have an own database row : It would be great to have a best practice for searching/sorting for joined rows/relations here.

    If I do something like

    I fetch the relations during my query. If I left join the relations again at

    I technically have the same thing done twice. Having a large number of database entries this could be bad for performance reasons.

    Maybe some of you has an better idea how to search for a row that is just related?