i use View Calc to sum a cck field,when there is a exposed date filter,the date filter doesn't work
date version is 6.x-2.1
please see the pictures.

CommentFileSizeAuthor
error.JPG43.34 KBbjmark
good.JPG44.28 KBbjmark
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

KarenS’s picture

Assigned: bjmark » Unassigned
Status: Active » Postponed (maintainer needs more info)

You're not assigned to this unless you are planning to fix it yourself :)

It's not at all clear to me what 'doesn't work' means, even with the pictures. I need to to explain this better.

bjmark’s picture

thank you for your reply.

let me try to explain better.
see the error.jpg,there is a date widget just left to the apply button.
if select "is between",it should show two textfield for the begin date and end date.
but with Calc,it does not work.

i guess the javascript of date widget does not work with Calc.

Gábor Mayer’s picture

Status: Postponed (maintainer needs more info) » Active

the input field of exposed date filter is doesn't show!

Gábor Mayer’s picture

Version: 6.x-1.0 » 6.x-1.x-dev

the exposed decimal field doesn't show too. i'd like to use it with unlocked operator.

jdm843’s picture

Experiencing same problem as bjmark. Date select fields do not appear when exposed filter "is between".

asb’s picture

Hi,

confirming this issue for the stable release views_calc 6.x-1.3: All exposed filter don't work anymore if the view is switched from a plain table to the views_calc table display style. What means "don't work anymore"? In my case, the exposed filter operators still show up, but the input fields for values to filter are gone, so the view simply can't be filtered anymore. This is independent of the field type I'm trying to filter (be it date, number or plain text fields).

Greetings, -asb

kansaj’s picture

I confirm the problem with the date filter. When the date filter is enabled, the views calc provide as a result the value of without the filter no matter that the table is filtered.
I think should be seen also http://drupal.org/node/574142

ruralrooster’s picture

I'm using latest stable of all drupal 6, views 2, and views calc. I've tried 2 different ways to sort by a date field. Both ways work as ar as actual sorting, but I get the ugly red error box with the attached error.... repeated once for each node displayed in the view. My 2 methods are to use the weight changer for sort, and to simply use the sort option in the view. Both ways give me this:

warning: Invalid argument supplied for foreach() in /home/XXX/public_html/sites/all/modules/views_calc/theme.inc on line 178.
ruralrooster’s picture

Nevermind, that error was caused because i didn;t define a field to calculate. I was having some errors earlier that referenced a date field, but no longer get them.

ruralrooster’s picture

OK. I have the original error again. Note, I'm also using editable fields in this view. This only happens when I'm using a date type field as an sort variable:
user warning: Unknown column 'node_data_field_hard_deadline.field_order_placed_date_value' in 'where clause' query: SELECT DISTINCT node.nid AS nid, node.title AS node_title, node_data_field_clientaccount.field_clientaccount_nid AS node_data_field_clientaccount_field_clientaccount_nid, node.type AS node_type, node.vid AS node_vid, node_data_field_project_type_0.field_project_type_0_value AS node_data_field_project_type_0_field_project_type_0_value, node_data_field_hard_deadline.field_hard_deadline_value AS node_data_field_hard_deadline_field_hard_deadline_value, node_data_field_order_placed_date.field_status_0_value AS node_data_field_order_placed_date_field_status_0_value, node_data_field_order_placed_date.field_deposit_value AS node_data_field_order_placed_date_field_deposit_value, node_data_field_order_placed_date.field_payment_type_value AS node_data_field_order_placed_date_field_payment_type_value, node_data_field_quote_amount.field_quote_amount_value AS node_data_field_quote_amount_field_quote_amount_value, node_data_field_order_placed_date.field_sales_commision_value AS node_data_field_order_placed_date_field_sales_commision_value, node_data_field_order_placed_date.field_salesman_value AS node_data_field_order_placed_date_field_salesman_value, node.uid AS node_uid, node_revisions.format AS node_revisions_format FROM node node LEFT JOIN content_field_hard_deadline node_data_field_hard_deadline ON node.vid = node_data_field_hard_deadline.vid LEFT JOIN content_type_projects node_data_field_order_placed_date ON node.vid = node_data_field_order_placed_date.vid INNER JOIN content_type_projects node_data_field_project_type_0 ON node.vid = node_data_field_project_type_0.vid LEFT JOIN content_field_clientaccount node_data_field_clientaccount ON node.vid = node_data_field_clientaccount.vid LEFT JOIN content_field_quote_amount node_data_field_quote_amount ON node.vid = node_data_field_quote_amount.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE ((DATE_FORMAT(STR_TO_DATE(node_data_field_hard_deadline.field_hard_deadline_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2010-07-21' AND DATE_FORMAT(STR_TO_DATE(node_data_field_hard_deadline.field_hard_deadline_value, '%Y-%m-%dT%T'), '%Y-%m-%d') <= '2010-08-20') OR (DATE_FORMAT(STR_TO_DATE(node_data_field_hard_deadline.field_order_placed_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2010-07-21' AND DATE_FORMAT(STR_TO_DATE(node_data_field_hard_deadline.field_order_placed_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') <= '2010-08-20')) AND ((node_data_field_project_type_0.field_project_type_0_value = 'T-shirts') AND (node_data_field_project_type_0.field_status_0_value = 'Closed') AND (node.type in ('projects'))) ORDER BY node_data_field_hard_deadline_field_hard_deadline_value DESC in /home/XXX/public_html/sites/all/modules/views/includes/view.inc on line 775.

KarenS’s picture

Issue summary: View changes
Status: Active » Closed (won't fix)

The D6 version is no longer supported.