Discussion Forum

rnelson72

Member

Registered: March 14, 2016

Posts: 3

order by

I created two related modules. Can in the main view the query include an order by field? Can is be added in the class file?

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 974

Re: order by

Generally if you want to order by a field in a second table you'll want to use a Grouped List view. Other than that I'd probably need more specifics about what you're trying to accomplish.

rnelson72

Member

Registered: March 14, 2016

Posts: 3

Re: order by

the tables are venues and concerts.  I want to order the result in maini view of each. in venues order by venue_name ASC. and in concerts by datetime DESC.
How or what can I edit to do this? Or would I have to start over, building the module?

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 974

Re: order by

- Edit the view
- Click the icon next to the view type dropdown to open the view options
- Change the "Sort By" dropdown to the right column and direction

rnelson72

Member

Registered: March 14, 2016

Posts: 3

Re: order by

Thank you for your help.