OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

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 8 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
  • #35963

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

    fehrudi
    Participant

    Hi,

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

    #35965

    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)

    #35966

    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.

    #35967

    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)

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

Back to top