All Questions
Tagged with query relationships
7 questions
0
votes
0
answers
64
views
How to use {exp:query} results in {exp:channel} parameter?
Since i can not retrieve {parents} from grid field, i am trying to find simplest workaround.
This works great:
{exp:channel:entries channel='channel-one' entry_id='
<?php
$...
- 11
0
votes
1
answer
140
views
Querying for a relationship field
I am building a web portal to display a list of servers and their designated applications in an HTML table. The channel I am using for the parent is called 'servers'. Inside this channel, I have a ...
- 5
0
votes
1
answer
120
views
query : how to get the value of a custom field within a relationship field?
I have a channel 1 and a channel 2.
In channel 1 I have a relationship field that relate to channel 2.
I want (by making a query, for reasons I won't explain here because this is not important) to ...
- 43
1
vote
0
answers
104
views
Slow queries from ExpressionEngine
I need help with the following query. I'm not sure where it comes from in ExpressionEngine. Any insight or pointers would be helpful.
SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`...
- 11
1
vote
2
answers
127
views
Create a list of entries where parents status is open
I have 2 channels, artists and artwork.
I want to display the artwork entries where their parent entry, in the artists channel, has the status set to 'open'.
I would like to show all the fields from ...
- 320
0
votes
0
answers
91
views
Show entries where relationship field equals Yes with the Query
I have 2 channels, one called artists and another called gallery.
In the artists channel there is a checkbox to say if the artist has given permission for their work to be shown.
In the gallery ...
- 320
1
vote
1
answer
230
views
Limiting results returned by nested playa parents tags
I'm hoping someone can give me a pointer on narrowing my returned entries on the basis of nested playa parent relationships. Here's the scoop:
I have a 4 inter-related channels: companies, people, ...
- 3,730