Feeling Lucky
?
[#15835] - [com_fields] order article list or blog by custom calendar field
- Closed
- 19 May 2017
- Medium
- Build: 3.7.0
- # 15835
Steps to reproduce the issue
- just not possible today
Expected result
- if custom field is calendar field this should be used as order field for blog list
Actual result
- custom caldendarf field not availiable to select from menu
System information (as much as possible)
- Joomla 3.7.0
Additional comments
- other solution could be to add "unpublish" oder "publish_down" as order-field
joomla-cms-bot
- 
dietze6
- comment
- 5 May 2017
maybe it is possible to implement this to root/components/com_content/category/blog.xml around line 270 ?
<field
name="order_date"
type="list"
description="JGLOBAL_ORDERING_DATE_DESC"
label="JGLOBAL_ORDERING_DATE_LABEL"
>
<option value="">JGLOBAL_USE_GLOBAL</option>
<option value="created">JGLOBAL_CREATED</option>
<option value="modified">JGLOBAL_MODIFIED</option>
<option value="published">JPUBLISHED</option>
<option value="unpublished">JUNPUBLISHED</option>
</field>
and then add in root/components/com_content/helpers/query.php around line 170 this
case 'unpublished' :
$queryDate = ' CASE WHEN a.publish_down = ' . $db->quote($db->getNullDate()) . ' THEN a.created ELSE a.publish_down END ';
break;
i think in J3.5 this used to work now it doesnt anymore
Maybe i am wrong posting this here?
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15835.
Bakual
- comment
- 5 May 2017
@brianteeman It's what he wrote under "Additional comments".
@dietze6 It's probably better to open a new issue for that request since you asked two different things in this issue.
franz-wohlkoenig
- | Status | New | ⇒ | Discussion |
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-05-19 17:32:12 |
| Closed_By | ⇒ | brianteeman |
custom fields can't be used to order or filter lists. If you need that, you have to use a full CCK.