Query for owners of other elements

[AugustMiller]

Like relatedTo() and owner()/ownerId() params, it would be handy to be able to look up the owners of a set of elements:

{% set bendAddresses = craft.addresses().locality('Bend').ids() %}
{% set bendUsers = craft.users().ownerOf(bendAddresses).all() %}

Currently, you have to do a bit of juggling:

{% set bendAddressOwnerIds = craft.addresses()
  .locality('Bend')
  .select(['primaryOwnerId'])
  .column() %}

{% set bendUsers = craft.users()
  .id(bendAddressOwnerIds)
  .all() %}

Similar in nature to #15790

[MoritzLost]

+1, I need this at the moment!

One point regarding the syntax, I would've expected to be able to query by the name of the property – e.g.:

{% set bendAddresses = craft.addresses().locality('Bend').ids() %}
{% set bendUsers = craft.users().addresses(bendAddresses).all() %}

But using ownerOf would work fine as well 👍

[AugustMiller]

Ok—I'm realizing now that this behavior does exist, but only for nested elements owned via custom fields. Both the Matrix field (craft\fields\Matrix::queryCondition()) and Addresses field (craft\fields\Addresses::queryCondition()) allow passing a list of entry/address elements, from which an “exists” condition is built. (This is also what drives the :empty: and :notempty: token feature!)

In this example, storeAddress is an Addresses field:

{% set bendAddressIds = craft.addresses().locality('Bend').ids() %}
{% set bendStores = craft.entries()
  .storeAddress(bendAddressIds)
  .all() %}

[MoritzLost]

@AugustMiller Ah, that's why I assumed querying by addresses would work, I've already done that for Addresses fields.

Would be very useful to have the same thing for Users' addresses 👍