Questions tagged [join]

The tag has no usage guidance.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
0 answers
96 views

Join multiple tables in element-api

My problem is the following: I have a website with products which contains ratings. I have an element-api endpoint to get the products. I want to sort the products based on the average rating or the ...
Mathies Gielen's user avatar
0 votes
0 answers
67 views

How to join sections in craft entry query

I want to join sections foo and bar in a craft entry query. Where foo.id = bar.title. How do I query all records in one go in style like craft.entries.section...?
tenshi's user avatar
  • 101
0 votes
0 answers
45 views

Query multiple users and inner join to assets field

How to query multiple users and join to assets field? I want to query users with IDs [1,3,4] and inner join it to assets field with volumeId 5 and titles [1,3,4]. Tried this but this is probably wrong ...
tenshi's user avatar
  • 101