Skip to main content
Share Your Experience: Take the 2024 Developer Survey
4 votes
Accepted

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

While firing a query in DB, No matter you pass "Open" or "open". Both are same. Your first question's answer is: As per EE Standards, It should be "open". EE save "open/closed" in database, it shows ...
Mufi - Amici Infotech's user avatar
3 votes
Accepted

How to use an SQL query to display entries from last 45 days

You can try below query to display entries of last 45 Days. SELECT DISTINCT field_id_19 AS HomeTitle FROM exp_channel_data t1 INNER JOIN exp_channel_titles t2 ON t1.entry_id = t2.entry_id WHERE t1....
Harsh Barach's user avatar
1 vote
Accepted

Add new Channel ID access to multiple member groups via SQL Query

If you have access to a SQL Utility like Sequel Pro and a code editor it is pretty easy to do. First you need to get a list of the groups that don't have the channel_id set. Using the SQL Query tab ...
JCOGS Design's user avatar
  • 3,585
1 vote
Accepted

SQL Query to Get count of entries of a certain status inside channel

So... I finally got it working, though not with SQL which I imagine is more efficient. Behold my mess. Note this is only because I'm having to nest it, and also match to url_title because of how we ...
Chris O'Connor's user avatar
1 vote

SQL Query to Get count of entries of a certain status inside channel

It might work out easier to turn this into a short plugin, but would a query like this work? You'd need to pass in the id of the channel you're looking for. {exp:query sql="SELECT count(*) AS ...
Michael McGhee's user avatar
1 vote
Accepted

Display number of entries of a certain categories in a channel

Maybe something like {exp:channel:entries channel="my_channel" category="2" dynamic="no"} {absolute_results} {/exp:channel:entries}
Jelle Dijkstra's user avatar
1 vote

Removing duplicate entries using an SQL query

I've now solved this one by using an SQL Query as follows: <select id="locationList" name="fieldName"> <option value="">All Locations</option> {exp:query sql=' ...
Tom Perkins's user avatar
1 vote

Removing duplicate entries using an SQL query

I would have solved that with storing everything in a exp:stash:set_list, and then looping out it with a exp:stash:get_list. Read more on how to do that here: https://github.com/croxton/Stash/wiki/%...
Pontus Madsen's user avatar
1 vote

Low Search and match 3 fields and then return data

Looking at your example code, you've got several filter parameters in your Form tag. And as stated: these parameters can be applied in two ways: as input fields in a Form, or as hard-coded ...
Low's user avatar
  • 11.3k
1 vote

Can you query a grid field to return a list of distinct fields?

I preface the answer by saying that I do not recommend using SQL to get at your entry data this way, as it's what the Channel Entries tag and field variables are designed to do for you. That said, ...
Derek Jones's user avatar
  • 2,255

Only top scored, non community-wiki answers of a minimum length are eligible