hi all
i created a table view in my site

now if i add a sort criteria the view work fine but i can't sort the table with others columns

if i don't add a sort criteria i receive a mysql error

user warning: Unknown column 'node_data_field_data_inizio_field_data_inizio_value' in 'order clause' query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_sede.field_sede_value AS node_data_field_sede_field_sede_value FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN term_node term_node2 ON node.nid = term_node2.nid LEFT JOIN term_hierarchy term_hierarchy2 ON term_node2.tid = term_hierarchy2.tid LEFT JOIN content_field_data_inizio node_data_field_data_inizio ON node.vid = node_data_field_data_inizio.vid LEFT JOIN content_type_corso node_data_field_sede ON node.vid = node_data_field_sede.vid WHERE (term_node.tid = '47') AND (term_node2.tid = '46') ORDER BY node_data_field_data_inizio_field_data_inizio_value DESC LIMIT 0, 10 in /var/www/vhosts/dev.service-store.com/httpdocs/includes/database.mysql.inc on line 172.

Comments

merlinofchaos’s picture

Project: Views (for Drupal 7) » Content Construction Kit (CCK)
Version: 5.x-1.6 » 5.x-1.5
Component: Code » Views Integration

Based upon the name of the field it's having trouble finding, this may be a CCK issue. If the field isn't getting added to the SELECT statement by the handler, it can't be set to sortable.

karens’s picture

Status: Active » Closed (won't fix)

The D5 version is no longer being supported. Sorry.