The query-module tag has no usage guidance.
0
votes
1answer
10 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, ...
0
votes
1answer
16 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
54 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
22 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
38 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
47 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
35 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
29 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
128 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
124 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
22 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
141 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
39 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 ...
