Questions tagged [query]
The query tag has no usage guidance.
139
questions
0
votes
1
answer
16
views
Get entries where tag = value
Let's say I have a tag group with handle genre.
I can make an entry contain information about this tag by creating a field of type tag that uses this group.
So I would have a field with handle ...
- 305
0
votes
0
answers
32
views
Craft cms with graphql How to make reverse query(In terms of relation)
entries(limit: 50, section: "branches", orderBy: "dateUpdated") {
id
branchTitle: title
... on branches_standard_Entry {
branchAddress: map
bank: ...
1
vote
1
answer
21
views
Entry query on field using the `and` parameter
I'm struggling to get a and entry query to work - it seems to be stuck on or.
Query is {% set blogQ = blogQ.blogTags(['and', blogTag|join(",")]) %} where blogTag is [2291,2290] in this case. ...
- 107
1
vote
0
answers
18
views
Craft 2 White Screen - All Queries Not Running
I have a CraftCMS 2 template with a JavaScript setTimeout for auto refresh, and quite randomly, the page will only display a white page.
Dev mode is enabled, and, through the browser's inspector, in ...
- 380
0
votes
0
answers
64
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 ...
- 123
1
vote
1
answer
149
views
Get entries with a specific post date
I'm having absolute brain fog right now.
I'm trying to show a list of entries with a given postDate
{% set startDate = startDate ?? now|date('Y-m-d') %}
craft.entries
.section(['jobs', '...
- 1,793
1
vote
1
answer
43
views
Returning Metadata Fields with GraphQL?
I'm trying to pull as much information from the CMS as possible via the GraphQL API. I can't seem to find any info about how to extract the metadata information for the various entries in the CMS.
At ...
- 21
2
votes
1
answer
71
views
How to get column name of an entrie's field
I want to query some entries in a section.
I am able to write a query using a GET Param as a filter on the title field.
If I want to query a custom field however I need to know the precise column ...
- 43
2
votes
2
answers
295
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.
- 387
0
votes
0
answers
234
views
Maximum Response Size in GraphQL API?
hoping someone can point me in the right direction here.
I'm trying to query my client's API with the Graphiql interface. My use case requires me to extract quite a lot of data from their system but ...
- 21
0
votes
0
answers
65
views
Runtime Object type "Element" is not a possible type for "MyGraphqlInterface" for custom gql resolver/interface
So, I'm probably taking the wrong approach here, but I am attempting to write a custom graphQL query interface, resolver, DB and graphQL query classes in order to return values from a custom Plugin ...
- 123
1
vote
2
answers
74
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,900
1
vote
1
answer
72
views
How do I get custom fields of User on graphQL?
I am wanting to fetch queries for custom fields of users, how would I go about doing that?
So if I did something like this:
query {
users {
id
firstName
lastName
email
photo {
...
1
vote
1
answer
36
views
Exclude 2 entries from a query
I know this question has been asked before but I'm still not able to solve the issue in this particular situation.
I want to remove one fixed(#95) entry id and the current entry.id from the query.
{% ...
- 401
1
vote
1
answer
23
views
Events with Speaker: Categories or Channel
Sorry for this general question, i am building a large archive site with many (>1000) Events. Every Event has one or more Speaker. At the moment I am using two channels: "events" and &...
- 165
0
votes
0
answers
174
views
Graphql: How to get all entries and all related entries
I am really new to graphql and the jamstack-thing but i was wondering how is it possible to query all "Events" with all related "Speaker"?
Events and Speaker are two sections.
In ...
- 165
1
vote
1
answer
40
views
Find First Entry That Matches Current Category
I need help. I am creating a category listing which I have working great. The next step is where I'm struggling a bit as I can't seem to query the related entries on a loop basis.
For each "...
- 45
1
vote
2
answers
111
views
Split a list of entries in two parts
How do I split a list of 10 entries into two parts - one part with 4 entries, followed by an image section, and then the second part with 6 entries.
Thanks for your help. markus
- 31
3
votes
1
answer
38
views
Using 'or' within query parameters
I have an entry which shows related events, based on the entry category, at the bottom. These events all have a start date and an end date - the end date is required, if the event is only one day, ...
- 45
1
vote
1
answer
56
views
Remove duplicate text from query results
I have written a query to select all categories for a certain entry. In this case, the category is called "Key Stage" and each one is written "Key Stage 1", "Key Stage 2" ...
- 45
4
votes
3
answers
587
views
Get array of titles instead of whole collection of entries' attributes
I know that to get the entries I can do:
craft.entries.all()
but instead of getting the whole collection of entries, I would like to get an array of titles from those entries (or any other field).
...
- 127
1
vote
2
answers
191
views
Pass parameters to element query as array - in PHP
In Twig, we can do this like this:
craft.entries({
id: 11,
relatedTo: 22,
})
But in PHP code, this does not work:
\craft\elements\Entry::find(
[
'id' => 11,
...
- 1,197
0
votes
1
answer
73
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 ...
- 6,925
1
vote
0
answers
58
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 ...
- 6,925
1
vote
1
answer
51
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 ...
- 6,925
0
votes
0
answers
66
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: ...
1
vote
0
answers
42
views
GraphQL API query to load all related data
How to write a query to load entries with its category or any other related data.
For example I have cars that related to the BMW category.
How I can access the category data in the query that fetch ...
2
votes
1
answer
213
views
'and' & 'or' in the same entry query
I've been attempting to create an entry query that queries the same custom field twice.
Basically I want to check if a custom field is between 2 numbers OR if it is empty.
Currently I'm using this to ...
- 73
1
vote
1
answer
111
views
Query Entry where number field is conditional to value
I am trying to get entries where a specific number field is bigger than the given value.
But Craft is giving me the following response:
Am i missing something or is this not supported for number ...
- 369
1
vote
1
answer
235
views
Entry query returns all fields with NULL
When trying to query a specific single entry in a section I get back a result but all the fields inside that result are nulled.
This
{% set kundenmeinungen = craft.entries.section('unterseiten').slug('...
- 23
1
vote
1
answer
349
views
Element API: Get Entries Related to Category with Query Parameter
I'm using the Element API Plugin to create an API, with which I want to get entries related to one category, but dynamically with the category set in the Url.
What I have so far in the config/element-...
- 215
2
votes
1
answer
20
views
Search Filters Results Unexpectedly
This question is related to: SuperTable Returning Unexpected Results w/ Template, which is still unresolved.
In essence, Im trying to return the results of a Supertable at two different points in my ...
2
votes
1
answer
101
views
How to structure data: Solo Events (Lectures) and Group of Events (Conferences)
I am working on my first craft project and am wondering how to create the following data structure:
I have a page with a large archive of solo-events (lectures, discussions etc). I think I will use a ...
- 165
1
vote
1
answer
347
views
Sprig - Filter entries by custom field checkbox values, separate values as well as all values
I am having a question regarding Sprig.
I do want to filter my entries for values that are defined in a dropdown field (example below is simplified).
It does work to the point where I want to filter ...
- 1,064
2
votes
1
answer
26
views
Query entries posted in the past month
I’m trying to show only entries for the created in the last month. I’ve taken this from the example in the docs but it ends up showing nothing. There’s 100% entries with a postDate in the last month.
...
- 347
0
votes
0
answers
32
views
Hiding enclosing div if all matrix block fields are empty (although they do exist because of another language)
I have an entry with matrix fields. If I add blocks in the main language, but its fields only contain data in one language, the block query (the for loop) still finds these empty fields since they do ...
- 98
1
vote
1
answer
176
views
Multiple relatedTo conditions using a combination of "and" and "or"
We're trying to make a filter that allows you to pick multiple items from 1 category, and multiple items from another category and return back all appropriate elements.
We're in PHP land not twig so ...
- 129
1
vote
1
answer
335
views
Craft 3 - Twig search query for entry with custom EntriesField containing disabled entry
I have a search form with 1 simple input (q)
I also have 2 sections: SECTION-A & SECTION-B
The search is for entries within SECTION A.
The entry I'm searching for contains a custom entriesField ...
- 160
1
vote
1
answer
14
views
Order entries by DATEDIFF
I'm trying to order the results of an entries query by the difference between two date fields but I can't seem to get it to work.
Here is my query:
{% set todaysStreamsParams = {
section : 'films',
...
1
vote
1
answer
83
views
Eager load commerce order data in custom ElementExporter for Users
I have a custom ElementExporter for users and I'd like to include commerce order data. The below code works, but it's a ton of queries. I don't have a ton of experience with SQL queries, how can this ...
- 2,985
1
vote
1
answer
26
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 = [] %}
{% ...
- 283
1
vote
1
answer
4k
views
GraphQL query entries by DateTime field between two dates
I am trying to query entries in GraphQL by custom DateTime field value.
It works with the base String value like ">=2020-10-01",
However querying between two dates like "['and', '>...
1
vote
1
answer
62
views
Query entries with latest video field containing a URL
I would like to set up a query to find the latest news article that has a video attached to it ('video' is a matrix field with a block type that is also called 'video' and a field called 'videoUrl').
...
- 98
1
vote
2
answers
153
views
Order entries by multiple matrix date field
I have a section with trainings. In each training entry there's a matrix field where we add a new block with a training date, location, etc. So each training has multiple matrix blocks.
When I run an ...
- 125
1
vote
1
answer
52
views
Problem with SUM on Matrix blocks
I have some Matrix blocks where I need to sum one of the fields within, but I only want to sum it when another field within that block is or is not empty.
{% set reimbursementAmount = craft....
- 608
0
votes
1
answer
48
views
Query only Tags wich are not connected to a revision
I wrote a query like this:
$query = (new Query())
->select('COUNT(elements.id) as count, tags.*')
->from('relations')
->join('INNER JOIN', 'tags', '{{relations}}....
- 235
1
vote
1
answer
182
views
Comparing matrix blocks by type and field value
I’m trying to do something, the answer to which should be as simple as searching a Matrix field value but that’s not working for reasons I can’t fathom.
Setup
I have a Matrix field called programme.
...
1
vote
2
answers
211
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 ...
- 509
1
vote
0
answers
261
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 ...
- 111
2
votes
1
answer
151
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 ...
- 83