[#18361] - [New feature] Filter field months
- Fixed in Code Base
- 17 Mar 2018
- Medium
- Build: staging
- Easy Test
- # 18361
- Diff
- eshiol:filter_field_months
User tests: Successful: Unsuccessful:
Summary of changes
Added a new filter field: Month (published)
Testing Instructions
Create a new Category List page with Filter Field = Month (published)
Expected result
You can filter the articles by month/year (published) in the front-end
in the brackets the number of articles
Actual result
System information (as much as possible)
Additional comments
Documentation Changes Required
joomla-cms-bot
- | Category | ⇒ | Administration com_content Front End Language & Strings Libraries Templates (site) |
| Status | New | ⇒ | Pending |
| Title |
|
||||||
| Labels |
Added:
?
?
|
||
My test show that unpublished articles are counted and their published month appears in the dropdown.
Example:
I guess the query should only return articles which are published or archived.
EDIT: see below: the query is wrong as it should use a.publish_up
Using published means changing the query from a.created to a.publish_up and that should solve the errors I got above.
User with correct rights will get:
Fixed
Looks OK now here.
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18361.
| Easy | No | ⇒ | Yes |
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18361.
| Status | Pending | ⇒ | Ready to Commit |
RTC after two successful tests.
@franz-wohlkoenig please remove RTC cause doesn't work on postgresql
@eshiol
you should use something like
$query->year($db->quoteName('field'))
$query->month($db->quoteName('field'))
instead of
$query->select("concat(year(publish_up),'-',month(publish_up),'-01') as d")
Sure i'll do
On 20 Oct 2017 11:39 am, "infograf768" notifications@github.com wrote:
@alikon https://github.com/alikon please test again as I can't vs
postgresql—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#18361 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AALFsdnhx8tVZ2FkRStMBqzLbSvhcAvZks5suGpsgaJpZM4P9axL
.
still wrong SQL
| Labels |
Added:
?
|
||
I have tested this item
Ok too with mysql
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18361.
mbabker
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-03-17 15:37:38 |
| Closed_By | ⇒ | mbabker |
In the query instead of Month created i think it should be month published
and in the string it should be clarified eg "Month (published)"