Forums

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

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

This topic contains 4 replies, has 2 voices, and was last updated by  jneto 1 year, 8 months ago.

  • 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
    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
    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)

You must be logged in to reply to this topic.

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

Yes No
sso for www.magecore.comsso for oroinc.comsso for oroinc.desso for oroinc.frsso for marketplace.orocommerce.comsso for marketplace.orocrm.com