All Questions
Tagged with query query-module
18 questions
0
votes
1
answer
77
views
Add new Channel ID access to multiple member groups via SQL Query
I have created a new channel (in this case ID#32) on an existing EE site install, and I need to assign it to 270 existing member groups.
Rather than clicking into every single member group and ...
- 81
0
votes
1
answer
41
views
Get average rating from a Super Search results set
I have a series of super search results listing pages displaying lists that are all rated with the Ratings module.
I want to get the average rating of all the entries in the list to put into schema ...
- 2,048
1
vote
1
answer
127
views
How to use an SQL query to display entries from last 45 days
I'm using the following SQL query to populate a filter form for a jobs site. The query displays all locations used in the jobs listed on the site.
I'm only displaying jobs up to 45 days old on the ...
- 511
0
votes
3
answers
237
views
SQL Query to Get count of entries of a certain status inside channel
Right now I have this inside of a channel entries tag.
{exp:query sql="SELECT total_entries FROM exp_channels WHERE channel_name = '{url_title}'"}
{total_entries}
{/exp:query}
Which provides me ...
1
vote
2
answers
132
views
Removing duplicate entries using an SQL query
I'm trying to create a search field (using Solspace Super Search) using a location from existing channel entries. Unfortunately this results in duplicate locations as some entries use the same ...
- 511
0
votes
2
answers
134
views
Low Search and match 3 fields and then return data
I'm looking for a bit of guidance here, just need pointing in the right direction for. A solid solution.
Would this be possible with ExpressionEngine? Either using something like Low Search or even ...
- 317
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
0
votes
2
answers
184
views
Need help with a query to get data
I need a complex query and have gone beyond my scope of understanding.
Here is the gist...
There is a section of the site in which users can select various values available in entries of a ...
- 1,610
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
0
votes
2
answers
65
views
Create list of authors, but no repetion (LOW search)
We have build a site where members publish images in entrees which are tagged ( one or more tags). By using Profile:edit there also exists a channel with Member_data like name and adress. The ...
- 376
0
votes
1
answer
77
views
Query exp_channel_data but exclude expired entries
I'm on EE2.10.1, and trying to grab unique countries from a channel that has one field for "country name" and one field for "country code". So I've got the following query:
{exp:query sql="SELECT ...
1
vote
2
answers
78
views
Playa related entries count
We are running reports and need a query - we're using playa and I want to get the total number of child_entries where channel_id = 16 and where the 'parent_field_id' = 68.
My current query is:
...
- 295
0
votes
1
answer
55
views
Total entry views for all entries in a given category
We have a basic query, which get us; cat_id, parent_id, cat_name and the total entry_count which is then displayed in the form of a report... the current query is:
SELECT c.cat_id, c.parent_id, c....
- 295
0
votes
1
answer
155
views
SQL query issue while trying to count the entry (row)
Trying to produce a current entry count / total entries within a channel_entry tag by using a SQL query.
{exp:channel:entries
channel="{channel}"
limit="1"
require_entry="yes"
status="open"
...
- 301
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
1
answer
147
views
Custom query ignoring sticky entries
I'm using the query module, to return a list of entries sorted alphabetically, but there are a few sticky entries that I need to appear at the top of the list, and the stickies are being ignored.Here ...
- 263
0
votes
1
answer
2k
views
Displaying Category Name and Channel Entry Data with Query Module
I have a SQL query set-up to display a list of entries based on the category ID found in the third segment, but I'm having a hell of a time trying to display the category name that goes along with it. ...
- 385
1
vote
1
answer
27
views
can you show screen_name of users who have liked an entry?
Channel Ratings: 4.0.4, EE: 2.7.3
I am using the channel ratings "Like" function, so the logged in users can "Like" certain products. I want to be able to display who has liked an entry. I am using ...
- 413