All Questions
3 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
2
answers
158
views
Can you query a grid field to return a list of distinct fields?
EE 3.1.4
I need to get a detail field from a grid field, but I also need the results to be distinct. The issue I have is the grid field returning a pipe delimited field set.
So running something ...
- 1,610
1
vote
0
answers
195
views
Can I use MySQL session variables within a query in my template?
I'm trying to execute a query similar to this:
SET @last_date = NULL;
SELECT
IF(dates.first_entry = 1, DATE_FORMAT(FROM_UNIXTIME(col_id_122), '%W, %M %d'), NULL) start_date,
DATE_FORMAT(...
- 208