TOPIC:

addWhere(), oddOrder() 10 Nov 2016 10:05 #14684

organicwebs
Topic Author
Offline
Premium Member
Chris
Posts: 133
Thank you received: 21

Hi Jocelyn,
are these database query overrides still working in forked views? ....

$model->addOrder('a.creation_date');
$model->addWhere('a.published', '1');
$model->setState('list.ordering', 'a.yourfield');
$model->setState('list.direction', 'desc');

Im working in the fork/views/myview/tmpl/default.php and fork/views/myview/tmpl/default_grid.php - trying to modify the collection data with this code - but it is being ignored.

Just call me Chris

Please Log in or Create an account to join the conversation.

addWhere(), oddOrder() 10 Nov 2016 19:42 #14689

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	You can only use those statements BEFORE the getItems() call. So it doesn't work in the template. You need to fork the view. Coding is now a piece of cake The following user(s) said Thank You: organicwebs
	Please Log in or Create an account to join the conversation.