ssossossossosso

Forums

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

Forums Forums OroPlatform OroPlatform – How do I? Questions Datagrid show joined records

This topic contains 4 replies, has 2 voices, and was last updated by  jakabadambalazs 2 years, 7 months ago.

  • Creator
    Topic
  • #30310

    jakabadambalazs
    Participant

    Hi,

    I have a project datagrid:

    where, I have one or more users assigned to the project(assignees).

    I’d like to show all user names (comma separated) in a certain column.

    I have created a column:

    and a template for it in which I want to loop the users and output firstName + lastName but it does not seem to work as I expect it to do(actually it does not work at all)

    {% set assignees = record.getValue(‘users’) %}
    {% set assignees = record.getValue(‘assignees’) %}

    these all return NULL.

    How can I do this?


    oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
    Replies
  • #30311

    fehrudi
    Participant

    Hi,

    Try record.getValue(‘assigneefullname’) or record.getValue(‘assigneeFullName’).

    #30312

    jakabadambalazs
    Participant

    Hi @fehrudi,

    Thanks, that works but it returns only the first user’s full name – not all of them


    oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

    #30313

    fehrudi
    Participant

    Hi,

    Sorry, ignore my post.. I missed the last part, I don’t know how to display those data in single cell/row.

    #30314

    jakabadambalazs
    Participant

    I have actually managed to make this work by using the GROUP_CONCAT function:

    it works ok – I did not have time to check on performance
    a\


    oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

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

You must be logged in to reply to this topic.