Changes between Version 1 and Version 2 of Ticket #27812


Ignore:
Timestamp:
Feb 6, 2017, 10:37:37 AM (8 years ago)
Author:
Fabio García Sánchez
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #27812 – Description

    v1 v2  
    1010debug_toolbar shows, effectively is grouping by "document_date", but I have just "tipo_documento" in values:
    1111{{{
    12 SELECT `biable_facturasbiable`.`tipo_documento`, SUM(`biable_facturasbiable`.`venta_neto`) AS `cosa` FROM `biable_facturasbiable` GROUP BY `biable_facturasbiable`.`tipo_documento`, `biable_facturasbiable`.`document_date` ORDER BY `biable_facturasbiable`.`document_date` DESC LIMIT 21
     12SELECT `biable_facturasbiable`.`tipo_documento`, SUM(`biable_facturasbiable`.`venta_neto`) AS `Total` FROM `biable_facturasbiable` GROUP BY `biable_facturasbiable`.`tipo_documento`, `biable_facturasbiable`.`document_date` ORDER BY `biable_facturasbiable`.`document_date` DESC LIMIT 21
    1313}}}
    1414
     
    2727
    2828{{{
    29 SELECT `biable_movimientoventabiable`.`tipo_documento`, SUM(`biable_movimientoventabiable`.`venta_neto`) AS `cosa` FROM `biable_movimientoventabiable` GROUP BY `biable_movimientoventabiable`.`tipo_documento` ORDER BY NULL LIMIT 21
     29SELECT `biable_movimientoventabiable`.`tipo_documento`, SUM(`biable_movimientoventabiable`.`venta_neto`) AS `Total` FROM `biable_movimientoventabiable` GROUP BY `biable_movimientoventabiable`.`tipo_documento` ORDER BY NULL LIMIT 21
    3030}}}
    3131
Back to Top