6
The search parameter gives you an entire range of search functionality, as explained in the docs at https://craftcms.com/docs/3.x/searching.html
Using a field handle as a parameter essentially specifies what the value of the field must equates to. How this is determined can vary, based on the field type, but in most cases it will be an exact match.
So in the ...
5
I'm not calling .all(), so this is still an object, right?
Nope. When you execute the for loop, it will explicitly run the database query and return the array of results. You're probably getting a deprecation error logged using that syntax as well since Craft wants you to use {% for album in albums.all() %}
See here in the docs: https://docs.craftcms....
3
Here's how to isolate only your chosen categories. This works off the premise that if a related category is a parent of one of the other related categories, it is not a category you chose.
{% set relatedCategories = entry.myCategoryField.with(['parent']).all() %}
{% set parentCategories = relatedCategories | map(c => c.parent) %}
{% set chosenCategories = ...
3
You need to return the instance in every single set call. As you noticed correctly the last line in every function that changes properties of your query is return $this which allows you to chain another function after the call. Simple as that.
Always return the query until you execute it with all() or another function like that is enough
3
general
The first way creates an object of type EntryQuery, you then call the 2 functions section and limit
In PHP you would do the following:
$query = Entry::find()->section('news')->limit(10);
The second creates an array section => 'news', 'limit' => 10 you then call Yii2::configure($query, $array) with your EntryQuery which does:
public ...
3
I agree that any solution where you run a query and then conditionally render the result isn't very efficient.
You can do this in SQL by using the where() condition.
craft.entries
.section('mySection')
.where('content.field_field1 > content.field_field2')
.all()
Documentation on the where() condition can be found here.
3
There is a related to parameter you can use
Entry::find()
->section($section)
->relatedTo(['targetElement' => $image->id, 'field' => 'galleryImages')
->all();
3
When joining the tables you get more results like you mentioned in Edit2.
First pick distinct ids, to use later on in the main query.
I came up with this:
$timeSlotIds = Entry::find()
->section('activities')
->innerJoin('matrixblocks', 'matrixblocks.ownerId = elements.id AND (SELECT enabled FROM elements WHERE matrixblocks.id = elements.id) = ...
3
You need to join the matrixblocks and the specific content table
$query->join('{{%matrixblocks}}, 'matrixblocks.ownerId = elements.id);
$query->join('{{%matrixcontent_your_table_name}}, 'matrixcontent_your_table_name.elementId = matrixblocks.id);
$query->andWhere([
'>=',
'matrixcontent_your_table_name.name-of-the-column',
new ...
3
You can use the Craft::configure() for that.. imagine your array looks like
$criteria = [
'age' => ['and', '>=30', '<=50'],
'enabled' => false
'status' => null,
]
You can do
$query = User::find();
Craft::configure($query, $criteria);
$users = $query->all();
Or you can just use the parameter based syntax instead of the ...
3
.all() returns a collection of elements, which you can loop through with a for loop.
.one() returns a single element, so you cannot use a for loop to access it.
In this case you should just store the entry like:
{% set entry = craft.entries.section('thing').one() %} and then access {{ entry.title }} afterwards.
(Also keep in mind that entry is ...
3
If I understand properly, you should be able to do this:
$entries = \craft\elements\Entry::find()
->section('yourSection')
->category(['and', 695])
->relatedTo([698,698])->all();
Assuming category is the name of your relational field, you can use that to pass the and condition (though with one element only it wouldn't be needed) then ...
3
Your code looks fine and worked for me when testing locally. However it could be failing due to the fact that you're not url-encoding the parameter before you send the request. If the values contain spaces or other special characters, for example, this would make it fail. To fix that issue, try using encodeURI() like this:
$("#second-choice").load("{{ ...
3
Yep! It's not super well documented, but there's a little information about it down in the Advanced Element Queries section of the docs. It would look something like:
{% set titleList = craft.entries.section('articles').select('title').column() %}
One thing to note, if you're selecting a field value instead of the title, the select parameter will look ...
3
If you are trying to get all people entries related to the event entry itself (what you call event "e") then I would suggest going through matrix as follows.
{% set people = craft.entries.section('people').relatedTo([
'or',
{ targetElement: event, field: 'matrixFieldHandle.relatedEvents' },
{ targetElement: event, field: '...
2
You don't filter a loop but you can attach certain criteria in your ElementQuery. craft.entries returns you an object of type EntryQuery (link to docs). You can search for specific entries based on different criterias by calling magic methods or function in your Query object.
For example: section('docs') will return only entries in the section docs. You can ...
2
If this is a Craft 2 project, unfortunately there's not a super clean way to do that. You'd have to get the last top-level item in the nav you want to show, and add a bunch of conditions in the code to make sure the entry you're outputting isn't after that 5th entry.
{# get the 5th top-level page #}
{% set fifthElement = craft.entries()
.section('...
2
This is down to lacking documentation. Before/after are supposed to take "DateTime|string" as a parameter in the ElementQuery. The format is not documented.
Use "Y-m-d H:i:s"
{% set start = "2 months ago"|date("Y-m-d H:i:s") %}
Behind the scenes in building the query the CMS was replacing any dates I sent through with "2017-12-31 11:00:00" (no idea where ...
2
Yes you can. craft.entries returns an object of type EntryQuery
There is a function matrixBlocks in the CraftVariable that returns an object of type MatrixBlockQuery
Both of them have nearly the same functionality since they extend the ElementQuery
{% set allMatrixBlocks = craft.matrixBlocks.all() %}
2
Not sure about doing this in a single query. Referencing this doc page section, https://docs.craftcms.com/v3/relations.html#templating, you can make use of relatedTo() by passing in IDs.
Assuming you know the ID of the category already and that ID is 1:
{% set showIds = craft.entries.section('shows').relatedTo(1).ids() %}
{% set entries = craft.entries....
2
You need to select the value
{% set user = craft.users
.id(currentUser.id)
.addSelect(['users.unverifiedEmail'])
.one()
%}
{{ user.unverifiedEmail }}
2
Have you tried
.renewalDate('and', ">= #{dateStart}", "< #{dateEnd}")
The difference is the double quotes. I don't think that single quotes support interpolation.
However, I'm not sure in that case why the version without the 'and' works.
OK, have just tried it myself...
I created a section called test and added a single date field called ...
2
Okay, I've been able to solve this and figured I'd share what I discovered. The key for each group is the value of the state so really what I was after here was a key sort and just didn't realize it. So I found Michael Rog's "SuperSort" plugin which has a twig filter for running a ksort and that addressed it perfectly for me making a small adjustment to use ...
2
Haha. I figured it out. Leaving the answer here in case anyone else runs into the same problem:
$product = Entry::find()->section('products')->relatedTo([
'element' => $component,
'field' => 'productComponents'
])->one();
You can pass an object/array to the relatedTo() method as described here:
Relations | Craft 3 Documentation
2
First, I might over complicate things. Maybe there is a simple solution by using:
https://docs.craftcms.com/v3/relations.html#passing-multiple-relation-criteria
But my project has a complex query built in. So I did a custom db query class. And here is one of them might working for you.
If you know how to create a twig function in craft 3 in modules, the ...
2
Craft does not allow for this (as of Craft 3.1.34). When saving selected categories to a Category relationship field, it automatically assigns the parent categories and does nothing to designate which categories were actually selected/clicked/chosen.
2
I figured this while posting so I thought I'd just add it here anyway for others to reference.
To retrieve a Soft Deleted Element using the getElementById method you can pass the fourth argument to the getElementById method and define $criteria setting trashed to true, which will include Soft Deleted items in your results:
$element = Craft::$app->...
2
Was missing the square brackets
{% set groupedEvents = craft.entries(params).eventDate(['and', '>= ' ~ startdate, '<= ' ~ enddate]) | group('eventDate|date("Y-m-d")') %}
2
You can use the revisionOf parameter (docs).
{% set revisions = craft.entries.revisionOf(element.id).all|default(1) %}
2
Ok this was easy. Tried it at first but didn't work and was successful after another go. All it needed was a array of Entry IDs.
Working code:
$entry = Entry::find()->id($entryId)->one();
$entry->textField = 20; // works
$entry->entriesField = [$relatedEntryId1, $relatedEntryId2]; // works
Craft::$app->elements->saveElement($entry);
Only top voted, non community-wiki answers of a minimum length are eligible
