Questions tagged [relations]

Questions around Craft's relational field types.

Filter by
Sorted by
Tagged with
2 votes
1 answer
162 views

Craft 4: using the new laravel collections and related methods (in a performant way)

I am working on a website for a radio that publishes its programs as podcasts with episodes. Each of the 30 or so programs potentially has a lot of episodes. Each entry in the episodes channel has a ...
user avatar
0 votes
0 answers
32 views

Order related entries by the amount they have in common

I am trying to build a function that creates a list of related entries based on a few criteria. This is no issue since this can be easily achieved by using relatedTo. The problem I am facing is, I can'...
user avatar
  • 63
0 votes
0 answers
47 views

How to query relations within Supertable field via GraphQL

I have two Entry types: Albums and Songs. On the Albums entry type, I have a SuperTable field (called tracklist) where you can add tracks and select one Song entry per row. On the song page, I'd like ...
user avatar
1 vote
1 answer
24 views

Fetching entries that are related to 'not null'

I have a channel with Authors. Not all of them are used right now, so I'm trying to construct a query that will fetch all Authors are are related to some article. This is what I've tried so far: {% ...
user avatar
2 votes
1 answer
52 views

Eager loading categories and assets inside related entries for gallery

I am looking for some advice on how to best streamline a gallery system on a site, but having trouble wrapping my head around the syntax needed to eager load nested asset fields with categories inside ...
user avatar
1 vote
1 answer
19 views

Query entries "with" entries that are actually related

I have a simple query: $paidFeatures = Entry::find() ->section('paidFeatures') ->type(['simpleFeature', 'customFeature']) ->with(['relatedEntries']) ...
user avatar
1 vote
1 answer
45 views

Allow drafts in entries field

Is it possible to allow selecting drafts in an entries field? Not drafts of an existing live entry, but drafts that aren't published yet. The only thing I found is an ElementCriteriaEvent triggered in ...
user avatar
  • 6,360
0 votes
0 answers
55 views

Get related entries / users filtered by relation field name in GraphQL

I wonder if it's possbile to deal with the following situation with Craft CMS in graphQL: We have users related to projects in two different ways: users.bookmarkedProjects = [projectIds] project....
user avatar
2 votes
1 answer
31 views

Sorting Categories/Entries by # of relations dynamically

does anyone know if there's a way to display a type of "most popular categories" list? It's not exactly my use-case, but it's very similar Essentially, I want to be able to have users search ...
user avatar
0 votes
1 answer
60 views

Find related entries by specific position in the entries field

I'm looking for a way to limit a reverse relations query to only match the first selected entry in an entries field. Some context: I have two entry types, institutes and offers. Offers have an ...
user avatar
  • 6,360
1 vote
0 answers
49 views

Order element query by number of related categories

I'm building an entry template that displays related entries to the current entry. To be related, an entry needs to be the same type as the current entry and share at least one category in one of two ...
user avatar
  • 6,360
1 vote
1 answer
47 views

Get raw/unformatted field values?

Is there a way to get raw/unformatted values for a field before they're passed to the field's normalizeValue function? That is, get the value close to how it's stored in the database? I haven't found ...
user avatar
  • 6,360
0 votes
0 answers
64 views

how to retrieve any/all related entries?

I have list of banks(institutions) that each one has branches. I'm using GraphQL API. By the bellow code I can get the branches with associated bank(institutions): query branches { entries(limit: ...
user avatar
1 vote
1 answer
41 views

Entries not being related

I am trying to query all entry elements related to a category but I am only able to get some of the entries to show up when I run craft.entry().relatedTo(category) I have a matrix field in the entries ...
user avatar
2 votes
1 answer
89 views

How many levels will RelatedTo work? In Reverse?

The TL;DR summary: if I have a related Entries field that I access, can I then access an Entries field within that entry? I created a learning project running on MAMP to help me learn Craft, and one ...
user avatar
1 vote
1 answer
81 views

Can't get a simple Reverse Relations for Entries field to work

I'm trying to get a simple Reverse Entries working, nothing fancy, but I'm stumped. I created a little personal project just to help me stretch and learn Craft better. I picked the NFL Draft just ...
user avatar
0 votes
1 answer
62 views

Commerce search: return products containing keywords in related entries' fields

Craft CMS 3.6.11.2 / Commerce 3.2.17.4 We have a Stores structure section that contains fields (searchable) such as phone, address, etc. These Stores are assigned as Entries (searchable, max of 1) to ...
user avatar
  • 631
1 vote
1 answer
131 views

Simplifying code using the new andRelatedTo param

I have the following code that works with Sprig. But with the new andRelatedTo param, I am wondering if this could be simplified? However, I am a little unsure if/where to start on this and how the ...
user avatar
  • 1,824
1 vote
1 answer
47 views

Reverse related entry with Solspace Calendar

I'm using Solspace Calendar, When I create an event with it I use a related entry field called 'project' to choose an entry from a section called projects I can display the project title etc in the ...
user avatar
  • 447
1 vote
1 answer
107 views

Order by reverse relationship count

It feels like I’m trying to do the impossible, but I can’t imagine this problem is unique to my project. Hoping someone here has figured it out before! I have two channels, creators and products, and ...
user avatar
1 vote
1 answer
238 views

Element API, query entries where relationship field ':empty:' AND the same relationship field with specified entry ID

Element API, query entries where relationship field ':empty:' AND the same relationship field with specified entry ID. Can't seem to figure out how to do this without performing two separate queries ...
user avatar
  • 117
2 votes
1 answer
83 views

Front End Search Related Entries

I have a front end search which is working fine when searching titles, however when searching for text in rich text fields, or an input field caseNumber or the title of a related entry there are zero ...
user avatar
  • 1,907
1 vote
2 answers
101 views

How to loop through multiple entries fields

I'm creating a dynamic side navigation where pages can choose which sidebar it wants to use. This is selected by an entries field called 'sidebar' - called in line 2. To create this I've made a ...
user avatar
1 vote
0 answers
30 views

Show parents of entry in custom entries field extending BaseRelationField

The default BaseRelationField shows only the name of the selected entry in the field (e.g. "SubEntryX"). I created a custom entries field by extending the BaseRelationField in a module. Now ...
user avatar
  • 11
0 votes
1 answer
57 views

Get entries that aren't related to current user

I am trying to get all the entries that don't related to the current user via a user field. I have used the following code to fetch all the entries that do related to the current user {% set entries ...
user avatar
1 vote
0 answers
28 views

Querying entries that have not been related to any other entry or contained matrix element

I have a large amount of content that we are attempting to collect before we migrate to our new site structures. Normally the staff are supposed to relate content back to main entries to make sure ...
user avatar
1 vote
1 answer
181 views

Localization Section propagation settings, and related entry field setting "Manage relations on a per-site basis"

Craft 3.4.20. Site is running multiple localizations Sections: Blog Post Propagation method set to, "Save entries to all sites enabled for this section" Blog Category (Structure entry with ...
user avatar
  • 117
1 vote
1 answer
48 views

Entries relations with additional fields

I'm searching for a way to have additional fields on relations. The simplest exemple would be; you have stores entries and products entries, and you want to create a many to many relationship with the ...
user avatar
  • 143
1 vote
2 answers
49 views

Display entries which share tags (2 or more)

I need to be able to display entries (within one section) that share keywords. I don't care what the keywords are, just want to display the entries based on 2 or more shared keywords. Anyone know how ...
user avatar
3 votes
1 answer
494 views

In GraphQL how to query entries where related entry has a specific value

Lets have this query: query test { entries(section: "vacancies") { title ... on vacancies_vacancies_Entry { description organisation { title ... on ...
user avatar
  • 545
1 vote
1 answer
38 views

Relationship all to all

I'm trying to pair all my custom product entries to all my dealers with 2 extra fields per product: price per day and price per week. The condition is that all my products are paired to all my dealers ...
user avatar
  • 13
1 vote
1 answer
40 views

Bulk selecting Members and then including them in an email to another specific Member in a different member group

I'm wondering if the following is possible within CraftCMS and suggestions for making it happen? We have two Member groups (Customers and Contractors). When a Customer makes an enquiry they complete ...
user avatar
  • 1,173
0 votes
1 answer
39 views

Multiple Relations Trouble

I'm having trouble setting entries with multiple relations. during testing I've hard coded the theme to 1 specific category {% set themeID = "12309" %} {% set theme = craft.categories.group('...
user avatar
  • 1,907
1 vote
1 answer
241 views

Entry Search Unbearably Slow

Anyone have any tips on speeding up entry searches? Ours are currently taking about 90 seconds per search. Some stats about our Craft database: Entries: 336,000 Relations: 4,390,000 (!!!) Search ...
user avatar
1 vote
1 answer
196 views

Categories or Structures: Most efficient way to organize FAQ sections

Working on a plan for a site that has multiple audiences, with a FAQ section for each audience. FAQ entries are organized by Topic (Finance, Advertising, Publicity) each FAQ entry can be ...
user avatar
1 vote
2 answers
77 views

Sort entries by a related entry (lastName) and then paginate

I have two channels books and authors I need to list all books sorted alphabetically by author. I have this working with the following code: <ul> {# // loop through authors so we can ...
user avatar
  • 1,907
2 votes
2 answers
479 views

Craft 3 version - How to get entries related to current category only (not children)

I need some help with syntax on this for Craft 3, please. I want to use this piece of code: {% set fruitEntries = craft.entries.relatedTo({ relatedTo: catP,id: 'and, not '~str }) %} from this ...
user avatar
1 vote
1 answer
46 views

Grabing data from another channel associated to an entry displayed using category

I have a page that shows a listing of entries (called products) by category. Those product entries have related content (reviews) stored in another channel that are tagged using a relations field. ...
user avatar
1 vote
1 answer
431 views

How do I flush the query cache?

How do I flush Craft's query cache so that I may query a relationship field again in the same web request with a new set of parameters? In this particular scenario, I need to handle it inside of a ...
user avatar
1 vote
4 answers
1k views

With a categories field, how do I query only the *selected* categories?

Suppose we have a category group that allows for any number of levels to its structure. We also have a category field that allows for choosing any number of categories from that group. In our example,...
user avatar
1 vote
0 answers
165 views

Adding Product Variant and Related Product to the cart together on Craft Commerce 2

I want to add a product variant as well as a related product (chosen from a select list) together when the user clicks the add to cart button. I can see you can add multiple products together with ...
user avatar
  • 1,824
1 vote
1 answer
89 views

relatedTo - return only entries that have a related entry where a field in the related entry has a value

Trying to figure out if this is possible in 1 step. I want to return locations that have a related entry in the relatedMerchant field, but I'd also want to make sure that a field in the ...
user avatar
  • 367
2 votes
1 answer
191 views

Getting entries from multiple categories

I have two categories, Annual Reviews and Publications. I want to get all entries from these and paginate them. The code I am using is fine for one category - both work individually, but as soon as ...
user avatar
  • 1,888
1 vote
2 answers
921 views

Related To query

Struggling to get multiple relationship filtering working. So want to filter an entry (people) by one or more of the following: - location (entries) - specialism (categories) - team (categories) For ...
user avatar
  • 1,721
1 vote
1 answer
52 views

How to include a lightswitch for each related entry in the source element of a relationship

I have a Services section in which I keep a related entry field for News. (News by Service) The News items to be displayed for each service are selected in a "News" entries field in the Service entry. ...
user avatar
  • 137
1 vote
0 answers
204 views

Querying a supertable field

I have an entry type called people which has a superTable field called programmeAffiliations, with three fields, jobTitle, researchProgramme, primary where: researchProgramme is a category field (...
user avatar
  • 111
2 votes
0 answers
127 views

What's the most performant way to get reverse related entries within an Element Query?

What's the most performant way to get reverse related entries within an Element Query? Here's a contrived example of this. I have thousands of "book" entries and thousands of "collection" entries. I ...
user avatar
1 vote
1 answer
43 views

Relations and Categories

What's given: Channel: Nutrition Entries Fieldtype: restaurant Category Fieldtype : menu Category: Menu Channel: Menus that also use relations using restaurant field. Each item in the nutrition ...
user avatar
  • 341
1 vote
1 answer
87 views

Need help trying to pass a variable of a related entry

On my page, I have a form which is using Freeform (Solspace). I'm attempting to setup a custom redirect URL for the form. The form will apply to numerous entries in a channel and some will require ...
user avatar
  • 245
1 vote
0 answers
181 views

How do I use a relation field in an element?

Currently I have a field that extends BaseRelationField, and 2 types of elements. I want the field on elements A to be able to select from elements B. So far the field itself works, which I tested by ...
user avatar

1
2 3 4 5
7