ssossossossosso

Forums

Forums OroCRM OroCRM – How do I? Questions Report builder problem

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

  • Creator
    Topic
  • #26396

    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
  • #26397

    Mike Kudelya
    Moderator

    Hi

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

    #26398

    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.

    #26399

    Mike Kudelya
    Moderator

    Hi

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

    #26400

    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.