Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query-module]

The tag has no usage guidance.

1
vote
1answer
87 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 ...
0
votes
1answer
41 views

Assistance query change membergroup

I am unfamiliair with the Query module and I hope someone here could guide me. In a Template I want to change the group_id of a chosen member (member_id in stash snippet) from 13 to 14. The template ...
1
vote
1answer
55 views

importing entry status via CSV - does uppercase or lowercase status matter

I typically add/edit/delete my entries via CSV (datagrab) and have been doing so for a while now. Recently I'm seeing some confusing things in the way that some of my entries were being ordered and ...
0
votes
3answers
151 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 ...
0
votes
2answers
47 views

Display number of entries of a certain categories in a channel

I would like to display the number of entries of a given category within the same channel, and nothing else. I've found this older question Display the number of entries in a channel but that does ...
1
vote
2answers
95 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 ...
0
votes
2answers
83 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 ...
0
votes
1answer
50 views

Query Module: Error escaping quotes

We recently moved over some of our templates to use the Query module to reduce the number of DB queries happening. However I'm now experiencing an issue where some of the field data is being returned ...
0
votes
1answer
99 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 ...
0
votes
1answer
36 views

Is it possible to send url or form variables o the built-in exp:query tag to build select queries?

Using the supplied EE add-on, is it possible to sen url or form variables or to the builtin exp:query tag to build select queries? If so, can anyone point me to some examples?
0
votes
2answers
143 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 ...
0
votes
2answers
114 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 ...
0
votes
2answers
49 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 ...
0
votes
1answer
66 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
2answers
59 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: ...
0
votes
1answer
52 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....
0
votes
1answer
201 views

parameters in URL for query sorting

I'm using the query module to return entries for a particular page. I would like to create a drop down list where the user can change how the entries on those pages are sorted. is it possible to use ...
0
votes
1answer
130 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" ...
0
votes
1answer
41 views

Help with query syntax

Can somebody help me with the basic construction a Query module query to pull some info out of the Favorites and Tag modules from Solspace? I've tried the following using standard tags but this ...
1
vote
2answers
96 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 ...
0
votes
1answer
126 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 ...
0
votes
1answer
61 views

EE Core alternative to {exp:query}?

I have a website which until yesterday was running EE v1.6.7. Other than occasional defacing due to unpatched security vulnerabilities it was working well enough {/tongue-in-cheek}. Forced by system ...
1
vote
1answer
49 views

Using the query module to get an image path. How do I get to the thumb folder?

First of all. Big thank you to Rob Sanchez. I'm using his plugin inside the query module to get a zoo-visitor member-picture and add it to a public profile page. This is the query. field_id_37 ...
0
votes
1answer
382 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. ...
1
vote
1answer
240 views

Displaying Count of Large Amount of Entries - Best Practice?

we need a 'counter' which displays the total number of entries for a given channel limited by category and status. Were originally doing this via the EE Stats module before the Status/Cats ...
1
vote
1answer
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 ...
6
votes
1answer
292 views

Using exp:query with WHERE = {segment_2} is it safe?

I'm querying the database directly using the exp:query tag and filtering results on the value of a segment, is this safe? How can I make it safe?
0
votes
1answer
51 views

Get categories that contain entries that are in the current category

How can I get a list of categories that share entries with the currently selected category. Huh? Let me explain I have a channel called Portfolio Portfolio channel has two category groups (client ...