creating report

This topic contains 2 replies, has 2 voices, and was last updated by trungnb 6 years, 11 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

May 19, 2017 at 3:28 am #29304

trungnb

Participant

I’m trying to create a new report in CRM but I don’t understand what is in the join clause.
I don’t know where the parameters (customerAssociation,account,status) are configured. please help me

source:
            type: orm
            query:
                from:
                    - { table: OroSalesBundle:Opportunity, alias: o }
                select:
                    - a.id
                    - a.name
                join:
                    inner:
                        - { join: o.customerAssociation, alias: c }
                        - { join: c.account, alias: a }
                        - { join: o.status, alias: s }
                groupBy:  a.id

source:

type: orm

query:

from:

- { table: OroSalesBundle:Opportunity, alias: o }

select:

- a.id

- a.name

join:

inner:

- { join: o.customerAssociation, alias: c }

- { join: c.account, alias: a }

- { join: o.status, alias: s }

groupBy: a.id

Creator
Topic

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

Author
Replies
May 19, 2017 at 3:36 am #29305

Mike Kudelya
Participant
Hi
These parameters are field names.
customerAssociation is a association in Opportunity entity.
account is a association in Customer entity.
May 21, 2017 at 9:07 pm #29306

trungnb
Participant
oh. thank you so much!
Author
Replies

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

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

OroCRM Forums