Hi ,

I am alter the views query with this

<?php
function cc_invoice_views_query_alter(&$view, &$query) {
    foreach (
$query->where[0]['clauses'] as $key => $value) {
     
$explode = explode('.',$value);
      if(
$explode[1] == "field_status_value = '%s'") {
        
$alias = $explode[0];
         if(
$query->where[0]['args'][$key] == '0') {
           
$query->where[0]['clauses'][$key] =  $alias . ".field_status_value IN ('%s' ,'%s')";
           
#$query->where[0]['clauses'][$count] =  $alias . ".field_status_value IN '%s'";
           
$query->where[0]['args'][] = -2;
         }
         elseif (
$query->where[0]['args'][$key] == '1') {
           
$query->where[0]['clauses'][$key] =  $alias . ".field_status_value IN ('%s' ,'%s')";
           
$query->where[0]['args'][] = 8;
       }
         break;
      }
    }
}
?>

In this code, I just altered the views query. the result is displaying rightly, but in the views calculation section, the subtotal and total is not rendering right. It does not add the altered value while calculating the total or sub-total. Is there anything else i need to correct here. Please advise.
Files: 
CommentFileSizeAuthor
views_calc.png36.62 KBj.lucky

Comments

Issue summary:View changes

Better format

Issue summary:View changes

Text change

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

The D6 version is no longer supported.