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

Mass-change entries from one status to another

SQL is the best option to bulk update the entries. But you must need to be careful as wrong execution can stress you up! You can use below query: UPDATE exp_channel_titles SET status = 'created' ...
Jainil's user avatar
  • 626
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

How to give categories open/closed status?

Custom category field? Which defaults to open: Then your template code: {exp:gwcode_categories channel="example" depth="1" custom_fields="yes" linear="yes"} {if cat_status == "Open"}{cat_name}{/...
Peter Lewis's user avatar
  • 5,353

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