OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

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 7 years, 2 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #29209

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

    Mike Kudelya
    Participant

    Hi

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

    #29211

    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.

    #29212

    Mike Kudelya
    Participant

    Hi

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

    #29213

    jneto
    Participant

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

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

The forum ‘OroCRM – How do I? Questions’ is closed to new topics and replies.

Back to top