Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Forums OroCRM OroCRM – How do I? Questions groupBy not included in datagrid report query.

This topic contains 1 reply, has 1 voice, and was last updated by  czaros45 1 year ago.

  • Creator
    Topic
  • #29393

    czaros45
    Participant

    Hello,
    for some reason groupBy isn’t included in datagrid report query.

    My datagrid report:

    And this results in following report:

    Getting grid data failed.
    Context: { “exception”: “Exception(Doctrine\\DBAL\\Exception\\DriverException): An exception occurred while executing ‘SELECT e0_.label AS label_0, e1_.city AS city_1, e2_.label AS label_2, COUNT(e3_.id) AS sclr_3 FROM vendor_sales_channel e3_ INNER JOIN vendor_sales_status e0_ ON e3_.status_name = e0_.name INNER JOIN vendor_sales_customer e4_ ON e3_.customer_id = e4_.id INNER JOIN vendor_sales_brand e2_ ON e3_.brand_name = e2_.name INNER JOIN vendor_sales_customer_address e1_ ON e4_.shipping_address_id = e1_.id WHERE e0_.label IN (‘aaaa’) AND e1_.city IN (‘Końskie’) AND e2_.label IN (‘test’) LIMIT 1′:\n\nSQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause” }

    Do you have any idea what may be wrong?
    Thank you in advance.

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #29394

    czaros45
    Participant

    Solved by changing the value of global variable “sql_mode” in database.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No
ssossossossossosso