Questions tagged [elementquery]
The elementquery tag has no usage guidance.
73
questions
1
vote
1
answer
39
views
Excluding entries in an entry query with an array of IDs (PHP)
This seems more like a PHP question than a Craft CMS question, but since it's related to an entry query I'm trying to create I figured someone from the Craft community might know. I'm having trouble ...
2
votes
2
answers
63
views
Get children of multiple entries
I'm sure this must be simple but I've tried multiple options with little success. What is the best way to build a query to get the children of more than one entry via an entry field?
For one parent ...
0
votes
0
answers
26
views
Search query by specific section with matrix 'entries' type field?
I need help with the search query. I have a structure:
Page (entryType "structure") -> Matrix (fieldType "matrix") -> Collections ("blockType") -> Collections (...
2
votes
2
answers
117
views
Getting an error on element query after upgrade to craft 4
I've upgraded a project to craft 4, and now I'm getting an error on my entry query.
Below is the code I have:
{% set queryFeaturedEvents = entry.featuredEventsLimited.limit(3) %}
{% set ...
1
vote
1
answer
80
views
Do cache queries work on relation fields and global sets?
I see in the docs I can do something like:
{% set entries = craft.entries
.sectionId(2)
.with(['someRelationField'])
.cache(0)
.all()
%}
and this will cache the query indefinitely because of ...
1
vote
1
answer
120
views
Collections groupBy
This feels like a really dumb one...when I'm grouping a collection, how do I loop over it?
{% set entries = craft.entries().collect() %}
{% set groupBySection = entries.groupBy('section.handle') %}
{% ...
0
votes
1
answer
50
views
Optimise this repeated entry query? (which groups entries by a shared field value)
This loop containing a query is (surprise surprise) proving very intensive.
There is also a second very similar query on the page to get all of the events related to this year and list them by just ...
0
votes
0
answers
32
views
craft query builder and defining custom params on eager-loaded elements
I need to query a radio button field within a supertable field on an element.
I have this but results are empty
$venues = Entry::find()->section('venues')->with([
'areaAndRegions',
...
1
vote
1
answer
109
views
How best to merge an array into an array for a relatedTo query parameter?
I have 3 Matrix fields which define optional parameters for building a query:
A related Entries field
A Categories field
A Tags field
Any combination of them could be used, including none or all.
So ...
0
votes
1
answer
170
views
Sort entries by separate related entries count
I am working on a sprig board that filters out Lessons from a structure in Craft.
This screenshot better illustrates this and how it works.
The main table is built using the following:
{# Sets default ...
2
votes
2
answers
1k
views
Element query for specific fields
Can a return schema be specified for entry queries? I'd only like the titles instead of the whole entry.
1
vote
2
answers
256
views
Cannot pass where Params to query with Twig variable
I have a text field that has three values on new lines.
E01001667
E01001668
E01000779
I want to use these for a query that looks like this:
{% set mylsoas = craft.entries.
section('imdData')
....
1
vote
1
answer
39
views
Why is my relational query returning zero?
I have an entries page structure section
Pages
And two structure sections / menus
Menu A
Menu B
Menu A and Menu B have an entry field link called 'entryLink' that is a relation to an entry in the page ...
1
vote
2
answers
74
views
OrderBy section when selecting multiple sections in entries query
When getting pages from multiple sections like so:
{% set aboutNavigation = craft.entries
.section(['about', 'newsIndex'])
.all() %}
How can I set order that the sections appear?
So I want ...
1
vote
1
answer
107
views
Is there a way to query for structure Entries that have no Parent?
Suppose I have a structure Section with Entries like this:
Parent A
Child X
Parent B
Parent C
Child Y
How would I return this list of Entries?
[Parent A, Parent B, Parent C]
0
votes
1
answer
166
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 ...
1
vote
1
answer
105
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 ...
1
vote
1
answer
69
views
Ordering products using custom field and pagination
I have element query that orders products by custom field which is numeric. Default value of this field is "1".
{% set products = products.relatedTo(category).orderBy('productOrderInCategory'...
3
votes
1
answer
149
views
Efficient way to get all related entries assigned to matrix fields across a set of entries
I have a scenario where level 1 structure entries each have several to tens of level 2 child entries, and several to tens of entries in a different channel which are also allowed to be related to the ...
1
vote
1
answer
103
views
How do you save custom fields on an EntryFixture?
I can't for the life of me figure out how to setup EntryFixtures in craft to populate with custom fields. I'm using the project config which already has the sections and fields defined in my tests. I'...
1
vote
1
answer
107
views
Commerce element query on custom field in console command
I'm on Craft 3.4.30 (latest 3.4) and Commerce 2.2.25 (latest 2.2):
My product type "ticket" has a custom date field with handle productStartDate.
E.g. the following query in TWIG works:
{% ...
2
votes
1
answer
2k
views
Advanced Element Queries - example uses
In Craft docs element queries article, there is section "advanced element queries", with methods like where, groupBy etc.
What are example use cases of these methods in Twig templates or PHP ...
4
votes
1
answer
248
views
Element query - using "search" vs using field handle as query method
With element queries, we can search for elements using search method:
craft.entries.search('someField:something')
or by using field handle as method:
craft.entries.someField('something')
How these ...
1
vote
1
answer
537
views
Custom Module: new element type index page access
Hello I've created a new element type in a module (a web app within Craft) that I'm developing.
I have initially created my models to be craft\db\ActiveRecord and save directly to their tables, but ...
1
vote
1
answer
137
views
Is there a way to query for a list of values belonging to a specific field in a queryset?
For instance, if I wanted an array of all the titles belonging to a subset of entries that I wish to query. The way I know how to do this currently is like so:
{% set titleList = [] %}
{% ...
1
vote
1
answer
52
views
Check what methods were used on element query
I am creating plugin that provides helper methods for constructing search forms, filtering entry lists
by various params etc. And for that plugin, I need to be able to tell which methods were alredy ...
1
vote
2
answers
51
views
Matrix fields don't load!
I have some matrix fields defined:
But when I use the matrix blocks inside of an entry - I don't get all blocks - just the richText ones.
I tested it out - just the richtText Matrix blocks will be ...
1
vote
0
answers
56
views
Freeform: query form object for presence of field type (or other criterion)
I want to be able to check if a form object returned by a query has fields of a certain scope before I generate its markup.
I have a test case where I want to know if a form has a checkbox field type ...
2
votes
1
answer
246
views
How do you eager load or join reverse relationships for entries?
So I have structures that are related in the follwing way:
Locations has many Providers
Providers has many Health Topics
I know that I can eager load all Locations with related Providers and Health ...
2
votes
1
answer
1k
views
Dynamically populating select input fields using jquery $.load and twig template
EDIT: the below code now works!
I have two select inputs, the choice of 1 should populate the second. I have an external twig file (data.twig) (MAKE SURE TO PUT THIS IN YOUR TEMPLATES FOLDER) that ...
1
vote
1
answer
32
views
How to exclude multiple email addresses from an order query
When doing an order query I want to omit results for 2 particular email addresses.
It's easy enough to omit results for one address;
$order = Order::find()
->isCompleted(true)
->email('...
2
votes
2
answers
128
views
Combine AND and OR in a ElementQuery
I have a category with 2 levels. And I want to be able to let the user do a search based on those. The problem is that it needs to be AND between all level 1 categories, and OR within child categories....
3
votes
2
answers
1k
views
Craft 3 plugin - how to update entry with field of Entries type
Using PHP, I want to update a field of Entries type of an existing entry.
Fields of type Text and Number will update with the following code:
$entry = Entry::find()->id($entryId)->one();
$...
1
vote
2
answers
159
views
Simple user query with orderBy not working
Craft 3.3.13
This query does not order users correctly.
{% set users = craft.users.groupId(3).orderBy('lastName asc') %}
Bug?
2
votes
1
answer
889
views
.first() vs. .one() in craft 3
I'm confused about the new .one() argument in craft 3
If I want to grab all entries I write:
{% for entry in craft.entries.section('thing').all() %}
{{ entry.title }}
{% endfor %}
Alls is nice ...
0
votes
1
answer
88
views
getVersionsByEntryId is deprecated. Can't find the new method?
We are using getVersionsByEntryId in our XML sitemap to return the number of times an entry has been saved, then comparing that with todays date and the date the entry was created to determine the ...
1
vote
1
answer
234
views
Creating and saving a GlobalSet element type in Craft 3
The following code is in a migration. It runs fine and there are no errors and prints SAVED, but nothing is saved in the globalsets database table.
All my other content migrations run fine so it is ...
1
vote
1
answer
155
views
Element API: How to get entries up to a certain page?
I have a query that is pulling entries from a structure with
elementsPerPage' => 3
If my pagination looks like this:
Page 1:
Entries: A, B, C
Page 2:
Entries: D, E, F
Page 3:
Entries: G, H, I
...
1
vote
1
answer
41
views
Array from matrix fields without quotations
I am trying to create an array bodyBlocks by looping through all of my matrix fields called blockTextContent:
$bodyBlocks = [];
foreach ($entry->getFieldValue('pageBuilder')->all() as $block){
...
1
vote
1
answer
663
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
1
answer
405
views
What is the appropriate way to query and Hard Delete existing Soft Deleted Elements for a Custom Element?
I have a Custom Element where the Soft Delete functionality is not necessary. Right now, existing users of this plugin may have thousands of Soft Deleted Elements in their Elements table that don't ...
1
vote
0
answers
259
views
Advanced queries with assets and other custom fields
To optimize performance, I'm trying to create an advanced entry query that selects only specific variables. I can set up the query to grab the entry title, uri, and a custom variable I created ("email"...
1
vote
4
answers
2k
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,...
0
votes
1
answer
338
views
How do I fetch all categories under a category group using the Element API?
I am not too familiar with PHP and am just learning the Element API.
How do I turn this craft query into an element api query?
craft.categories.group("brands").level(1).all(),
In categories this is ...
2
votes
2
answers
1k
views
Entry Query relatedTo Two Categories
This has to be something that is easy, but I've been beating my head on my desk for a a few hours with this. Most solutions I have come across are way to complex - when all I need to do is query a ...
1
vote
1
answer
120
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 ...
1
vote
1
answer
238
views
How to support chained Element queries with Twig tags
The craft variable allows you to chain queries for your Elements. For example, you can query the first Entry in a section with either of the following syntaxes:
{% set entry = craft.entries({ section:...
2
votes
0
answers
153
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 ...
3
votes
1
answer
160
views
relatedTo() only on one field?
I have a Product entry type that contains a field for Components (which are also products) and a field for Related Products (again, also Products). I want to be able to find a parent product from a ...
0
votes
0
answers
94
views
How to add an Element sortOption to sort by number?
I have an Element. It's a Structure, with one level (not sure if that is relevant). I'd like to add a Sort Option that allows a user to sort the Element Index page for this Element by a number. The ...