Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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.
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).
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
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.
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.
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.
Comments
Comment #1
KarenS CreditAttribution: KarenS commentedYou'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.
Comment #2
bjmark CreditAttribution: bjmark commentedthank 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.
Comment #3
Gábor Mayer CreditAttribution: Gábor Mayer commentedthe input field of exposed date filter is doesn't show!
Comment #4
Gábor Mayer CreditAttribution: Gábor Mayer commentedthe exposed decimal field doesn't show too. i'd like to use it with unlocked operator.
Comment #5
jdm843 CreditAttribution: jdm843 commentedExperiencing same problem as bjmark. Date select fields do not appear when exposed filter "is between".
Comment #6
asb CreditAttribution: asb commentedHi,
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
Comment #7
kansaj CreditAttribution: kansaj commentedI 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
Comment #8
ruralrooster CreditAttribution: ruralrooster commentedI'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:
Comment #9
ruralrooster CreditAttribution: ruralrooster commentedNevermind, 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.
Comment #10
ruralrooster CreditAttribution: ruralrooster commentedOK. 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.
Comment #11
KarenS CreditAttribution: KarenS commentedThe D6 version is no longer supported.