Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Coding inside your component
addWhere(), oddOrder()
  • Page:
  • 1

TOPIC:

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

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
  • admin's Avatar
  • Offline
  • Administrator
  • 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.
  • Page:
  • 1
Forum
Support forum
Coding inside your component
addWhere(), oddOrder()
Time to create page: 0.074 seconds
“
”

Really great Joomla tool Cook is a great piece of kit for creating Joomla components. It uses a drag-n-drop interface to build tables and fully featured pages. You can test your component in a sandbox before downloading it packaged up ready to install. The developer is responsive on the support forum.
Twev (JED)
          

Get Started

Log In Sign In