Questions tagged [query]
The query tag has no usage guidance.
100
questions
0
votes
0answers
19 views
Filter Entry Query by Category
I'm making a staff page. The entries are in the section 'people'.
There are four types of staff - leadership, wardens, staff, safeguarding - so there is a category field for each 'staffCategory'. That ...
0
votes
0answers
17 views
SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535
{% set entryIds = craft.entries ({
section: 'locations'
}).ids() %}
{% set cities = craft.categories ({
descendantOf: category,
...
1
vote
2answers
27 views
Offset setting a limit?
If have this in a template:
{% for mainLink in section.links.limit(4).all() %}
{% endfor %}
{% for secondaryLink in section.links.offset(4).all() %}
{% endfor %}
Which I thought would show the first ...
0
votes
0answers
18 views
Filter entries in GraphQL
I'm using Craft with Gatsby. I'd like to query a featuredpost, and filter that in my entries.
I'm getting the featuredPost slug in gatsby-node, and passing that to createPage, to send a variable to my ...
0
votes
0answers
20 views
How to write multiple operator condition in where statement of db query
$query = (new Query())
->select([])
->from(['{{%custom_table}}'])
->where(['<=','firstDate', now()])
->all();
In craft3, I want to add multiple ...
0
votes
0answers
27 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 ...
1
vote
1answer
22 views
How can I display just the “lowest” categories assigned to an entry and not parent categories?
I have a category tree like this and I have an entry that has four categories A, A1, B, C2:
A
A1
A2
B
B1
B2
C
C1
C2
I want a query that ignores A and returns only A1, B, C2, because I don't ...
1
vote
1answer
28 views
Mass enable entries
I'm trying to set statuses to enabled in mysql. Around 150k entries.
The tables are elements and elements_sites. Set status to 1.
The query runs OK. In the cp is also everything fine but entries don'...
1
vote
1answer
52 views
Optimising search query
I was wondering if there is a better way to do a query like this, it takes a long time to execute and I know setting the parent variable is where there's a problem but am not sure of an alternative ...
0
votes
0answers
11 views
Sort entry query by their table of values if said values are in a separate array of values
Morning (in the UK at least) - I'm trying to sort/order/filter an entry query by an array of values.
The array is a list of IDs (e.g. [2,7,8]), and inside each entry is a table with a list of IDs that ...
0
votes
0answers
19 views
Front End get category group from uid
I have a form on the front end which has a category field.
I want to display all the options from the category group, by obtaining the categories from the category group.
When i dump the properties ...
0
votes
0answers
21 views
Query Events by Matrix Field using Where clause
I am new to Craft CMS. I am able to get a list off all upcoming events with:
$events = Calendar::getInstance()->events
->getEventQuery(
[
'calendar' => 'sample_calendar',
...
1
vote
1answer
43 views
Advanced Search Filter
I am trying to complete an advanced search query with Smart Map, but I can't seem to quite get it. I tried to merge several URL parameters, and they seem to work fine except when it comes down to ...
0
votes
0answers
78 views
Custom Elements + Joins
I'm having a bit of trouble wrapping my head around an SQL issue with a custom Element.
One column in my Element's table—for the case of this question, let's call it myplugin_things—has a foreign key ...
1
vote
1answer
32 views
Get entries with related to selected categories and then group by category
Background:
I have a listing overview page that lists teaching staff grouped by their department (A category group holds all departments). E.g.
All Staff Members:
-- Science --
Mrs Magnesium
...
1
vote
2answers
31 views
Querying across relationships in a template
I have two Sections on my site: Country and Alert. The Alert section has a relation with Country via an "Entries" field. An Alert represents something that is happening in a particular country for a ...
1
vote
2answers
197 views
How to get previous and next entry using the native GraphQL API?
How do I turn these Craft queries into a GraphQL one?
// entry.twig
entry.getPrev({ section: "contentHub" })
entry.getNext({ section: "contentHub" })
I want to get the previous and next entry using ...
1
vote
1answer
30 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
1answer
38 views
Excluding specific field value from search
I want to find all entries that match the title field where excludeFromSearch != 1 (is false).
{% set query = 'and excludeFromSearch not 1 and ' ~ 'title:"' ~ "myValue" ~ '"' %}
{% set results = ...
1
vote
1answer
118 views
In entries query, is there a way to check if matrix block is used?
I would like to get entries if a matrix field is used. Something like this:
{% set query = craft.entries()
.section('blog')
.search('myMatrixField|length')
.limit(10)
%}
0
votes
0answers
9 views
Output category hierarchy in Element API
I am looking to output categories in a level hierarchical format.
I have multiple categories, with different levels of categories.
Entries can be related to different levels of those categories.
...
2
votes
2answers
170 views
Query entries by custom date field (for a particular year)
So I'm trying to get all entries that have a particular year assigned to a custom date field. (Could be any day/month in that year).
The custom field is startDate and my attempt at a query - which ...
1
vote
1answer
39 views
Find Entries based on Field Values
I have a set of events I want to query based on user-input date times.
How do I achieve something like this?
{% set entries = craft.entries.section('events').minScheduleDate('>=', 'now')....
1
vote
1answer
72 views
User query in PHP does not work
I would like to get user query in my custom PHP plugin.
According to this document, the code would be like this.
https://docs.craftcms.com/v3/dev/element-queries/user-queries.html#example
$...
1
vote
1answer
44 views
Can I query based on a date field rather than the postdate?
I'm passing along a year as the yearQuery variable. Later in my template, I am doing this:
{% set eventEntries = craft.entries
.section('events')
.eventStartDate('>=' ~ yearQuery)
....
1
vote
1answer
44 views
Filter and sort Commerce products based on Matrix blocks
We have a website that uses Craft CMS v3.1.28 and Commerce v2.1.6.1. The below logic is implemented within a plugin and we're prepared to do custom implementations aka. prepared to go deep!
I would ...
1
vote
2answers
47 views
Best practice for year based paging
Is there a best practice for a paging based on the years of entries (instead of page numbers)?
Example:
I have 3 records with post dates 2019-01-01 2018-01-01 and 2016-01-01. So my paging should look ...
1
vote
0answers
61 views
Database Query in debugger consistently showing over 2000ms
In trying to optimize my Craft 3 site, I have discovered that it's apparently taking longer than expected to query my database. The duration for the apparent culprit is typically between 1900 and ...
2
votes
1answer
22 views
Paginate entries ordered by a custom date field
I'm trying to paginate a bunch of events based on their start date. The order part is working correctly, but each consecutive page just loads the exact same entries. My code:
{% set events = craft....
1
vote
0answers
161 views
Advanced queries with Super Table
I have three channels: Events, stages and artists.
An artist is added to a timetable super table field in the stage channel. In the event, I have a stages field where I select stages. Events also ...
1
vote
0answers
62 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
2answers
114 views
Get entries after a certain time
I am trying to get all entries from my events section in Craft 3 that occur after 17:00.
My current code is:
{% set events = craft.entries.section('events').eventStartTime('>= ' ~ '17:00'|time )....
1
vote
0answers
114 views
How to get url from related entry in another site
I'm relating entries from another site in my installation, and I'm having issues getting the correct URL for the entry. This is an example of what I currently have:
{% set carouselEntries = entry....
3
votes
1answer
128 views
How to query entries written in a specific locale? (Craft 3)
In Craft 2 you used to be able to do something like {% set entries = craft.entries.section('something').locale('de') %} but .locale() has been removed and there's nothing similar in the docs that I ...
1
vote
0answers
50 views
Order entries by a matrix field category
I have a lot of trouble in understanding the database/model structure and how to work with the query builder.
I tried playing a bit with leftJoins but i cannot seem to make complex queries in craft 3. ...
1
vote
1answer
119 views
Connect to an external database from a Craft 2.x plugin
I recently saw a very helpful post about how to connect to an external database from a Craft plugin and I wanted to confirm I understood the implementation correctly.
On this response the author ...
2
votes
2answers
382 views
How to include asset fields in query in php?
I am trying to figure out how to return asset field(s) in a PHP entry query. Also if I could learn how to return "custom fields" when returning an Object that would be great too! Right now I am having ...
2
votes
1answer
164 views
exclude array of entry types in query
Here is my query:
{% set resources = craft.entries({
section: 'resources',
type: 'not caseStudyLanding'
relatedTo: filterParams,
orderBy: 'postDate desc'
}) %}
I would like to ...
1
vote
1answer
23 views
Is there a query parameter to get categories that are related to anything else?
I'm looking for a way to query all categories that have at least one relation. I'm not looking for the relatedTo() parameter, which would give me categories related to something specific.
Basically, ...
2
votes
1answer
31 views
How to show entires from past 12 months?
I need to display entries from the past 12 months. I'd like to create an entry query and set the timeframe of the entries I need.
1
vote
1answer
97 views
where command sql query not working
My problem is that I can't update the specific $userId. have the values I've selected. I also get an error:
Call to a member function where() on integer
I just started to learn Craft. It can be ...
2
votes
2answers
67 views
How to get all users with active Commerce 2 subscription
How do I get all the users with an active subscription in Commerce 2? I want to be able to filter entries by subscribed users.
1
vote
3answers
76 views
Returning entries that contain both categories
I'm creating a filter and would like to return entries that must contain multiple categories (and behavior, not or). A sample url would be /events?cat=2,3.
{% set eventCat = craft.request.getParam('...
2
votes
1answer
588 views
How to query entries by field values
I have some entries with a multi-select field called "gallery". We can choose many images to this field.
I have a given image, how can I query entries whose "gallery" contains this given image? Thx!
...
1
vote
1answer
65 views
Payment Method and Discount elements query by ID in Twig
In Craft 2, is it possible to query a specific element by ID in Twig? They aren't mentioned in the docs.
I was trying things like these but without success:
{{ craft.commerce.paymentMethods.id(1)....
2
votes
1answer
160 views
Showing entries for light switch [duplicate]
So I have three light switches on my blog: 'featured', 'required reading' and 'skills'.
I got the featured section to work with this code:
{% for entry in craft.entries
.section(['etiquette', '...
2
votes
1answer
128 views
Where to put where() for a query looking for a lightswitch field
Struggling with syntax here. I'm trying to query entries in the "resources" section, ordered by postDate desc, limit 1 and that also has the lightswitch "featured" as true. Here is what I have.
...
1
vote
1answer
112 views
How do multiple date queries differ between Craft 2 and 3
After spending a lot of time solving this for myself I thought I'd share it.
In my Craft 2 template I had this query:
{% set result = craft.entries({
section: 'events',
eventDate: ['and', '&...
1
vote
2answers
170 views
Where should the .all() be placed in Craft 3
I'm confused, I have ended up with 2 similar queries in a template after converting them from Craft 2.
{% set events = craft.entries()
.section('events')
.eventDate('>' ~ now|date('Y-m-d H:...
1
vote
1answer
133 views
Joining sections (Channel) to query based on a related item attribute
I've been trying this for a while now, so might have read this before. Sorry about that, I'm struggling really hard to get this right. At first I tried (wrongly) with the eager load features.
I have ...
