ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 4 replies, has 2 voices, and was last updated by  jneto 9 months, 3 weeks ago.

  • Creator
    Topic
  • #29744

    jneto
    Participant

    Hello, i’m trying to create a report and get a error . Why do i need to add other fields to the Grouping ?

    test

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
    Replies
  • #29889
    Mike Kudelya
    Mike Kudelya
    Oro Core

    Hi

    This happened because all non-aggregate columns must be set in group clause.

    #30012

    jneto
    Participant

    Hi, thanks for your reply ,

    but you answer is my question. Why do i need to add non-aggregate columns in the group clause. In SQL i don’t need.

    #30033
    Mike Kudelya
    Mike Kudelya
    Oro Core

    Hi

    What are you using, mysql or postgresql? Can you show me your sql ?

    #30478

    jneto
    Participant

    Thanks. Now i understand. I was adding the date to use in filters.

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.