Questions tagged [relations]
Questions around Craft's relational field types.
307
questions
0
votes
1answer
21 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 ...
0
votes
0answers
28 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 ...
1
vote
1answer
21 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 ...
1
vote
1answer
39 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 ...
1
vote
1answer
93 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 ...
2
votes
1answer
48 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 ...
0
votes
0answers
23 views
Load category values based on another category field
I'm really new to Craft CMS,
I have a site where I need to do something like this:
There are 2 categories, Brand and Model (Models have a relation to Brands via category field).
In entries I have 2 ...
0
votes
0answers
17 views
Problem with entry relations in using craft + postgres
I have a custom module saving entries into the system and those entries contains several category relationships. I have done the same previously with MySql and never had problems.
I am currently ...
0
votes
0answers
8 views
How to pass extra filters to products field type?
We are adding a 'Featured products' field to a category fields config and we're looking to filter the list of products that are selectable by the category this field is appearing in.
For example, if ...
0
votes
0answers
35 views
Total count of entries related to entry from another section (structure), including all levels within that section
I have two sections: Products (channel) and Accessories (structure).
The Accessories section is a structure and can multiple levels to it, a Product may relate to a child (level 2) but not it's parent ...
1
vote
2answers
53 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 ...
1
vote
0answers
20 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 ...
0
votes
1answer
38 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 ...
0
votes
0answers
27 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 ...
1
vote
1answer
117 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 ...
1
vote
1answer
25 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 ...
1
vote
2answers
44 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 ...
1
vote
0answers
238 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 ...
1
vote
1answer
36 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 ...
1
vote
1answer
21 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 ...
0
votes
1answer
34 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('...
1
vote
1answer
102 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 ...
1
vote
1answer
116 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 ...
1
vote
2answers
53 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 ...
2
votes
2answers
352 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 ...
1
vote
1answer
43 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.
...
1
vote
1answer
215 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 ...
1
vote
4answers
760 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,...
1
vote
0answers
90 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 ...
1
vote
1answer
78 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 ...
2
votes
1answer
104 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 ...
1
vote
2answers
505 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 ...
1
vote
1answer
44 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. ...
1
vote
0answers
139 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 (...
1
vote
0answers
90 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 ...
1
vote
1answer
41 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 ...
1
vote
1answer
78 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 ...
1
vote
0answers
139 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 ...
1
vote
1answer
87 views
RelatedTo relation - checking matrix block status is enabled
I need to search for all commerce variants related to a custom element "Account".
The account element is related to a variant through a matrix field with handle
varientaccountmapping, block handle ...
1
vote
1answer
42 views
Relationship between channels/entries
I need some help. Really struggle understanding how to build relationships between channels/entries.
Context/Want:
I have two separate channels:
1. "Plant catalogue"
2. "Plant care"
I want to re-use ...
1
vote
1answer
68 views
Get entries related to same category
I have a channel (handle: "infopages") with entries.
I have a channel (handle: "products") with entries.
I have a category (handle: "productTypes")
Every entry from "infopages" has a category field, ...
1
vote
1answer
132 views
order by Table Number Field
% set entriesList = craft.entries.section('parks').relatedTo(entry.Line.one()).all %}
{% if entriesList|length %}
<div id="found-in" class="park">
<ul>
{% for ...
0
votes
1answer
68 views
Displaying related image assets from another section with twig
I have a site that shows upcoming football matches in a table, and I would like to include the clubs' logos next to each club name.
I have the following sections and entry types, both generated using ...
2
votes
1answer
54 views
Relation fallback if no category has been selected
I have a filter with a few different parameters that get pulled in and I was wondering if there was a relatedTo wildcard that I could use.
Here's the relevant code:
{% set function = craft.app....
3
votes
1answer
2k views
Craft 3 - Save new Entry with Relations (Categories/Assets)
i simply can not get my "job" done. I try to create a plugin for Craft, a simple one. It reads some date and should create new entries out of this data. First i stuck on a stupid save-mistake, someone ...
1
vote
1answer
70 views
Filter entries by other entry
There's a section called locations and another called vacancies. In vacancies the admin can assign a location entry to a vacancy.
On the careers overview page we want to display selected vacancies ...
3
votes
0answers
521 views
Searching for Multiple Categories and Tags
I've been pulling my head for the past day on how to filter products with multiple categories.
After a long search, I found and implemented on my project, Advanced Search with tags and categories
It ...
1
vote
0answers
14 views
How can I use a double relation to include the currentUser as criteria?
I have a front-end form that allows registered users to edit content. In this case, it is a podcast. I have multiple podcasts that blog to different providers.
Here is how I am selecting the provider ...
1
vote
1answer
44 views
How can I make related entries and globals part of the search considerations?
How can I make related entries and globals part of the search considerations?
So I have a website search bar that searches the whole website.
Within some jobs pages there are some global elements ...
0
votes
0answers
72 views
Indirect Relationship defined in Matrix Block
I have 3 channels: Reviews, Products and UseCases.
In the section "Reviews" an entry has a list of "Products", based on a matrix field. Every block in this matrix field represents one listed "Product"...
