Need query expression to access attributes on related records

[dgeb]

As per the discussion in #369, we'd like to support a new query expression for accessing attributes on related records. This expression should allow for traversing multiple relationships, although sources may choose to limit support for traversal depth.

It's proposed that this expression be called relatedAttribute and take two arguments:

• an array of relationship names
• an attribute name

For example:

oqe('relatedAttribute', ['author'], 'name')

oqe('relatedAttribute', ['author', 'company'], 'city')

This expression could be used in sort expressions as a field. For example:

qb.records('post')
  .sort({ field: oqe('relatedAttribute', ['author'], 'name'), order: 'ascending' });

The following compact form, using dot-separated paths, could de-sugar to the above:

qb.records('post')
  .sort('author.name');

[dgeb]

I am going to close my issue here because the details about query expressions are quite outdated. However, I'm open to considering a proposal for filtering findRecords query ops based on related record attributes.

[mrosenberg]

Did anything ever come of this? I'm running into a situation where sorting by related record would really helpful.